LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
Don Don is offline
external usenet poster
 
Posts: 487
Default How to access Application Ojbect of the Current Excel Window i

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" wrote in message
...
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






 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Restore Excel Application Window after proccesing ... Vlado Sveda Excel Programming 1 October 11th 06 06:59 PM
How do I open a new window for each excel application? Kris New Users to Excel 2 February 21st 06 09:59 PM
How to set Excel to open a new window for each application Luke Excel Discussion (Misc queries) 1 September 28th 05 11:50 PM
hiding / displaying the excel application window JulieD Excel Programming 2 August 15th 04 04:36 PM


All times are GMT +1. The time now is 11:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"