Macro that converts xls to csv

C

carl

I am using this code:

If IsArray(FName) Then

Application.ScreenUpdating = False

For N = LBound(FName) To UBound(FName)

Set Awb = Workbooks.Open(FName(N))

Awb.SaveAs Filename:=Left(Awb.Name, Len(Awb.Name) - 4),
FileFormat:=xlCSV

Awb.Close savechanges:=False

Next

Application.ScreenUpdating = True

End If



Application.ScreenUpdating = True

ActiveWorkbook.Close savechanges:=False

End Sub

My Regional Setting for delimiter is Semi-Colon.

Recently my company has switch us from Office/Excel 2000 to XP/Excel 2003.

Now when I run this code, the file created is comma delimited. I need the
file to be Semi-Colon delimited.

Is there a way to fix this ?

Thank you in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top