Search results

I tried the Docmd.Transferspreadsheet command and it removes all the formatting from the spreadsheet. So, the field names are not gray or bold and all the percents are decimals with no percent sign. If I could use this method and keep the formatting then I would try this. I will try the create...

Hi, I have a question about exporting an Access query to Excel using VBA. When I run the code, the Excel workbook that is created defaults to the name of the query. I use naming conventions for my queries so the tab of the Excel spreadsheet is named "qryProviderAuditExport". I would like to...