transfer spreadsheet macro

[wbalbion68]

Hi everyone,
I have created a macro to transfer a query from access to
excel(TransferSpreadSheet). It works fine, but, I need it to start the data in a particular cell on the excel sheet ie D7.Any advice?

Kind regards

 

[lars7]

Hi wbalbion68,

If you reopen your macro and go to the last argument "Range"
then read the action argument to the right it will tell you what to do.

 

[wbalbion68]

Thanks Lars for your quick response. Tried your suggestion and entered the the range ie D7:G200. However, after clicking the button, to which the macro is attached, I get an error message "Table D7:G26 already exists".

Regards,