Hello,
I found the following macro to copy a selection of a worksheet and save as a .csv file using name in a cell reference as the file name. The problem is it work work on a mac, and from what I can find it has to do with the file filter.
I have traced my issue to:
FileFilter:="Comma Seperated Values (*.csv), *.csv)", _
When I run the macro as written below I get =
Run-time error '1004'
Method 'GetSaveAsFilename' of object '_Application' failed
Any insight is greatly appreciated!
Thanks!
Here is the code:
Please Login or Register to view this content.
Bookmarks