P
Paul
I am calling to create an Excel report within an Access application. Why
ActiveCell statement fails in a vba loop only in the SECOND attempt?
Set objXL = New Excel.Application
With objXL
.Visible = True
Set objWkb = .Workbooks.Add
Set objSht = objWkb.Worksheets(1)
With objSht
.Name = "Pull Sheet"
'Format WorkSheet and assign Store #, Name to Excel
.Columns("A:A").Select
ActiveCell statement fails in a vba loop only in the SECOND attempt?
Set objXL = New Excel.Application
With objXL
.Visible = True
Set objWkb = .Workbooks.Add
Set objSht = objWkb.Worksheets(1)
With objSht
.Name = "Pull Sheet"
'Format WorkSheet and assign Store #, Name to Excel
.Columns("A:A").Select