Where would be a good place to start learning how to set up macros?

[darkrose50]

I work in tech support and I have a list of duplicate tickets on an Excel Workbook that can be closed out of my system (from my last post, thank you all for helping out!).

Now I know that a macro can be used to automate tasks. In fact I see it done by a co-worker (not the same, but similar tasks) whom I want nothing to do with as he is staling from the company.

Where would be a good place to start learning how to set up a macro to automate tasks starting from Excel (or anyplace else)?

 

[Hasit]

I am not a VBA expert by any stretch of the imagination, but the easiest way would be to record a macro and then edit it to see how VBA is written.

Other options including of course learning VBA or picking up freeware (or shareware) utilities that may do what you want....

HTH

 

[xlhelp]

My

worth.

by John Walkenbach is an excellent book.

For more info:

http://www.j-walk.com/ss/books/bookxl16.htm

 

[tido213]

Do not take the idea of using the Dummies books as an insult they are a good starting point for most topics they cover.

 

[avayaman]

I did it by recording & examining the code. Took a couple of years, but I'm getting pretty good at it.

 

[Chris22]

Have a look here.

I find it very useful and Martin is a very helpful guy.

http://www.fontstuff.com/index.html

Regards,

Chris