Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Excel references in another program

Unless you create a reference to the Excel object library, the app won't
know what the definition of the constants are.

It can late bind without a reference and find out what the objects and so
forth are.

I haven't tried it but see what happens if you do

ObjExcelApp.ActiveCell.SpecialCells(Excel.Constant s.xlLastCell).Select

in your current code.

--
Regards,
Tom Ogilvy

Ferd wrote in message
...
When I run commands like:

ObjExcelApp.ActiveCell.SpecialCells(xlLastCell).Se lect

in Excel, they work fine. But when I try to run this
command in a Sax Basic program, calling it from another
program (SPSS), it doesn't understand "xlLastCell".

Is there some way of making SPSS understand these Excel
references?



Reply
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
Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene LunaMoon Excel Discussion (Misc queries) 0 July 28th 08 11:03 PM
Excel references within references? Mike Excel Discussion (Misc queries) 8 January 30th 08 12:58 AM
Help with converting a block of cells with Absolute and mixed references to relative references Vulcan Excel Worksheet Functions 3 December 13th 07 11:43 PM
How to rename references from range names to cell references Abbas Excel Discussion (Misc queries) 1 May 24th 06 06:18 PM
Excel references in another program JohnI in Brisbane Excel Programming 0 September 9th 03 03:30 AM


All times are GMT +1. The time now is 06:16 PM.

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

About Us

"It's about Microsoft Excel"