Hi,

I have a very basic need, and I cannot seem to find it address ANYWHERE on
the net.

I need to get access to the application object that is CURRENTLY OPEN.

I find tons of code that says use:

Excel.Application obj = new Excel.Application();

This starts a new Excel application, and that does me no good. I want to
access the active excel spreadsheet. I have found no examples or articles or
questions regarding this and it's been quite frustrating.

Just to be clear, I want something like:

Excel.Application obj = Excel.ActiveAppliation();

or

Excel.Application obj = Excel.CurrentApplication();

-Don

Don: there ared two methods I use when I get frustrated the way you are which
is quite often with excel.

1) I add a statement into excel
Set Myappl = Application
The I set through the instruction and add Myappl to the watch window by
right clicking on Myappl in the code. This gives me a view of all the
methods that are accessable and the parameters assigned to them. Most likely
you will find under applications items and one of the items is the open
application
Application can be added to the watch window manually by just typing
Application as a new watch. OPen Watch window from Debug Menu then roght
click on watch window to add items.

Below doesn't work for application. You need to specify a type of
application that you would find in the watch window.
2) Use this code below which gets all the items
for each MyAppl in Application
'you may need to filter out some applications
'
if instr(MyAppl.name,"App name) > 0 then
'add your code here
end if
next MyAppl

In this case

"Don" wrote:

> Hi,
>
> I have a very basic need, and I cannot seem to find it address ANYWHERE on
> the net.
>
> I need to get access to the application object that is CURRENTLY OPEN.
>
> I find tons of code that says use:
>
> Excel.Application obj = new Excel.Application();
>
> This starts a new Excel application, and that does me no good. I want to
> access the active excel spreadsheet. I have found no examples or articles or
> questions regarding this and it's been quite frustrating.
>
> Just to be clear, I want something like:
>
> Excel.Application obj = Excel.ActiveAppliation();
>
> or
>
> Excel.Application obj = Excel.CurrentApplication();
>
> -Don

Have you tied this?

http://msmvps.com/blogs/pauldomag/ar.../15/86417.aspx

Tim

"Don" <(E-Mail Removed)> wrote in message
news:764DD568-F0FF-473D-B30B-(E-Mail Removed)...
> Hi,
>
> I have a very basic need, and I cannot seem to find it address ANYWHERE on
> the net.
>
> I need to get access to the application object that is CURRENTLY OPEN.
>
> I find tons of code that says use:
>
> Excel.Application obj = new Excel.Application();
>
> This starts a new Excel application, and that does me no good. I want to
> access the active excel spreadsheet. I have found no examples or articles
> or
> questions regarding this and it's been quite frustrating.
>
> Just to be clear, I want something like:
>
> Excel.Application obj = Excel.ActiveAppliation();
>
> or
>
> Excel.Application obj = Excel.CurrentApplication();
>
> -Don

Hi Joel,

Thanks for the response. It's unfortunate that the title of my post got cut
short. It ended in "in C#".

What you suggested works perfectly in VBA editor using VB.NET. The problem
is, when using VS2005 and C#.NET, there is no "Application" that you speak
of. If I could get the functionality that exists in VB into C#, I'd be happy,
but so far I see no way to do it.

"Application" as you mentioned it is exactly what I'm trying to locate in C#.

"Joel" wrote:

> Don: there ared two methods I use when I get frustrated the way you are which
> is quite often with excel.
>
> 1) I add a statement into excel
> Set Myappl = Application
> The I set through the instruction and add Myappl to the watch window by
> right clicking on Myappl in the code. This gives me a view of all the
> methods that are accessable and the parameters assigned to them. Most likely
> you will find under applications items and one of the items is the open
> application
> Application can be added to the watch window manually by just typing
> Application as a new watch. OPen Watch window from Debug Menu then roght
> click on watch window to add items.
>
> Below doesn't work for application. You need to specify a type of
> application that you would find in the watch window.
> 2) Use this code below which gets all the items
> for each MyAppl in Application
> 'you may need to filter out some applications
> '
> if instr(MyAppl.name,"App name) > 0 then
> 'add your code here
> end if
> next MyAppl
>
> In this case
>

That's exactly that I needed!

Thanks Tim

"Tim Williams" wrote:

> Have you tied this?
>
> http://msmvps.com/blogs/pauldomag/ar.../15/86417.aspx
>
> Tim
>
> "Don" <(E-Mail Removed)> wrote in message
> news:764DD568-F0FF-473D-B30B-(E-Mail Removed)...
> > Hi,
> >
> > I have a very basic need, and I cannot seem to find it address ANYWHERE on
> > the net.
> >
> > I need to get access to the application object that is CURRENTLY OPEN.
> >
> > I find tons of code that says use:
> >
> > Excel.Application obj = new Excel.Application();
> >
> > This starts a new Excel application, and that does me no good. I want to
> > access the active excel spreadsheet. I have found no examples or articles
> > or
> > questions regarding this and it's been quite frustrating.
> >
> > Just to be clear, I want something like:
> >
> > Excel.Application obj = Excel.ActiveAppliation();
> >
> > or
> >
> > Excel.Application obj = Excel.CurrentApplication();
> >
> > -Don
>
>
>