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?
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?