Solved: Save as a Plain Text file on a Mac
Hello!
I'm trying to bring a macro from the PC to the Mac. For some reason it works fine in excel 2010 on the PC, but comes up as an error in excel 2011 on the Mac.
The offending code:
[VBA] output_filename = Application.GetSaveAsFilename( _
FileFilter:="Plain Text, *.txt", _
Title:="Save As File Name")[/VBA]
Thanks!
P.S. If you need more information about the rest of the macro or what I'm actually trying to do, let me know. It's kind of a long story and I didn't want to over-complicate anything. Cheers!
' Save the file with the new name.
give this a shot, replacing below with what you have there now for selecting the file
[vba]
' Get the file name.
On Error Resume Next
output_filename = MacScript("choose file of type {""txt""} with prompt ""Browse to select a text file"" ")
On Error GoTo 0
' Save the file with the new name.
[/vba]