Pull info from excel workbook located on another computer.

[westwegoman]

I am trying to retrieve data that is located in a excel file. The problem is the file resides on another computer within the network. I have been able to get it to work as long as the 2 files are located in the same folder on the same computer, but I need it to get it from where it resides normally. Another problem is I cant figure how to make it look for the right file for that month. The source file is generated automattically and always has the same name but resides in a folder named after the month on the other computer.

An example of the file location would be..
Twm2\c\Documents and Settings\water\2010\May\EBOpsLedger.xls
The month would change every month.

This is what I have so far:

Please Login or Register  to view this content.

Any help would be greatly appreciated.
Thanks in advance,
Merv.

[protonLeah]

See:
http://www.excelforum.com/excel-prog...a-network.html

[westwegoman]

I was able to get most of it to work. I just cant get the window to come back up after it closes the source file. It keeps excel minimized to the taskbar after the macro runs.

Please Login or Register  to view this content.