Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Copy
look in help for copyfile.
If is part of the filesystemobject in the scripting runtime. If the files are closed, you can use the built in VBA command filecopy. from help Copies a file. Syntax FileCopy source, destination The FileCopy statement syntax has these named arguments: Part Description source Required. String expression that specifies the name of the file to be copied. The source may include directory or folder, and drive. destination Required. String expression that specifies the target file name. The destination may include directory or folder, and drive. Remarks If you try to use the FileCopy statement on a currently open file, an error occurs. ------------- The example: This example uses the FileCopy statement to copy one file to another. For purposes of this example, assume that SRCFILE is a file containing some data. Dim SourceFile, DestinationFile SourceFile = "SRCFILE" ' Define source file name. DestinationFile = "DESTFILE" ' Define target file name. FileCopy SourceFile, DestinationFile ' Copy source to target. -- Regards, Tom Ogilvy Neil wrote in message ... My last post for today, thank you to everyone that has replied to the few questions I have posted... I am using the MSOfilepicker object to put up a box from which the user can select some files, I then have an item call vrtselecteditems, at least i thinks thats what it was called, I would like to copy all the sleected files from vrtselected items to a target dir called foldername, I have looked in the help, but I cant seem to pin it down, are there different dgrees of help files ? The help I have installed seems pretty limited, either that or im using it incorrectly :( |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy data for match word from one file to another file | Excel Worksheet Functions | |||
How do I copy a excel file into a InDesign file correctly? | Excel Discussion (Misc queries) | |||
copy the same raws of all sheets from about a 100 file to a new sheet of a book and save the file | Setting up and Configuration of Excel | |||
How do I copy a file and attach a date to the name of the file | Excel Discussion (Misc queries) | |||
EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel |