Macros

Hi, 

For sometime now I am trying to learn Macros and give up as it gets complicated. I don't know much about Macros ( just some basics) and still looking for a good book to learn Macros from scratch and master it.. Would anyone recommend any books or learning CDs? 

Thanks in advance

 

 

Comments

Macros

jason.raikes | | Permalink

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

ACDWebb's picture

Years back

ACDWebb | | Permalink

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

Incase You need Help in Excel Macros or VBA we can Assist

Techno | | Permalink

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

Add comment
Log in or register to post comments
Group: ExcelZone
A gathering place for the Excel community to explore new ideas and techniques and a forum to debate product features and best practices.