Hi all,
I currently have an Access macro that uses CopyFromRecordset to copy query data to a specific cell in an Excel sheet. I now want to automatically run an Excel macro that manipulates that data.
How do I move the cursor from A1 to the first cell of the new data, as that’s where my excel macro must begin from?
I’m pasting this data at the end of a long dataset in Excel using:
nextrow=ws.Range(“A” & ws.rows.Count).End(-4162).row+1
Then using CopyFromRecordset with range (“A” &nextrow)
I currently have an Access macro that uses CopyFromRecordset to copy query data to a specific cell in an Excel sheet. I now want to automatically run an Excel macro that manipulates that data.
How do I move the cursor from A1 to the first cell of the new data, as that’s where my excel macro must begin from?
I’m pasting this data at the end of a long dataset in Excel using:
nextrow=ws.Range(“A” & ws.rows.Count).End(-4162).row+1
Then using CopyFromRecordset with range (“A” &nextrow)