You need Application.Run! Look it up in Help and using Google it in this
newsgroup. Examples abound!

"Haim" wrote in message
...
Hi,

I'm working with Excel files as follow:

Main Excel file with one Visual Basic macro.
This macro:
- Open other Excel files
- Run program (the VB commands are from the main file)
- Close and save
- Going to the next file. and so on, for all files.

My question:

I have Visual Basic macro in the other files (not in the
main) - Called RSI

I would like to write from the Main program:
- Open file "abc" (I know how to do that)
- Run RSI (this is my question, how to write it)
and after finish RSI, bring back the control to
the Main program.

Again, the RSI is Not in the Main Excel file
But I would like to call RSI from the Main program

I tried Call RSI but it did not work.

Thank you,

Haim.