Saveas xls file vba on Mac OS X

[LaurenVavraDarien]

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.

 

[Jim Gordon]

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