Macros

In the days before the internet I would have recommended a book.  But now I can find all the informations / tutorials I need on the web.

However, here are some pointers (these are methods I used when learning):

• I am sure that you are aware that you can record an macro.  Record a set of actions which you want to include in the macro, open the module and review the macro code generated.  This should give you a good idea of how to automate the actions.
• A basic knowledge of programming is useful.  I.e. how to assign values to variables, perform conditional branching (if, then, else) and loops.  There are many tutorials for this on the web, make sure you choose one that is in Visual Basic for Applications (VBA).
• Part of the problem is always understanding the object model of the application, i.e. how to address the parts of the application, for example how do you set the value of a cell?).  While the help is available on the web, you should make sure that the VBA help is installed (by default, it is often not installed).  To do this, you will need the Microsoft Office install disk, and re-run the install selecting the option to change installed components and then choose a custom install so that you can specify to install the VBA help.

If you require further help, please contact me.

Regards,

Jason

I used "VBA for Applications in 21 Days"

It took more than 21 days, and I never actually finished, but it got me far enough in to be programming some fairly complex stuff

Hi, We have made many commercial tools in excel & word  and can help you in making Macros and VBA in Excel & Word

Find Replace in multiple Excel files (xls, xlsx) in Batch process like
http://www.lantechsoft.com/excel-find-replace-batch.html

Also visit our other tools

http://www.lantechsoft.com/excel-addins.html

Also make Office Automation tools

http://www.lantechsoft.com/office-automation.html

Incase you need any Tool or macro mail us at info@lantechsoft.com or visit www.lantechsoft.com