changing system language via VBA

[focosi]

Hi,
I have Yes/No fields in my Access database. I'm trying to export to Excel for a US customer. Since my system language is Italian, Excel outpouts VERO/FALSO values on Yes/No fields, while I would like it to output TRUE/FALSE values. Any way to change system language via VBA ?
Tsanks

[orange]

Have you considered a lookup table with 0 False -1 True?

[focosi]

No, I'm currently accomplishing the export via an OnClick event using the following code :

Dim strQryName As String, strXLFile As String, strName As String
strQryName = "Pittsburgh"
strName = Environ("USERNAME")
strXLFile = "C:\Documents and Settings\" & strName & "\Desktop\Robotic Whipple Database - Ultimate Version - Pisa.xls"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, strQryName, strXLFile
Call ModifyExportedExcelFileFormats(strXLFile)

....where ...
Public Sub ModifyExportedExcelFileFormats(sFile As String)

Dim xlApp As Object
Dim xlSheet As Object

Set xlApp = CreateObject("Excel.Application")
Set xlSheet = xlApp.Workbooks.Open(sFile).Sheets(1)

With xlApp
.Application.Sheets("Pittsburgh").Select
.Application.Cells.Select
.Application.Selection.ClearFormats
.Application.Rows("1:1").Select
.Application.Selection.Font.Bold = True
.Application.Cells.Select
.Application.Selection.RowHeight = 12.75
.Application.Selection.Columns.AutoFit
.Application.Range("A2").Select
.Application.ActiveWindow.FreezePanes = True
.Application.Range("A1").Select
.Application.Selection.AutoFilter

.Application.Activeworkbook.Save
.Application.Activeworkbook.Close
.Quit
End With

Set xlApp = Nothing
Set xlSheet = Nothing

vStatusBar = SysCmd(acSysCmdClearStatus)

Exit_ModifyExportedExcelFileFormats:
Exit Sub
End Sub


Any hint ?

[ajetrumpet]

I doubt there's a script out there to do this. google this though:

"xp change language settings vba".

try that first, if you haven't. obviously you can switch languages through the CP, so most likely there is a way to do it through vb. However, I wouldn't be surprised if, after a change was made through the coding, another reboot of somekind would be required.

maybe not, but changing the system language and then subsequently opening excel and throwing data into it seems to be a little fast to reflect the language change.

as always though, I could be wrong.