Excel Macro Programming
 

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".

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".