Open external .xls file

[deltaair]

What statement should I write in a macro to open an external .xls file. Any directions / precautions for the path would also be helpful....

Right now, my macro can't open the file, it assumes that the file is open and then "activates" that window.

Please let me know ASAP.

 

[PHV]

Have a look at the Open method of the Excel.Workbooks object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886