Excel auto export .dbf file through VBA

Drivium · July 25th, 2013, 10:57 AM

Trying to solve a problem. My company is upgrading to Office 2013 and as I understand it, dbf output from access macros has been removed. I read that I can do it in Excel, but haven't found any info on automating. I downloaded and installed the add-in for excel: SaveDBFIV.xlam

I've got this script:

Code:

Sub SaveInFormat()
Application.DisplayAlerts = False
Workbooks.Application.ActiveWorkbook.SaveAs Filename:="\\apps07\5885\My Documents\" & "ArcMAPXY" & ".dbf", FileFormat:=??
Application.DisplayAlerts = True
End Sub

I just don't know what the FileFormat:= should be. Any ideas? Thanks...

Example of various file types:

Code:

FileExtStr = ".xls": FileFormatNum = -4143
FileExtStr = ".xlsx": FileFormatNum = 51
FileExtStr = ".xlsm": FileFormatNum = 52
FileExtStr = ".xlsx": FileFormatNum = 51
FileExtStr = ".xls": FileFormatNum = 56
FileExtStr = ".xlsb": FileFormatNum = 50