reading workbooks across multiple excel applications

[jmoffat]

When downloading an .xls document from the WEB it invariably starts
new application of excel - thus I have two Excels running at the sam
time - my orginal containing a workbook which has my macros and a ne
one which contains the workbook I am interested in (calle
web_sheet.xls)


Clearly

windows("web_sheet.xls").activate

causes an error - because when run from my original excel, this windo
does not exist.

Any ideas

 

[Guest]

hi,
I think you will have to save and close the xl session
that the download created. then add this to your code.

Workbooks.Open Filename:="\\filepath\web_sheet.xls"
your activate command is correct but not needed.