saving excel workbook

[stranger20]

hi
i would like to save
an excel workbook into a *.dbf
but i don't know the function
to use
before i wanna open like a sort of dialog to open
a file
then after
opening a dialog to save this file
thanks
you
i would really appreciate

[TheOnly]

Hi stranger20 !!!

in Excel:

Thisworkbook.saveas Filename:="myworkbook.xls", _
fileformat:=(see below)

Fileformat can be xlDBF2 or xlDBF3 or xlDBF4 debend on what you need.

If you want to use this in VB then make sure you have set a reference to EXCEL.

Note: if you want no warnings to overwrite an existing file
then set application.displayalerts to false before

-cu TheOnly