While debugging some generated spreadsheets that are picked up by a third
party system, we found that the actual byte code of xls workbooks generated
in vba in Excel differ depending on wether or not the VBE window is open or
closed.

Has anyone run across this? The files generated when the VBE window is open
are always about 8k larger than when the VBE window is closed. Looking at
the files with a hex editor, the files are completely different.

The problem is that for some reason the 3rd party system will not handle the
file correctly unless it gets the format that is generated when the VBE
window is open. This causes us to open the VBE window programatically before
saving the file in code.

When opening both files separately in Excel all modules, properties etc are
identical.

File is being saved with

Application.VBE.MainWindow.Visible = True ( or False)

xlNewBook.SaveAs FileName:=strOutputPath & "_" & strWorkBookName, _
FileFormat:=-4143, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False, TextCodePage:=1100

Thanks in advance,
Mark