Macro - Save file in Desktop
Activeworkbook.saveAs Filename:=
CreateObject("WScript.Shell").SpecialFolders("Desk top") & "\" & "myFile.xls"
--
HTH
Bob
(change the xxxx to gmail if mailing direct)
"Dileep Chandran" wrote in message
ups.com...
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
|