Access export to EXCEL - Color Filled exported content

[Pumpk1n]

I don't have any formatting in the template file. Access exports the data to a new tab called "Deferred". With the export, all the content has a yellow fill. 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?


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 Excel forum: https://www.mrexcel.com/forum/excel...port-formats-all-content-yellow-fill-why.html

 

[xenou]

I would have to assume it is formatting in the Excel template. Possibly Conditional Formatting which is why you might not see it if you just open the template as is.

 

[Pumpk1n]

Re: VBA Export formats all content as yellow fill - Why?

Thanks -- I had tested the conditional formatting and there was nothing in the workbook to set the conditional formatting.

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

 

[xenou]

Re: VBA Export formats all content as yellow fill - Why?

I really can't think why Access would cause this in any way. It is remotely possible for excel to have something strange in it. I would recreate the template workbook to (probably) fix this.

 

[Pumpk1n]

Re: VBA Export formats all content as yellow fill - Why?

I really can't think why Access would cause this in any way. It is remotely possible for excel to have something strange in it. I would recreate the template workbook to (probably) fix this.

Thanks. I did create a new blank template and the data does not appear highlighted. Not sure what was driving that in the prior template.