Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OLE automation - use of .selection
Dear Excel users,
I'm having problems trying to use the .selection property from VB code within an MS Access module. It doesn't seem to be available! It's available within Excel. I want to sort a spreadsheet using OLE automation. The code for doing this within Excel selects the range and uses the '.selection' property for executing the sort. This property doesn't show up in the 'intellisense' options and an error is generated when I attempt to use it. Any ideas on what's going on, or how to execute a spreadsheet sprt using automation, would be gratefully received. Thanks. Richard Abrahams |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
OLE automation - use of .selection
assume your reference to the excel application is oxlapp
then do oxlapp.Selection -- Regards, Tom Ogilvy "Richard Abrahams" wrote in message om... Dear Excel users, I'm having problems trying to use the .selection property from VB code within an MS Access module. It doesn't seem to be available! It's available within Excel. I want to sort a spreadsheet using OLE automation. The code for doing this within Excel selects the range and uses the '.selection' property for executing the sort. This property doesn't show up in the 'intellisense' options and an error is generated when I attempt to use it. Any ideas on what's going on, or how to execute a spreadsheet sprt using automation, would be gratefully received. Thanks. Richard Abrahams |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limiting selection in a cell AND linking that selection to a list | Excel Discussion (Misc queries) | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
Identifying a selection of a selection of a range | Excel Worksheet Functions | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions | |||
Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. | Excel Programming |