Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Dave,
Earlier this week, you responded to a question I had and Im wondering if you can help me once again. Since I havent picked up on this project again until now, I didnt realize I made a mistake and the solution you provided me with didnt quite work like I thought. I had requested a way to automatically save a copy of the current users workbook page to the desktop without the code being specific (this will be accessed by multiple users). When I replace SpecialFolders (10) with SpecialFolders (Desktop), the file still saves in the same place C:\Documents and Settings\Jenny and its title is now Desktop and the range value (not quite correct). I know Im just missing just one step to have it placed directly in the Desktop Folder (so it will appear on my desktop), but Im not sure how to accomplish it. Thank you for your thoughts in advance Jenny B. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dave Peterson - last question | Excel Discussion (Misc queries) | |||
Follow-up Question for Dave Peterson | Excel Discussion (Misc queries) | |||
Macro Question for Dave Peterson | Excel Discussion (Misc queries) | |||
Print question - Calling Dave Peterson! | Excel Discussion (Misc queries) | |||
Print question - Calling Dave Peterson! | Excel Discussion (Misc queries) |