I have VBA code which exports data to an EXCEL file. I don't have any formatting in the template file. With the export, all the content has a yellow fill and I don't understand why/where it is setting those properties. Is it in the VBA code or how do I find where this is being controlled?
the VBA code seems very generic and simple. -- Here's the VBA Code:
Dim str_office_loc As String, oldPath As String, newPath As String, fs As Object
Dim MyXL As Object
Set MyXL = CreateObject("Excel.Application")
Template = ".....Award File Template.xlsx"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Qry_CopyDeferred_Award_Data", Data, True, "Deferred"
Edit:
Also posted in Access forum: https://www.mrexcel.com/forum/micro...port-excel-color-filled-exported-content.html
the VBA code seems very generic and simple. -- Here's the VBA Code:
Dim str_office_loc As String, oldPath As String, newPath As String, fs As Object
Dim MyXL As Object
Set MyXL = CreateObject("Excel.Application")
Template = ".....Award File Template.xlsx"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Qry_CopyDeferred_Award_Data", Data, True, "Deferred"
Edit:
Also posted in Access forum: https://www.mrexcel.com/forum/micro...port-excel-color-filled-exported-content.html
Last edited by a moderator: