Reply to thread

Message: [QUOTE="Paul Berkowitz, post: 6795608"] You shouldn't try to save a workbook as CSV. (When I try, it won't even open in TextEdit, only in Excel.) Since the most you can ever save as CSV is only one worksheet at a time, use 'save as' command rather than 'save workbook as'. I tried it with the same sheet and it works perfectly. It opens in TextEdit looking exactly the same as doing it in the UI. Also, by 'filename' it actually means the full colon-delimited file path, although it will save it to the folder where you last saved a document if you use just the actual name as you did. Try save as active sheet filename "finish.csv" file format CSV file format I agree that it's a bug to allow the CSV file format (and probably several other file formats such as the text formats) to operate with 'save workbook as' and then have it not save properly. I'll file that as a bug. -- Paul Berkowitz MVP MacOffice Entourage FAQ Page: <[URL]http://www.entourage.mvps.org/faq/index.html[/URL]> AppleScripts for Entourage: <[URL]http://macscripter.net/scriptbuilders/[/URL]> Please "Reply To Newsgroup" to reply to this message. Emails will be ignored. PLEASE always state which version of Microsoft Office you are using - **2004**, X or 2001. It's often impossible to answer your questions otherwise. [/QUOTE]