File save as produces corrupt file

  • Thread starter Thread starter xp
  • Start date Start date
X

xp

Using XL2007.

In code I open a text file (csv) and format it as I want it, then the
program saves the file using: ActiveWorkbook.SaveAs MyFullFileName

All runs fine. But, when I try to open the file, I get an error that says
the file is corrupt or has an unrecognizable file extension...what the?

This is using code I've used for years in 2003 without problem.

Any help would be appreciated.
 
Specify the extension in that filename and make sure you include the
fileformat:= parm in the .saveas line.

And they have to be consistent, too!
 
I do specify a file format so that is not the issue; however, "fileformat" is
a new spec to me, I will check that out and see if it does the trick...

Thanks Dave.
 
Dave,

FYI, you were right, the "FileFormat" spec is required now in order for this
command to work correctly (at least in my case); thanks!
 
Back
Top