All open workbooks

  • Thread starter Thread starter strataguru
  • Start date Start date
S

strataguru

How do I determine all the currently open workbooks?

I will be writing a macro that will copy certain information from on
workbook and paste it into the other workbook.

The user will determine - based on open workbooks - which workbook t
copy from - and which workbook to copy into.

Thanks for any assistance
 
Dim wbk as WorkBook

For each wbk In WorksBooks
MsgBox wbk.Name
Next wbk
 
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

Excel Protection 2
COM addin won't connect when workbook opened via another workbookfrom another instance 3
Unwanted workbooks on startup 2
How to append data from different sheet and different workbook? 2
Open and close workbooks 1
Save As and new workbook new name used in existing code 8
copy and paste from workbook to workbook 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Back
Top