macro to open file, run macro, close help!

[lotsbg]

I have a program which opens a file and closes it, easy.

But what I need it to do, is after opening to run a macro that the file has.

So for example, I have test.xls.

Workbooks.Open Filename:= _
"C:\belgium1.xls"

** In here i need code that will run the module insert.insertstuff that is a module of belgium1.xls (not test.xls) **

ActiveWorkbook.Save
ActiveWorkbook.Close

Any help would be fantastic. Thanks

 

[jindon]

Hi

Try

Application.Run "belgium1.xls!insert"
Application.Run "belgium1.xls!insertstuff"