SaveAs

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

In ActiveWorkbook.SaveAs() method what are the additional parameters need to
be set for
supporting different font styles.

My coding is oExcel.ActiveWorkbook.SaveAs(<ExcelDataTableName>, 11)

The problem is I have values in Excel worksheet with Vietnam font. But after
saving as DBF
it doesn't save actual ASCII values in to the table.

Pls smone help..
 
Do a search in VBA help for

FileFormat Property

You will see a link on this page for xlformat. There is a list of all the
formats.
 
Do a search in VBA help for

FileFormat Property

You will see a link on this page for xlformat. There is a list of all the
formats.
 
Do a search in VBA help for

FileFormat Property

You will see a link on this page for xlformat. There is a list of all the
formats.
 
In ActiveWorkbook.SaveAs() method what are the additional parameters needto
be set for
supporting different font styles.

My coding is     oExcel.ActiveWorkbook.SaveAs(<ExcelDataTableName>, 11)

The problem is I have values in Excel worksheet with Vietnam font. But after
saving as DBF
it doesn't save actual ASCII values in to the table.

Pls smone help..
Click to expand...

Marc,

I have never had to encounter anything like this before, but the help
file on SaveAs indicates two parameters that may be useful to you -
TextCodePage and Local. Unfortunately, TextCodePage has very poor
documentation, but Local may fit what you are looking for.

Best,

Matt Herbert
 
Back
Top