Excel Macro Programming
Do you mean you want the copying to work for all users on the local
machine - assuming they have the same pictures in their My Pictures folder?
Like, say,
FileCopy "c:\documents and settings\" _
& Environ("username") _
& "\My documents\My Pictures\pic1.jpg", _
"c:\temp\pic1.jpg"
Marvin wrote:
I want to creat a generic filecopy command so I do not need to hard code the
owner name into the path. I am trying to copy a file that is in my pictures
and the path is below the owner folder or in my case the name "Marvin".
|