Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Run Macro In All Open Workbooks

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 396
Default Run Macro In All Open Workbooks

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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro To consolidate All Open Workbooks Into One Workbook carl Excel Worksheet Functions 3 March 31st 07 04:22 AM
Can a Macro open workbooks on a SharePoint Site? Randy Excel Discussion (Misc queries) 0 August 29th 06 07:21 PM
Macro to merge open workbooks Barry McConnell Excel Discussion (Misc queries) 1 August 23rd 06 05:09 PM
macro or code to open multiple workbooks Duane Reynolds Excel Discussion (Misc queries) 1 March 14th 06 08:18 AM
Macro that will add data from multiple workbooks to the 1st open r jbsand1001 Excel Discussion (Misc queries) 0 April 23rd 05 07:52 PM


All times are GMT +1. The time now is 10:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"