reading workbooks across multiple excel applications
 

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

--
Message posted from http://www.ExcelForum.com

reading workbooks across multiple excel applications
 

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.

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


Clearly

windows("web_sheet.xls").activate

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

Any ideas ?


---
Message posted from http://www.ExcelForum.com/

.