need to amend code to export to csv file

[BillDoor]

Hi
I need to amend the following code to export to an actual .csv file.

Apparently it's only doing a excel file with a csv extention. It needs to be an actual csv file for other purposes. Can you please help?

thanks

Please Login or Register  to view this content.

[Leith Ross]

Hello BillDoor,

There are other ways to create a CSV file. It is important to know how certain data is to be represented like dates. Does the text need to be enclosed in double quotes?

If you can post an actual sample CSV file that would help a lot.

[BillDoor]

Hi

I don't have an example at the moment, basically I'm doing something for a friend, but I'm on Windows and he's on Mac, he needs the CSV file to have Unix line endings??? as it's being imported into a website by someone else.

All that's in the file are numbers and text, no real formatting required

Thanks

[Leith Ross]

Hello Bill,

Add a new VBA Module to your workbook and paste this macro into it. This will read a Windows file and convert it into UNIX format.

NOTE: This macro will only run under Windows. The Mac does not support all of the VBA features used in Windows.

Macor to Cteate a UNIX CSV File

Please Login or Register  to view this content.

Example of Using the Macro

Please Login or Register  to view this content.

[BillDoor]

thanks for that, sorry for delay in closing thread