Activate Workbook

  • Thread starter Thread starter Molly Johnson
  • Start date Start date
M

Molly Johnson

Hi

I have a workbook path = FileName and a workbook name = Wb

How do I activate this workbook?

Very easy i know.... lol:)
 
Hi
Workbooks.Open filename:=path & filename
Workbooks(wbk_name).Activate

Frank
 
You must log in or register to reply here.

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

closing another file by code causes failure to run workbook activate event 2
All Workbook Saved except This Workbook 3
Activate a Workbook 4
Getting the name & path of a hidden WB 2
Error message 1004 2
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
COM addin won't connect when workbook opened via another workbookfrom another instance 3
Activate workbook using partial name 5

Back
Top