View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jack jack is offline
external usenet poster
 
Posts: 186
Default 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*