| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro - Save file in Desktop
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macro - Save file in Desktop
It works fine Bob. Thanks a lot for the timely help.
-Dileep |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I email amacro? | Excel Worksheet Functions | |||
| default save as file type does not work | Excel Discussion (Misc queries) | |||
| Macro Save File (Unique file name) | Excel Worksheet Functions | |||
| macro assignments on toolbar go to 'save as' file | Excel Discussion (Misc queries) | |||
| This one is tricky....Macro to save file as cell value x in di | Excel Discussion (Misc queries) | |||
Linear Mode
