Excel 2010 Not Recognizing Some FileFormat Values

CGM3 · #1 03-22-2013, 01:01 PM

I'm upgrading/converting old spreadsheets (mostly Excel 2000, but with some Quattro Pro) to Excel 2010, and in one of them I encounter Error 1004 (Method 'SaveAs' of object '_Workbook' failed) with these commands:

Code:

ActiveWorkbook.SaveAs FileName:=mname, FileFormat:=xlExcel9795, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False

Code:

ActiveWorkbook.SaveAs FileName:=sname, FileFormat:=xlDBF3, CreateBackup:=False

In both instances, I've traced the problem to the FileFormat specification (which, if eliminated, allows the method to work, albeit saving in the default file format). I was able to get the first line to work by replacing xlExcel9795 with xlExcel8 to save the workbook in Excel 97-2003 format, but I haven't been able to find a replacement/alternate for xlDBF3 (which I believe is dBase III).

Any suggestions as to why the FileFormat values (which are given in the online Excel Developer Help) don't work, or something I can use to save as a DBF3 file?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mailing: Reading values from Excel to Word	Jamal NUMAN	Excel	9	09-02-2011 02:08 AM
[How To] Generate Alpha Numeric Values in Excel 2010	stnicholas81	Excel	1	07-25-2011 01:31 AM
How Do I Put Text Values Into A CSV That Excel Will Leave Along?	eBob.com	Excel	2	05-04-2011 07:01 AM
Word - Calculate and paste values from Excel sheet	Augf87	Word	1	07-06-2009 10:26 AM
Not Recognizing Contacts	cehdcs	Outlook	0	02-06-2006 02:22 PM