On Error Resume Next not working when changing location of files

[chrisellis250]

Hi all,

I have a master spreadsheet, which is a number of tabs each with different tables on.

On each tab there is a "button" assigned to a macro, to import data from Excel files saved in a location.

This is an example of one of my codes:

Please Login or Register  to view this content.

The "button" has the following macro assigned to it:

Please Login or Register  to view this content.

There is the potential of 10 files called CPA1 to 10 in the relevant folder. However, there is often only 2 or 3 of them, hence the use of On Error Resume Next.

This works perfectly fine, but I am moving this file and any corresponding files to a different location so that others users can use it. When I change the location of the files I get an error message when it cant find CPA3, 4 and so on - despite having the On Error Resume Next part of the code. Eventually after pressing ok several times I get the desired output, but this doesn't happen when the file is in its original location.

Any idea why this is now happening?

Many thanks,

Chris

[Fluff13]

Using On error like that is a bad idea as it will tend to mask all problems, try changing your procedures to

Please Login or Register  to view this content.

and remove all the On Errors from sub CopyAll

[chrisellis250]

Hi Fluff13,

I have tried your code and I get the same errors, it imports the data for CPA1 and CPA2 (as those spreadsheets exist) but then I get an error message for each of the other CPA files.

[rorya]

If you're getting an error message in spite of On Error Resume Next, I suggest you check your error settings in the VB Editor. Tools - Options - General tab, make sure it is not set to 'Break on all errors'