save as .xls from a cell value and in a specific location on Mac

[Marzia]

Solved!!!! just to help any mac user bumping in here...it's was just a sintax path problem

Please Login or Register  to view this content.

Hello everyone,
I'm very new to this forum (first time in a forum in general) and I am hoping someone can help me.
I'm not a programmer, I'm a graphic designer therefore, it's even more difficult. I 'm trying to work out a vba code. My need is saving a xls file with a name from a cell and in a specific location on my computer. I'm using Mac and Excel 2004.
The following code picks correctly the values from the range of cells but the entire path come out within the file name and the file is saved randomly in the first window open on my desktop. That means it ignores the path. Since I found many examples of this code and all them similar I assume may be a Mac problem, and I don't who to ask to. Otherwise, is anyone familiar with Apple Script? I have also excel 2008 for Mac.
Thank you, any help would be greatly appreciated. Marzia

Please Login or Register  to view this content.

[Marzia]

Bump no response

[royUK]

Not many Mac users here I'm afraid