Hello,

In VB.net I am creating a CSV File.

With Excel
..SheetsInNewWorkbook = 1
..Workbooks.Add(1)
..Worksheets().Select()

(Create Columns and Rows)

When I save the file.

..Application.DisplayAlerts = False
..ActiveWorkbook().SaveAs("C:\MyCSV.csv",
..ActiveWorkbook.FileFormat.xlCSVWindows)
..ActiveWorkbook.Close()

The worksheet is named MyCSV, I want the worksheet to have a different name
than the saved file.

Any assistance will be greatly appreciated.

Thanks,

Chuck