multiple workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
You don't. While it is possible to group multiple sheets within a workbook to
perform actions on, it is not possible to group multiple workbooks for the
same purpose (To the best of my knowledge)...
 
can I open the multiple workbooks and perform a function on all of them
 
Jim Thomlinson said:
Nope... You can only deal with 1 workbook at a time.
Click to expand...
....

But you could apply the same operations to each file in sequence.

For Each wb In Workbooks
'do whatever with wb
Next s
 
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 shortcut options 0
Windows key and keycode 4
Repeat the titles across multiple sheets of a workbook. 6
How do you chart data from multiple sheets within a workbook? 3
Open workbook(s) using VBA 2
Open multiple workbook then combine into single workbook butdifferent sheets 10
Who is linking to my file? And what files am I linking to? 1
one workbook, multiple users.... 2

Back
Top