Save As csv file between Excel versions
 

On my development machine VB6 application creates Excel 2003 worksheet and
saves the following fine:
xlSheet.SaveAs FileName:="C:\Auction\NandB.csv",
FileFormat:=Excel.XlFileFormat.xlCSV, CreateBackup:=False

On Users machine my application gpfs but creates Excel 2000 worksheet.
Grateful for any pointers

Save As csv file between Excel versions
 

I wonder if replacing the "Excel.XlFileFormat.xlCSV" with the constant 6
helps.

--
Jim
"EdwardH" wrote in message
...
| On my development machine VB6 application creates Excel 2003 worksheet and
| saves the following fine:
| xlSheet.SaveAs FileName:="C:\Auction\NandB.csv",
| FileFormat:=Excel.XlFileFormat.xlCSV, CreateBackup:=False
|
| On Users machine my application gpfs but creates Excel 2000 worksheet.
| Grateful for any pointers
|

Save As csv file between Excel versions
 

Jim,
Thank you for your suggestion - I fear it made no difference.
EdwardH

"Jim Rech" wrote:

I wonder if replacing the "Excel.XlFileFormat.xlCSV" with the constant 6
helps.

--
Jim
"EdwardH" wrote in message
...
| On my development machine VB6 application creates Excel 2003 worksheet and
| saves the following fine:
| xlSheet.SaveAs FileName:="C:\Auction\NandB.csv",
| FileFormat:=Excel.XlFileFormat.xlCSV, CreateBackup:=False
|
| On Users machine my application gpfs but creates Excel 2000 worksheet.
| Grateful for any pointers
|