How to add 2 features to a file transfer macro.

[forkenbrock]

I have the following Macro below and I wonder if anyone can help me modify it to do the following two things:

• Move to the next line when there's and error. Sometimes when a file is being copied to a folder, someone else has a file with the same name open.
  
• Create a new tab with a list of the lines that didn't run due to errors.

Thank you

Please Login or Register  to view this content.

[jindon]

1)
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

2) Untested.

Please Login or Register  to view this content.

[forkenbrock]

Thank you jindon, this is awesome. I've been testing on my C: drive. The report transfers the files, but gives an error when a copy of the file being saved is already open. It says "Run-time Error '70': Permission denied". In debug it stops at "FileCopy e(0), e(1)".

Please Login or Register  to view this content.

[jindon]

Not sure why, but see what happens.

Please Login or Register  to view this content.

[forkenbrock]

Hello jindon. It seems to give the same error and stop at about the same place.

fso.CopyFile e(0), e(1), True

[jindon]

What are the both value for e(0) and e(1) when you get into a debug mode?

You can see when you hover over the cursor (not click) the variable.

[forkenbrock]

This is what it says:

e(0) = "C:\Test_C\US WEST REGIONCOMP.xls"
e(1) = "C:\Test_D\US WEST REGIONCOMP - 2018-12-31.xls"

In this case the destination file in folder D was the one that was open. If I open the file in destination folder B, then e(0) refers to folder A and e(1) refers to folder B.