Activate workbook from input box

If they open it, then it would be the activeworkbook.

Try using FileDialog and let them click and pick. Your macro can then open it and do its thing.

Thanks for the reply, Kenneth. Not sure what FileDialog does, or how to apply it. The idea is that this macro will be used by novice users, and I have no idea how many different instances of Excel they will have open when they run the macro. I realize the report is active when they open it, but then when they go back to the workbook containing the macro, ThisWorkbook becomes the active workbook.

Ideally, to keep it simple for novice users, I just wanted them to have to click a button and enter a number to identify and activate the report. Then I would set it as wbTemp, and could switch back and forth in the macro to perform all my actions from there.

I think the parentheses in the filename are causing the syntax error. Can you think of any way around this, keeping it simple for novice users, (and someone with only a basic understanding of VBA).

Thanks again for any help offered!

Hutch

Good morning again, Gurus.

The fact that none of the mods have responded to this thread leads me to believe either it's not possible, or I'm going about it the wrong way.

If a user has several workbooks open, what's the best method to assign a variable to another workbook, (with a varying name), so that the code can swap between the new workbook and ThisWorkbook? I plan to attach the code to a button click.

Any suggestions appreciated.

Have a good one!

Hutch

Here is how to get the name of a file using FileDialog.

Please Login or Register  to view this content.

****** ******

I'm an idiot. Thanks, that fixed me right up.

****** ******

Morning, Kenneth. Your message came through while I was responding to VBA Noob. It works fine by just adding the "&" that was missing, but I'm going to check yours out, too, to see which one is easier for the user. I appreciate your help.