Differences between Excel files when using VBA to automatically save workbook

[Chiznuggets]

Hello,

I have written/recorded a long VBA code to reformat data. I have two versions of this code. One version automatically saves the file to a specific folder and reformats the data while the other just reformats the data.

Here's the code I used to save the workbook:

ActiveWorkbook.SaveAs ("C:\Users\Work\Desktop\June Monthly Reports\" & varEventName & " " & varDate & " " & varReportType & ".xlsx")

The files that I use the "save as" code on end up about 10,000 bytes smaller than the files I use the other code on. When I open the excel file that I use the "save as" code on in google sheets none of the formatting carries over. (All borders, column and row resizing, bolding not present.) While the "non-save as" code carries the formatting over to google sheets. Could this be due to the smaller file size?

Just to be clear I'm using the two VBA codes on identical data sets and saving them in identical file locations. In addition, the formatting for the "save as" code does show up properly in the excel file itself.

Any ideas would be greatly appreciated!

 

[Chiznuggets]

Solved

The problem was that the ActiveWorkbook.SaveAs code changed the file extension but didn't change the file format. Don't ask me what the difference between the two is but the mismatched caused problems. The file was still in it's original .csv format while the extension had been changed to .xlsx. Adding the code

 ActiveWorkbook.SaveAs FileFormat:=51

solved the problem.