Open from Desktop - second book

[jomili]

I have the following routine I use to open a workbook from my user's desktops. I didn't come up with it on my own, so I'm not sure how to modify it.

Please Login or Register  to view this content.

I want to open not only the "BR1011..." workbook, but also the "PivotsforAnalysis.xls" workbook. How do I modify the code to do that? Any help is greatly appreciated.

Thanks,
John

[Leith Ross]

Hello John,

Perhaps this less cryptic macro code will suffice.

Please Login or Register  to view this content.

[jomili]

Leath,

I tried your code as shown below. No workbooks opened other than the source workbook. Do I have something configured incorrectly?

Please Login or Register  to view this content.

[romperstomper]

Small correction to the loop:

Please Login or Register  to view this content.

[Leith Ross]

Hello Romper,

Thanks for catching and correcting my omission.

[jomili]

Thanks Leath AND Romper,

You guys are a big help. I made the correction and it's running beautifully now. But one related question; the two workbooks I'm opening ask if I want to update them; can I defeat that prompt?

[Leith Ross]

Hello jomili,

Try this. This should update the workbooks without prompting you.

Please Login or Register  to view this content.

[jomili]

Arrrgghhh! Fix one thing, break another...

Leath,
Your change got past the first obstacle. Now I'm presented with a message saying:

Please Login or Register  to view this content.

Manually, I'd want to just click the "Continue" button, so I can use the file. The workbooks I'm opening don't belong to me, so I have no choice but to push past. So, how do I sail past this one, too?

[jomili]

Okay, I found one way: I changed the

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Is there a more correct way?

[Leith Ross]

Hello jomili,

VBA interprets a zero for a Boolean type varable as FALSE.

[jomili]

So changing it to 0 means DON'T update the values, correct? I think that's probably what I want to do, so no flags come up at all.

Thanks,
John

[Leith Ross]

Hello John,

Yes, a zero or FALSE would mean do not update links to other workbooks.

[jomili]

Thanks Leath, and thanks also to Romper; you guys are always a great help to me, and I thank God every day that there're such good, helpful people in the world. You're awesome, and I really appreciate you!

Thanks,
John

[romperstomper]

Glad to help, and thank you for the kind words.