Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 55
Default Copying files

Greetings !

I have the name and directory of a source file, and the
name of the target directory.

I was going to use

Shell "Copy " & Source & " " & Target

what VBA code could I use instead?


RClay AT haswell DOT com
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Copying files

Hi Robin

Look at the FileCopy command in the VBA help

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Robin Clay" wrote in message ...
Greetings !

I have the name and directory of a source file, and the
name of the target directory.

I was going to use

Shell "Copy " & Source & " " & Target

what VBA code could I use instead?


RClay AT haswell DOT com



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 55
Default Copying files


Again, SO simple - WHEN you know how ! Thanks once more.

-----Original Message-----
Hi Robin

Look at the FileCopy command in the VBA help

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Robin Clay" wrote

in message ...
Greetings !

I have the name and directory of a source file, and the
name of the target directory.

I was going to use

Shell "Copy " & Source & " " & Target

what VBA code could I use instead?


RClay AT haswell DOT com



.

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
Copying from different files into 1 LiAD Excel Discussion (Misc queries) 1 November 4th 09 01:57 PM
Need Help Copying Excel Files to a CD jm47 Excel Discussion (Misc queries) 6 November 26th 08 05:44 AM
Copying Files RH206 Excel Discussion (Misc queries) 2 April 1st 08 08:21 PM
Copying files fds Excel Worksheet Functions 1 July 27th 05 12:55 AM
Copying data from many files David Excel Programming 1 June 30th 04 06:32 PM


All times are GMT +1. The time now is 05:25 PM.

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"