Creat an EXE or BATCH file

[Ben_Entrew]

Hi all,

is there a way to create some sort of an EXE or BATCH file in any Windows Explorer folder, that executes me a specific Excel Macro?

My problem is that I got several files split up by Departments, updated every day.
So far I have to open each file and update the format.
It would make my life much more easier if I could just run a file that opens each file and applies a format to them.

Thanks in advance.

Regards,
Ben

 

[MarkK]

Google ".vbs script file" You can run scripts in the windows environment with code that looks a lot like VBA to do the kind of stuff you are talking about here.