kwarden13
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
From access 2007 to excel 2007
right now I am using the below code
DoCmd.TransferSpreadsheet acExport, , "qryDelRepCAN", "J:\data\Manager\Test.xlsx
Canada is the named range
ASKER
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
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
I guess you have another question on this subject.
brb
brb
ASKER
yes i originally thought it was a seperate issue but i think they are linked
- Will be the code runing to transfer data from a remote database or from the local database
Mike