Open Batch Of Files And Run VBA On Each File

Hewlett-packard Ms office 2003 pro
January 7, 2010 at 20:39:24
Specs: Windows XP, 1024
Every month, I have to generate new reports and format them manually. The report format is the same, but content is different. I want to know are there anyway I can run specific of vba on each excel file opened to format them.

For Example,

Open file 1
run macro

Open file 2
run macro

Open file n
run macro

and so on...

Thank You in Advance.


See More: Open Batch Of Files And Run VBA On Each File

Report •


#1
January 9, 2010 at 06:07:37
I want to know are there anyway I can run specific of vba on each excel file opened to format them.
Yes, there are a few ways. I'd probably do it though a VBScript, but you could use VBA.

Report •

#2
January 9, 2010 at 12:27:34
Thank You. I just found a script online which does what I want.

Report •

#3
April 2, 2010 at 16:19:29
Hey! sounds alittle like my problem - Where did you find the code?

Report •

Related Solutions


Ask Question