At the beginning of a macro I'm writing, I'm trying to test to make sure
that the activeworkbook is not the one the macro is in. I put this line in:

If ActiveWorkbook = ThisWorkbook Then

followed by a message box to the user. But I'm getting an "Object doesn't
support this property or method" error on this line. How do I text this
correctly?
Thanks again!

On 16 Jul., 00:08, salgud <spamboy6...@comcast.net> wrote:
> At the beginning of a macro I'm writing, I'm trying to test to make sure
> that the activeworkbook is not the one the macro is in. I put this line in:
>
> If ActiveWorkbook = ThisWorkbook Then
>
> followed by a message box to the user. But I'm getting an "Object doesn't
> support this property or method" error on this line. How do I text this
> correctly?
> Thanks again!

Hi

Try this:

If ThisWorkbook.Name = ActiveWorkbook.Name Then

Regards,
Per

On Tue, 15 Jul 2008 16:08:33 -0600, salgud <(E-Mail Removed)>
wrote:

>At the beginning of a macro I'm writing, I'm trying to test to make sure
>that the activeworkbook is not the one the macro is in. I put this line in:
>
>If ActiveWorkbook = ThisWorkbook Then
>
>followed by a message box to the user. But I'm getting an "Object doesn't
>support this property or method" error on this line. How do I text this
>correctly?
>Thanks again!


Try this:

If ActiveWorkbook.Name = ThisWorkbook.Name Then

Hope this helps / Lars-Åke

On Tue, 15 Jul 2008 15:16:04 -0700 (PDT), Per Jessen wrote:

> If ThisWorkbook.Name = ActiveWorkbook.Name Then

Got it. Thanks!