Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to save to My Documents folder on different PCs
How do I setup a macro that will save to the "My Documents" folder even
though the path is different on different PC's. Since Win-XP moved the "My Docs" folder to a differnet place for each user. -- Respectfully Matthew Russell |
#2
|
|||
|
|||
One way:
Option Explicit Sub testme() Dim myDocumentsPath As String Dim wsh As Object Set wsh = CreateObject("WScript.Shell") myDocumentsPath = wsh.SpecialFolders.Item("mydocuments") MsgBox myDocumentsPath End Sub Matthew wrote: How do I setup a macro that will save to the "My Documents" folder even though the path is different on different PC's. Since Win-XP moved the "My Docs" folder to a differnet place for each user. -- Respectfully Matthew Russell -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
save as html | Excel Discussion (Misc queries) | |||
How do i save backup copy in a different folder | Excel Discussion (Misc queries) | |||
Save as Default folder | Excel Discussion (Misc queries) | |||
cannot save file - folder is read only | Excel Discussion (Misc queries) | |||
Add favorites to "Save" window | Setting up and Configuration of Excel |