Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 71
Default 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".
  #2   Report Post  
Posted to microsoft.public.excel.programming
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".

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro programming in Excel CarlosD_LongIsland Excel Programming 7 June 24th 08 04:05 PM
Excel VBA/Macro programming for beginners sdebu_2000 New Users to Excel 9 September 6th 06 06:29 AM
Macro Programming in Excel 2003 mick the quick Excel Programming 2 May 6th 05 06:01 PM
Excel Macro programming Kass[_2_] Excel Programming 2 January 28th 04 03:04 AM
Website about excel macro programming Joao Saraiva Excel Programming 1 January 2nd 04 02:58 AM


All times are GMT +1. The time now is 05:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"