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
Printable View
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
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