I want to use the filecopy statement to copy a list of files to another
folder. This list will be stored in a column on a spreadsheet and will
always be different. As such, if the filecopy function encounters an error
(like the file doesn't exist), I don't want it to stop the code, but rather
identify that cell on the spreadsheet and then move on to the next cell.

Does anyone know how to do this?

Show us the code you have got so far!

Regards,
Per

"rjvega" skrev i meddelelsen
...
I want to use the filecopy statement to copy a list of files to another
folder. This list will be stored in a column on a spreadsheet and will
always be different. As such, if the filecopy function encounters an
error
(like the file doesn't exist), I don't want it to stop the code, but
rather
identify that cell on the spreadsheet and then move on to the next cell.

Does anyone know how to do this?

Hi rjvega

You can test with Dir if a file exist before you try to copy

If Dir(FileCell.Value) < "" Then
' do the copy
else
'do nothing
end if

See this page for more info
http://www.rondebruin.nl/exist.htm


Maybe this page is useful also if you want to copy files or folders
http://www.rondebruin.nl/folder.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"rjvega" wrote in message ...
I want to use the filecopy statement to copy a list of files to another
folder. This list will be stored in a column on a spreadsheet and will
always be different. As such, if the filecopy function encounters an error
(like the file doesn't exist), I don't want it to stop the code, but rather
identify that cell on the spreadsheet and then move on to the next cell.

Does anyone know how to do this?