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

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

--
Jim
"EdwardH" <[email protected]> wrote in message
news:[email protected]...
| 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
|

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" <[email protected]> wrote in message
> news:[email protected]...
> | 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
> |
>
>
>