Quote:
Originally posted by Thai
Hrm I have never used an Excel macro.. are you saying I can record a macro then put the code it generates into VB and vb will do exactly what I did to the excel file when I run it in vb?
Thanks for bearing with me ;),
Thai
Yep. You will need to modify the generated code (make it point to the correct VB objects) but this is the quickest way to do Excel stuff in VB (especially if you don't know much about Excel, you get someone who does to make you a Macro and then move the code).