How to reference to other Excel application in VBA

[Guest]

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,

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

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

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

 

[Guest]

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

Thanks

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

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

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

--
Regards,
Tom Ogilvy


:

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,

 

[Guest]

No, there really isn't any latitude or control if you don't know the document
name.

--
Regards,
Tom Ogilvy

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

Thanks

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

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

:

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

--
Regards,
Tom Ogilvy


:

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,

 

[Travich]

I am having the same problem. The problem is that the get object
actually access the workbook, but I can't "activate" the workbook. I
get an error 50290 when I try to do so. Also, in the watch window, the
workbook never appears under application. How do I get it to appear
under there? I mean, the work book is already open, so I can't "open
it" again. This is very frustrating.

A little background, I'm simply trying to have a buttom that says
"populate report." A new report in a NEW instance of the Excel
Application opens and the report is populated in this window. The
problem is that I can get the workbook, but I can't programmatically do
things like "activate" and that's driving me nuts... Glad to hear any
suggestions.