I have the following do cmd code that will export my query to an excel file. I am trying to edit the format of the file within the code itself. How would I be able to do that?Thanks
DoCmd.OutputTo acQuery, "Investor_Request_Query", "MicrosoftExcel 97-10(*.xls)", "C:\Investor Request Report.xls", True, ""
Bookmarks