Export data from Access to Specific Excel cells

Hi

I am currently using a transfer spreadsheet code to export a qry to a specific excel tab, however, I would like to export to a specific "starting" cell.

kwarden13Asked:
Who is Participating?
 
Mike EghtebasConnect With a Mentor Database and Application DeveloperCommented:
Generally speading, a code like:

DoCmd.TransferSpreadsheet acExport,...

should do it. But a more relaible method is to define Excel object and assign the desired values in one or more cells in excel.

If you could describe your use, we can choose the best solution for you.

Mike
0
 
Mike EghtebasDatabase and Application DeveloperCommented:
-What version of access your are using?
- Will be the code runing to transfer data from a remote database or from the local database

Mike
0
 
kwarden13Author Commented:
the local database

From access 2007 to excel 2007

right now I am using the below code

DoCmd.TransferSpreadsheet acExport, , "qryDelRepCAN", "J:\data\Manager\Test.xlsx", True, "Canada"

Canada is the named range
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
kwarden13Author Commented:
the issues is the named range

So the qry data can either expand or contract depending on the data so I need a dynamic named range. However when I try to do this it still doesnt work
0
 
Mike EghtebasDatabase and Application DeveloperCommented:
I guess you have another question on this subject.

brb
0
 
kwarden13Author Commented:
yes i originally thought it was a seperate issue but i think they are linked
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.