I recorded a macro in Excel that I am calling from Access. However, the Macro is not working on the required worksheet.
I need to make 'qryTransfer1' the active worksheet before the range I have is selected.
I tried
But I need to add something to the procedure.
Can anyone help?
Thanks in advance
I need to make 'qryTransfer1' the active worksheet before the range I have is selected.
I tried
Code:
qryTransfer1.Activate
But I need to add something to the procedure.
Can anyone help?
Thanks in advance