Need a macro that opens another workbook but stays in current workbook

Hi!

I'm new to macros and VBA, so I apologize for missing the obvious. The first workbook, containing the macro, is the sales template. It draws customer data from a table in another workbook. I want the user to be able to click a button from the first workbook that runs a macro that will open the customer workbook and continue to save the template (first workbook) as a file with the current date. I can do these separately, but not together. Once the customer file opens, Excel doesn't return to the macro. I don't know how to fix this. Any help is greatly appreciated.

P.S. Here is the code, and I hope I've tagged it properly.

Sue

Please Login or Register  to view this content.

Go back with:

Please Login or Register  to view this content.

Thank you so much for the speedy reply. I added the suggested line just after the 'Workbooks.Open' but I still get runtime error 9, subscript out of range. Any ideas?

Thank you for the suggestion. I tried shg's code but this still returns the subscript out of range error. I tried recording a macro that would toggle back to the original workbook, right after opening the customer file:

Please Login or Register  to view this content.

I no longer get the error but it doesn't actually put the first workbook on the screen. It does continue to perform the rest of the macro. My workaround is to tell the user to minimize the customer file. Oh well.

Thank you both for responding so quickly. I very much appreciate it!

Thanks, shg, for hanging in there with me. It's working now. I'm sure I'll be back posting new threads as I continue on this learning journey!

Thank you very much. (I don't know what to do to mark this solved, though.)