Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Copy file

Status
Not open for further replies.

4321z

Programmer
Oct 21, 2003
45
GB
Hi,

i'm using the following code to retieve a file name

Set exApp = CreateObject("Excel.Application")
strFileToOpen = exApp.GetOpenFilename("Picture Files (*.jpg), *.jpg")

but i also want to copy the file to a new location i've tried to use the copyfile method but i'm not exactly sure how to use it properly can anyone help?
 
You can use FileCopy to copy the file.

Example:
FileCopy strFileToOpen, "C:\New Folder\Folder
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top