Excel Error Handling Query

[JasonEnsor]

Hi Guys,

A lot of my projects pass data between workbooks, however the project I am working on at the moment is possibly the worst for it. How can I ensure that if an error occurs the external workbook closes and my current workbook activates on the desired sheet? The issue is sometimes an error occurs in workbook x and then my application tries to access a range in workbook x as it is active but it should be looking for a range in workbook y which is where the macro is actually running. Error handling in VBA is quite new to me and so far I have gotten away without using it, but as my skills improve my projects are getting more complex and so I think it's time I start using error handling.

Any tips would be appreciated on how to tackle this one

Regards

Jason

 

[SkipVought]

Hi,

So you're not referring to a query that you are executing but it refers to a question?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[JasonEnsor]

Sorry Skip, I worded that wrong. It's been a long day here. It is a question and not a data query that I am referring too.

Regards

Jason

 

[PHV]

it should be looking for a range in workbook y which is where the macro is actually running
Use ThisWorkbook instead of ActiveWorkbook

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886