In excel, how can I programmatically import and run a macro?

Question

It can be done manually by F11 Import Run, but I want to do this automatically (probably from an Auto_Open macro).

I really do mean IMPORT. Another pogram has just emitted a text file macro, now I want to run it.

Answer 1

I set this one up on my PC a long time ago, but here's the open/run bit...

Sub Auto_Open()
Application.Run "MyFile.csv!Menus"
End Sub

Along with a scheduled task to open "MyFile.csv" at a particular time every day.

Set Excel security settings to low, and maybe add to your anti-virus OK list?

Hope that works for you.