I currently have a macro in a spreadsheet that copies and pastes one worksheet into a new workbook on its own and the saves this as a macro enabled document (large version attached - I have deleted all contents). This is usually around 390kb in size. Please note: I do need it to be xlsm.
Today the macro was tested out on another machine and the small version (attached) was produced instead. All the data pulled through correctly and this would certainly be sufficient for what is required .... this version was on around 30kb!!
I'm trying to find out what is different between the two spreadsheets, but at the moment I can't find out what is. When I do find out, I would love to add into the original macro the info that is needed to save the file as the smaller version, rather than the larger version. At the moment the part of the macro i have that saves this is:
Application.CutCopyMode = False
strFileName = .Sheets(1).Range("FO9").Value
.SaveAs wbA.Path & Application.PathSeparator & strFileName & ".xlsm", xlOpenXMLWorkbookMacroEnabled
wbA.Sheets("NCS - Copy Values Skip Blanks").Visible = False
Any help to figure out why one filesize is so different would be really appreciated!