What has changed?

[Jack]

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*

[Bob Phillips]

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" <[email protected]> wrote in message
news:[email protected]...
> 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*

[Chip Pearson]

> 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" <[email protected]> wrote in message
news:[email protected]...
>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*

[Jack]

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" <[email protected]> wrote in message
> news:[email protected]...
> >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*
>
>
>

[Bob Phillips]

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > >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*
> >
> >
> >