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* |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
What has changed?
Cell is not anj object, and you should properly qualify it perhaps
Dim objXL As Excel.Application Dim wkbXLBook As Excel.Workbook Dim wksSheet As Excel.Worksheet Dim ExcelWasNotRunning As Boolean . Dim r As Excel.Range Dim cl As Excel.Range -- HTH RP (remove nothere from the email address if mailing direct) "Jack" wrote in message ... 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* |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
What has changed?
Dim cl As Cell *This no longer compiles / works*
There is no object in Excel named "Cell". Use "Range" instead. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Jack" wrote in message ... 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* |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
What has changed?
Thanks guys, never thought of applying a single cell range as a pointer to an
individual cell ie (a1:a1) was too busy looking for reasons why something that worked in a previous incarnation failed! "Chip Pearson" wrote: Dim cl As Cell *This no longer compiles / works* There is no object in Excel named "Cell". Use "Range" instead. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Jack" wrote in message ... 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* |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
What has changed?
I fail to see how it could have worked in a previous incarnation, cell is
not a object data type. -- HTH RP (remove nothere from the email address if mailing direct) "Jack" wrote in message ... Thanks guys, never thought of applying a single cell range as a pointer to an individual cell ie (a1:a1) was too busy looking for reasons why something that worked in a previous incarnation failed! "Chip Pearson" wrote: Dim cl As Cell *This no longer compiles / works* There is no object in Excel named "Cell". Use "Range" instead. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Jack" wrote in message ... 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* |
Reply |
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 |