Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro that converts xls to csv
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error when running cut & paste macro | Excel Worksheet Functions | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Highlight Range - wrong macro, please edit. | Excel Worksheet Functions |