Save the current worrkbook, save the sheet as .csv and close the workbook

Hi All,

This is my first post and I really appreciate any help I can get!

I'm trying to save the current sheet into a .csv file before saving & closing the current workbook.

The code I have at the moment is:

Const xlCSV = 6

Set objExcel = CreateObject("Excel.Application")
objExcel.DisplayAlerts = FALSE
objExcel.Visible = TRUE

Set objWorksheet = ActiveSheet
objWorksheet.SaveAs "c:\Users\Public\test.csv", xlCSV

ActiveWorkbook.Close TRUE



This doesn't seem to work at all! Please can you help?

Tim

Firstly, I don't see why you need to define xlCSV. It should already be pre-defined so.. scratch that line.

Secondly, I don't see why you need to create an instance of Excel. You can just use Application.DisplayAlerts / Visible (although I am not sure why you need to change the Visible property)

I think your code could be as simple as:

Please Login or Register  to view this content.

Hi Tim, and welcome to the forum.

This line looks wrong! objWorksheet.SaveAs "c:\Users\Public\test.csv", xlCSV

I would be inclined to try objWorksheet.SaveAs Filename:= "c:\Users\Public\test.csv", FileFormat:-xlCSV

Unfortunately, without the whole macro or the workbook, it's difficult to test.

I hope this helps, please let me know!

Regards,

David

Please remember, your request is clearer if you attach a sample workbook.
- Click on Go Advanced and click on the Paper Clip.

If this has been of assistance, please advise.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

If several people have responded, when you reply please make it clear WHO you are responding
to by mentioning their name.

Thank you all. I have realised that I am a little more ignorant than I thought I was!
I am using VBScript in a 3rd party application to control EXCEL. I think that the help you guys have given me is VBA for EXCEL.
Is this then the wrong forum? If so sorry, if not, further guidance much appreciated!