G Guest Jun 8, 2007 #1 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
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
G Guest Jun 8, 2007 #2 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
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 Jun 9, 2007 #3 Hi Rivers, Provided the 'location stored in a variable' is a folder or filespec, you can use the VBA FileCopy statement.
Hi Rivers, Provided the 'location stored in a variable' is a folder or filespec, you can use the VBA FileCopy statement.
