Saveas xls file vba on Mac OS X
I am running Excel 2011 on Mac OS X. I am trying to save a file (.xls) to a server (Autumn). I have tried several configurations to try to get the file saved properly. File name is "Testfile.xls"
1. folderpath = "Autumn:Tim:TestFolder:" & filename --Activeworkbook.Saveas filename:=folderpath
2. folderpath = "Tim:TestFolder:" & filename Activeworkbook.Saveas filename:=folderpath
3 Activeworkbook.Saveas folderpath
When I try this, I get an Error 1004 indicating that it cannot find the file. Do I need to eliminate the .xls and then specify that when I do the saveas?
Thanks in advance for the help.
Re: Saveas xls file vba on Mac OS X
Excel MVP Ron DeBruin has examples of correct synatax for working with files in Mac OS X. Here's a link to his web site: Excel 2011 for the Mac Tips