Need to paste a recordset into Excel starting at a specific row and column
I'm having a brain cramp this afternoon!
In my Access application, I need to write a number of recordsets to specific locations on an Excel worksheet, but the upper left cell in each instance will be dynamic. Why does this work:
In my Access application, I need to write a number of recordsets to specific locations on an Excel worksheet, but the upper left cell in each instance will be dynamic. Why does this work:
oSht.Range("A2").CopyFromRecordset rs
oSHT.Range(oSHT.Cells(rsItems!Row, rsItems!Col)).CopyFromRecordset rsData
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Dale
.Cells() is (returns) a range object.
.Cells() is (returns) a range object.
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
Nope, thought I had to use a range. but that worked like a charm!