Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel references in another program
Ferd,
Someone may have a better solution, and I'll be interested to see it too. My workaround is to define the XL variable in the other App, e.g. - Const xlLastCell As Integer = 11 You can get the value by doing "?xlLastCell" in the Excel VBE immediate window & you'll see the value is 11. regards, JohnI "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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert all 3d references to normal references in a workboo | Excel Discussion (Misc queries) | |||
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 | Excel Discussion (Misc queries) | |||
Excel references within references? | Excel Discussion (Misc queries) | |||
Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
How to rename references from range names to cell references | Excel Discussion (Misc queries) |