VBA export to excel from Access

N

N

Hi

I am using the following command to export the results of
a query to an excel file:
DoCmd.OutputTo acOutputQuery, "AL_Rand_Amount",
acFormatXLS, "c:\temp\export.xls", True

Is there anyway i can force this command to use a certain
template? The excel opens with the default page setup:
portrait mode with a certain setup for its margins. I want
to open with a page setup of landscape and a different
margin setting as well as font setting.
Can i do this?

Thanks
 
J

Jim/Chris

Have you tried exporting to a second hidden sheet in an
existing workbook and use sheet 1 that links to that
second sheet with all your formatting.

Jim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Export to PDF 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Export to Excel with Parameter in Filename 1
Using OUTPUT TO in VBA, then how to modify the XLS from Access? 2
Exporting multiple queries to multiple sheets within one excel fil 2
Rename Sheet1 on Excel Export 4
Export to Excel 1
VBA - (re-) Set a Table Style 2

Top