Opening, Temporarily Naming and Switching Between Workbooks With Varying Names

  • Hi there. I'm trying to write a series of macros that refer to the macro document itself (Order Macro.xlsb) and then two other workbooks. These two other workbooks are browsed for and opened by the end user (paths and names will vary). The question is, how do I switch between these three workbooks when I only know the name of one? I've looked around and found what I think is a partial answer but I can't seem to switch between the workbooks. See attached.

    ANY information would be helpful. I'm stumped as to what I'm missing. I'm sure it's something basic and stupid but I'm learning VBA as I go so it's......challenging.

    Thank you!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!