Forum Discussion
ActiveWorkbook.save changes content of file
I made a script to change the content of all files in a directory. This script worked fine and changed the content that I had selected. These files are .tpr and are used in a another program as set...
I have done some further testing.
Obviously it is the Cells that contain a "," that gets the "...." when using ActiveWorkbook.Save
Really strange that just opening and saving the file manually won't do this. Instead the "" is not shown upon opening and thus not saved into the file.
So obviously the manual save function and the ActiveWorkbook.Save don't work in the same way even though ActiveWorkbook.Save is what you get when recording the manual save function.