Activate an active workbook with name x

G

Gmick

First I do a save as.. for a workbook and get the name via a input box
(lets say the name gets queried by 'fname'.
How do I later move back to that specific workbook?
Something I needed would look like:

ActiveWorkbook -with the name of 'fname'.Activate

tx
 
E

Earl Kiosterud

Gmick,

I think fname is a variable in your program. If so,
Workbooks(fname).Activate
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel activate in excel vba 0
Combine worksheets in multiple workbook in one workbook with a macro 2
Saving and Sharing with VBA 1
Can I Use VBA to Create New Workbook Without Links? 3
activate workbook w/unknown name 2
save file using information from a cell 1
Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
VBA Copy values only onto new workbook 1

Top