I need to save an excel spreadsheet to a semicolon delimited text file. Is there a way to do this? In the save as options I have noticed you can save tab delimited and comma delimited, but no semicolon.
Do you know enough about VBA to be able to adapt Oorang's code on this thread? If you edit the third arg in the REPLACE() function to be a semicolon instead of Chr(44) that should give you a workable solution.