have you tried to use GetObject. See excel vba help for details.

--
Regards,
Tom Ogilvy


"Łukasz Szczepański" wrote:

Hi,

I would like to copy some data to my spreadsheet from workbook which is
opened from web. The problem is that "Export to Excel" button always opens
new Excel application, so I can't reference to new workbook from VBA.

How can I check other running applications and how to copy data from other
Excel application to my workbook?

Thanks in advance,