Importing to Excel in defined cells

[Guest]

Hi, I have a template spreadsheet in excel that I want users to complete, I
have managed to import from the spreadsheet into Access which is great, but
now I need to understand how I can export my query into excel but I need
specific fields to be imported on to specific cells.

example in my query I have
Reference No. this needs to go into cell E6
Name this needs to go into cell E8
Address this needs to go into cell E9 and so on. How is this possible to be
done from the click of a command button on a form?

Thanks for any help, Jez

 

[pietlinden]

Hi, I have a template spreadsheet in excel that I want users to complete, I
have managed to import from the spreadsheet into Access which is great, but
now I need to understand how I can export my query into excel but I need
specific fields to be imported on to specific cells.

example in my query I have
Reference No. this needs to go into cell E6
Name this needs to go into cell E8
Address this needs to go into cell E9 and so on. How is this possible to be
done from the click of a command button on a form?

Thanks for any help, Jez

Read the Excel stuff at www.mvps.org/access in the modules section.