How to save excel to maintain column width formatting

[pslady05]

I am trying to save an excel spreadsheet that I have set the column width - when I re-open it, the column width has gone back to the default.
Is there a way that I can get the file to maintain the specific column widths. I need to provide the results to other persons and they use it to upload to a third party vendor. The vendor is looking for the output in the specific formatting.

Thanks!

 

[dave3009]

Hi pslady05

Are there any Open and Close macro's that act directly on that column or the one surrounding it. Excel wouldn't necessarily resize a column without being told to.

Dave