OutputTo Excel Doesn't use Book.xlt like normal

[Dirtbike]

When I:

DoCmd.OutputTo acQuery, "Loc003WOcouldbuild", "MicrosoftExcelBiff8(*.xls)", "", True, "D:\Program Files\Microsoft Office\OFFICE11\XLSTART\Book.xlt", 0

it doesn't follow the rules I set up in Book.xlt like custom headers, repeat rows. etc. Even when I explicitly call out the location of templates in TOOLS -> OPTIONS -> GENERAL. What gives? How can I apply settings to the sheet after it is spawned from Access? Please don't say to load up personal.xls with macros.....unless of course that is the only solution...

Scott

 

[VBslammer]

Output the query to the template, the user will have to do "SaveA As" to save it, leaving the template intact.

DoCmd.OutputTo acQuery, "Loc003WOcouldbuild", "Microsoft Excel(*.xls)", "D:\Program Files\Microsoft Office\OFFICE11\XLSTART\Book.xlt", True

VBSlammer

"You just have to know which screws to turn." - Professor Bob