View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chacky Chacky is offline
external usenet poster
 
Posts: 8
Default Run Macro In All Open Workbooks

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

"Wigi" wrote:

Do you have 1 instance of Excel (the program itself), or multiple Excel
programs?


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Chacky" wrote:

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.