5 copy pasting

R

rivers

How do i copy and paste a file from a file name specified in a ttext field to
a location saved in a variable

thanks
 
D

Daniel

Well first you'll need to read the textfile and extract what you need from
it. To learn more about this look at:

http://www.applecore99.com/gen/gen029.asp

Using this technique you'll be able to store the filename as a variable and
use it, in conjunction with your location variable, with the FileCopy
Statement. The basic synthax is as follows.

FileCopy source, destination
 
J

John Nurick

Hi Rivers,

Provided the 'location stored in a variable' is a folder or filespec,
you can use the VBA FileCopy statement.
 
Top