Unfurtunately it gets only the application from which it is executed.
Is there something like "GetNext"?

Thanks

"Tom Ogilvy" wrote:

set o = GetObject(,"Excel.Application")
? o.Caption
Microsoft Excel


Assuming you don't have multiple instances of Excel open except the one you
are trying to get and the instance in the web page. I would assume the
instance in the web page would not be detected by GetObject, but I haven't
test it.

--
Regards,
Tom Ogilvy



"Łukasz Szczepański" wrote:

Yes, but I failed. I have no idea what arguments should I use

GetObject([pathname] [, class])

A new workbook is not saved at the stage I would like to access it, and file
name is random (but hopefully with the same prefix).

Thanks,

Lukasz

"Tom Ogilvy" wrote:

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,