Save worksheet as .dbf

[rangerstud620]

I'm creating an Excel macro that edits the current worksheet and then saves it as a DBF. I can't figure out how to save it as a .dbf though. I'm guessing I need to use ActiveSheet.SaveAs, but I'm not sure what exactly to put in for file format. Does anyone have any ideas? Thanks

 

[SkipVought]

Hi,

Did you try macro recording the SaveAs process?

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[rangerstud620]

Yes I did recording the save process but it did not work. I'm not sure if I did something wrong so it didn't work. Any ideas?

 

[rangerstud620]

Yes I did recording the save process but it did not work. I'm not sure if I did something wrong so it didn't work, or what happened. Any ideas?

 

[SkipVought]

hey STUD!

Better brush up on yer macro recording skills! Excel 101!

    ActiveWorkbook.SaveAs _
        Filename:="C:\SapWorkDir\Pac3OrderReservations.dbf", _
        FileFormat:=xlDBF4, _
        CreateBackup:=False

;-)



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[rangerstud620]

Thanks Skip...I wasn't sure how to reference the DBF4 file format type.

 

[SkipVought]

Is it not in the list of SAVEAS file extensions?

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[rangerstud620]

It is listed in the save as dialog box. I tried referencing the file format as *.dbf, dbf4, and dbfIV. Obviously none of those worked. I did find a list of all the xlFileFormat constants now, so I shouldn't have a problem with that anymore

 

[SkipVought]

When you said, "...none of them worked", what do you mean?

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[rangerstud620]

When I used *.dbf, dbf4, and dbfIV as the file format, I kept getting an error (can't remember what exactly the error was though).

 

[SkipVought]

So you recorded the SaveAs and then "played" it back and it errored?

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[rangerstud620]

Actually, I tried recording the macro and it did not record correctly...it would not change the file format. So I had to manually edit the macro code to do the Save As process. That's when I kept getting the file format error.

 

[SkipVought]

Why did it NOT change the file format?

Did you answer ALL the questions OK and YES?

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[rangerstud620]

Yeah I went through it twice. I couldn't get it to work properly so I modified the code a bit and it works ok now.