Excel 2011 MacIntosh questions

[ezflyer]

I am trying to create a macro that will save a worksheet as a .csv. I based the macro on a suggestion from the thread 320531 and it works for Windows. However, when I try it with Excel 2011 for Mac I get a 1004 error for the GetSaveAsFilename method. The problem appears to be the FileFilter option for file types. The FileFilter for .csv for Windows is "CSV File (*.csv), *.csv" but apparently not for Mac. I have searched for the corresponding Mac information and but I havne't been able to find it.

Can anyone give me the FileFilter or direct me to somewhere I can find it?

Thanks

Bill

 

[Andrew Poulsom]

Welcome to MrExcel.

I thing it should be FileFilter:="TEXT", but I've read that the file filter doesn't work on the Mac (at least in Excel 2004).

http://us.generation-nt.com/answer/getsaveasfilename-help-wanted-help-63293042.html

 

[ezflyer]

Hi Andrew:

Thanks for the reply. You're right, TEXT doesn't work on Macs but your link got me thinking and I came up with a slightly ugly, but effective solution.

I used a GetSaveAsFilename with no FileFilter, then stripped the suffix from the file name, and added my own csv suffix. This is working in both Windows Mac.

I'll save elegant for version 2.

Bill