Hi,

Sorry.

I did not understand the answer.

What is Application.Run?
(Did not find this VB command in the VB help)

Also, did not understand what you mean
when you wrote:
"using Google it in this newsgroup. Examples abound!"


Thank you.


-----Original Message-----
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.






.