Can excel run a text file as a macro?

martintallett

New Member
Joined
May 3, 2004
Messages
5
I have a Unix server that generates an Excel macro to load a file and then format it. The excel macro is a text file called anything you like ... the data file is a CSV file with a similar name but .CSV... Is it possible to persuade Excel to automatically run the macro contained in a text file without having to go through the process of manually loading and running the macro file?
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Thanks Nate, I can see how that would work. The only thing I am missing is a code fragment for a file dialog box in VBS !! :confused:
 
Upvote 0
Scrub my previous request :eek: no need for a file picker ... just run the text file as a VBS like you said . Hmmm Thanks again.
 
Upvote 0

Forum statistics

Threads
1,213,556
Messages
6,114,284
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top