VBA to ignore a specific workbook

**Pierce Quality** · 01-10-2014, 12:24 PM

Hi All,

Im having a bit of trouble with capturing data from multiple workbook sources. In the code below, I'm pulling data from Sheet2 in workbooks located in a different directory than the workbook that the macro is stored in. This works fine, however there are some workbooks in that directory that will have the same sheet name that I want to ignore when the macro runs. Is there a way to ignore specific workbooks?

When I add

Please Login or Register  to view this content.

to the

Please Login or Register  to view this content.

line I get an error.

Any help would be greatly appreciated, thanks!

Please Login or Register  to view this content.

**alansidman** · 01-10-2014, 12:30 PM

I would change the line

Please Login or Register  to view this content.

to an if statement

Please Login or Register  to view this content.

and insert below the DoWhile Statement.

Then at the end of the instructions before the Loop command add an End if

Alan

**Pierce Quality** · 01-10-2014, 12:35 PM

Originally Posted by alansidman

I would change the line

Please Login or Register  to view this content.

to an if statement

Please Login or Register  to view this content.

and insert below the DoWhile Statement.

Then at the end of the instructions before the Loop command add an End if

Alan

Hello Allen, thanks for the reply!

When I do that I get a Run Time Error '91', Object variable or With block variable not set.
Not sure why though, what do you think?

Thanks

**alansidman** · 01-10-2014, 01:16 PM

Post your new code. Sounds like you may be missing the End if statement.

What line in the code is highlighted when you select Debug?

**Pierce Quality** · 01-10-2014, 01:26 PM

Alan,
Here is the code:

Please Login or Register  to view this content.

This is the highlighted line:

Please Login or Register  to view this content.

Thanks!

**jaslake** · 01-10-2014, 02:12 PM

Hi Pierce

Try this

Please Login or Register  to view this content.

I believe your End If needs to be moved

Please Login or Register  to view this content.

**Pierce Quality** · 01-10-2014, 02:29 PM

Originally Posted by jaslake

Hi Pierce

Try this

Please Login or Register  to view this content.

I believe your End If needs to be moved

Please Login or Register  to view this content.

Hello John, thanks for the reply!

When I use that instead, it freezes excel once the merge reaches that workbook. Why do you think this is?

Thanks!

**jaslake** · 01-10-2014, 02:44 PM

This Code performs as expected in my test environment...

Please Login or Register  to view this content.

**Pierce Quality** · 01-10-2014, 02:57 PM

Originally Posted by jaslake

This Code performs as expected in my test environment...

Please Login or Register  to view this content.

Thanks John, this does work, I must have not moved the 'End If" when I ran it previously.

Marking this as solved, thanks again!

**jaslake** · 01-10-2014, 03:02 PM

You're welcome...glad I could help. Thanks for the Rep.

In the future, please don't quote entire Posts...quote only relevant parts.

**Pierce Quality** · 01-10-2014, 03:03 PM

Originally Posted by jaslake

You're welcome...glad I could help. Thanks for the Rep.

In the future, please don't quote entire Posts...quote only relevant parts.

Thanks John, will do!

**xladept** · 01-10-2014, 03:53 PM

Will somebody fix the spelling? Ingore s/b Ignore

**jaslake** · 01-10-2014, 03:58 PM

It's pronounced "In Gorr eee"

**xladept** · 01-10-2014, 04:39 PM

My Gorry - I didn't know that!

**jaslake** · 01-10-2014, 04:44 PM

Ah well...just learned it myself today...when I tested got a "Subscript Out Of Range" when I spelled it incorrectly (Ignore)...worked when I spelled it correctly (Ingore)...learn something new every day...it's a wonderful life.

**xladept** · 01-10-2014, 04:53 PM

it's a wonderful life.

That it is - if you don't weaken

**jaslake** · 01-10-2014, 05:02 PM

At my age the mantra is

'ya gotta keep movin'

We'll probably both get hammered for this "Off Topic" conversation...

**alansidman** · 01-10-2014, 05:34 PM

At my age the mantra is
'ya gotta keep movin'
We'll probably both get hammered for this "Off Topic" conversation...

At my age, I need to learn how to spell

**jaslake** · 01-10-2014, 06:01 PM

Yeah, well, me too. That's why God made Spell Checkers such as ISpell...though, it's not "Fool Proof"...it's tripped up this Fool more than once.

**xladept** · 01-10-2014, 07:05 PM

I've always been gud at speling

VBA to ignore a specific workbook

LinkBack

Thread Tools

Rate This Thread

Display

VBA to ignore a specific workbook

Re: VBA to ignore a specific workbook

Re: VBA to ignore a specific workbook

Re: VBA to ignore a specific workbook

Re: VBA to ignore a specific workbook

Re: VBA to ignore a specific workbook

Re: VBA to ignore a specific workbook

Re: VBA to ignore a specific workbook

Re: VBA to ignore a specific workbook

Re: VBA to ignore a specific workbook

Re: VBA to ignore a specific workbook

Re: VBA to ignore a specific workbook

Re: VBA to ignore a specific workbook

Re: VBA to ignore a specific workbook

Re: VBA to ignore a specific workbook

Re: VBA to ignore a specific workbook

Re: VBA to ignore a specific workbook

Re: VBA to ignore a specific workbook

Re: VBA to ignore a specific workbook

Re: VBA to ignore a specific workbook

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Ignore MsgBox in a referenced Workbook

Macro script to ignore open workbook

VB code help, ignore blanks/specific

ignore cells containing specific words

How can I ignore value from a workbook that are not in my collection?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions