Cannot get reference to excel

Add-in Express™ Support Service
That's what is more important than anything else

Cannot get reference to excel
 
Andrew Saunders




Posts: 17
 Joined: 2006-03-21
Hello everybody,

I am using add-in express for the first time and am building an excel add-in (I am using excel 2000). I don't seem to be able to get a reference to excel - it returns nothing.

In particular I am building a wizard into my add-in and on one of the wizard panels I wish to get the current excel cell address into a textbox. How do I do this?

I have tried the following function to get the cell address but it just returns nothing.

Private Function GetSelectedRange() As Excel.Range

Dim excelApp As Excel._Application = HostApplication
Return excelApp.Selection

End Function

All help is appreciated.
Thanks.
Posted 21 Mar, 2006 01:23:57 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
 Joined: 2004-07-05
Hi Andrew.

Please look at our ADX Toys for Excel example. I think it will help you.
http://www.add-in-express.com/downloads/free-addins.php
Posted 21 Mar, 2006 13:38:10 Top