Macro - Save file in Desktop

D

Dileep Chandran

Hi everyone,

I was juz trying to write a macro. I am almost done. But the macro
which save the excel file in Desktop shows the file save location as
"C:\Documents and Settings\myname\Desktop".

The problem is, when someone else is running the macro the file wont
get saved in their desktop.

Can anyone help me?

-Dileep
 
B

Bob Phillips

Activeworkbook.saveAs Filename:=
CreateObject("WScript.Shell").SpecialFolders("Desktop") & "\" & "myFile.xls"

--
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
Top