VBA Excel Automation

[Guest]

Hello,
I have created a macro in Excel, I'm trying to put the same functionality in
Access VBA. It compiles fine, but I'm getting errors. Error 1004. Method
'Cells' of object 'Global' failed.

Can someone help me modify this syntax?

'Goal is to clear contents from row 2 down.
Set objClosed = objXLBook. _
Worksheets("Closed")
LastRow2 = Cells(Cells.Rows.Count, "A").End(xlUp).Row

Rows("2:" & LastRow2).Select
Cells.Select
Selection.Delete Shift:=xlUp
Selection.ClearContents

I also want to goto the Closed1 tab, select all active rows from Column A to
Column Q , and paste to tab closed, starting at Row2, column A.

Any assistance or direction you can give me is appreciated.

Thank you,
David

 

[Alex Dybenko]

Hi,
in any other VBA host other then Excel you have to specify "base" object for
all excel methods:

objClosed.Cells()
objXLBook.Selection

etc

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com