Run Macro In All Open Workbooks

  • Thread starter Thread starter Chacky
  • Start date Start date
C

Chacky

In Excel 2007
I would like to run a macro that inserts text in the same cell of the same
sheet in all open workbooks.
 
Do you have 1 instance of Excel (the program itself), or multiple Excel
programs?
 
I am only running 1 programme of Excel 2007

I want to select a number of workbooks from a folder (Not all the workbooks
in that folder) and run a macro that will insert text into the same cell in
each workbook. There could be 10 workbooks or 50 workbooks so i don't want to
have to do it to each workbook one at a time
 
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

Merge Multiple workbook sheets into one workbook 0
Excel Macro-enabled Workbook 2
Multiple Workbooks using same macro 4
Macro available in all workbooks 8
Sharing workbooks limitations - Merged Cells 12
Disable Macro Alert 2
Macro to push data to another workbook 0
Macro to open seperate workbook 3

Back
Top