Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What has changed?
I am using the excell 10 lib from MS Access to reference excel worksheets.
My code, which worked in previous incarnations, now falls over! The lib no longer recognises CELL or CELLS, any clues? Dim objXL As Object ' Variable to hold reference to Microsoft Excel. Dim wkbXLBook As Excel.Workbook Dim wksSheet As Excel.Worksheet Dim ExcelWasNotRunning As Boolean ' Flag for final release. Dim r As Excel.Range Dim cl As Cell *This no longer compiles / works* |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks being changed | Excel Discussion (Misc queries) | |||
Hyperlink changed??? | Excel Worksheet Functions | |||
Format changed when the details in cell changed | Excel Worksheet Functions | |||
Changed Links | Links and Linking in Excel | |||
Code - if T changed, change date in W to date it is changed | Excel Programming |