Creat an EXE or BATCH file (1 Viewer)

Ben_Entrew

Registered User.
Local time
Today, 07:17
Joined
Dec 3, 2013
Messages
177
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

bit cruncher
Local time
Today, 07:17
Joined
Mar 17, 2004
Messages
8,178
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.
 

Users who are viewing this thread

Top Bottom