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.
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.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
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
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
Example of Using the MacroPlease Login or Register to view this content.
Please Login or Register to view this content.
thanks for that, sorry for delay in closing thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks