How to reference to other Excel application in VBA

[Łukasz Szczepański]

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,

[Tom Ogilvy]

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,

[Łukasz Szczepański]

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,

[Tom Ogilvy]

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,

[Łukasz Szczepański]

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,

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy


"Łukasz Szczepański" wrote:

> 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,

[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.