Home Community Discussion Forums Most Active Software Boards LabVIEW Topic

LabVIEW

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

ActiveCell of Excel2000 workbook from LV

ActiveCell of Excel2000 workbook from LV

‎04-21-2002 05:07 AM

I need to read the ActiveCell address from LV using ActiveX, can someone
help?
Thanks
Ladislav
0 Kudos
Message 1 of 3
(2,375 Views)
Reply

Re: ActiveCell of Excel2000 workbook from LV

‎04-21-2002 05:27 AM

There are good examples in LabVIEW.
Click to Help\Examples\Communication\ActiveX
0 Kudos
Message 2 of 3
(2,375 Views)
Reply

Re: ActiveCell of Excel2000 workbook from LV

‎04-21-2002 11:05 PM

The Activecell is an Application-specific object, it is not available using a Workbook or Worksheet references.

From the RefNum for Excel._Application, wire up a Property:Activecell then wire that output to a Method:Address. The returned result will be a string containing the Activecell's address. Several formatting options are available.

-Michael
Michael Munroe, CLD, CTD, MCP
Automate 1M+ VI Search, Sort and Edit operations with Property Inspector 5.0, now with a new Interactive Window Manager!
Now supports full project automation using one-click custom macros or CLI.
Message 3 of 3
(2,375 Views)
Reply