Macro

Visual Basic Development Resources arranged by category

Rating

Very Simple Job Excel - Vba - Macro

Posted by bidscc.com on February 10, 2011

Very simple job Excel - VBA - Macro - Visual Basic - VB Please see the attached spreadsheet with all details. Thanks Related posts:Looking For A Developer... [read more]

Rating

NEED BASIC EXCEL REPORTING SHEET MAYBE VBA / MACRO

Posted by bidscc.com on February 7, 2011

HI HERE IS THE PROJECT. MY BOSS HAS +/- 40 SHOPS. THERE ARE +/- 11 MANAGERS. EACH MANAGER MANAGES +/- 2 TO 5 SHOPS. EVERY WEEK MY COLLEAGUE RECEIVES ... [read more]

Rating

Excel install a 15 day trial to it to put it in the internet

Posted by bidscc.com on February 11, 2011

I have a program i made in excel i want to install it on my web site Related posts:Very Simple Job Excel – Vba – Macro Very simple job Excel - V... [read more]

Rating

Find And Replace String Using VBA Code

Posted by keen on December 27, 2009

There are several ways to replace string using VBA code,  by looping each cell or by using VBA Replace function. Let's say that we want to replace "Macros... [read more]

Rating
 

Outlook Close Loop - Macro Development

Posted by GeorgeH on January 26, 2011

I caused myself some troubles when developing a Macro for Microsoft Outlook 2007, where part of the code was to close the active Inspector after completing a se... [read more]

Rating

Macro in excel with shapes

Posted by bidscc.com on February 9, 2011

Hi, I need to copy the text from shapes within some ranges of a sheet in excel and paste in other ranges. There are 9 ranges that will be filled with shap... [read more]

Rating

Need excel macro to delete title rows in last page in print

Posted by bidscc.com on February 2, 2011

Need an excel macro expert to suppress/delete the printtitle rows in the last page of excel spreadsheet while printing/print preview Hi, I need either an ex... [read more]

Rating

Paypal CSV Invoice Processing Tool/Macro

Posted by bidscc.com on February 1, 2011

The goal from this project is to automate invoice creation and sending invoices from all the transactions from paypal .csv file. This script/software/macro y... [read more]

Rating

17 ways to Optimize VBA Code for FASTER Macros

Posted by Ayush Jain on December 27, 2010

Here is a summary of the article:Do read full article to understand the logic behind them. 1. Analyze the Logic 2. Turn off ScreenUpdating 3. Turn off 'Autom... [read more]

Rating

Data Alignment

Posted by keen on March 5, 2009

In Excel VBA macro we can control the alignment of data in a cell, both horizontally and vertically. To change alignment, we can use the following properties of... [read more]

Rating

Function to find Unique Items in a list

Posted by AutoGrid on May 12, 2009

It happens many times when you are writing a Macro and you need to find the unique items out of the a range of items. Suppose you have an excel sheet that ha... [read more]