View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gareth[_6_] Gareth[_6_] is offline
external usenet poster
 
Posts: 158
Default 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".