See also this page for more info
http://www.rondebruin.nl/saveas.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"xp" wrote in message ...
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!


"Dave Peterson" wrote:

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!

xp wrote:

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.

--

Dave Peterson