Changing cell value in multiple workbooks

Blazey21

New Member
Joined
Jul 18, 2003
Messages
4
Hi there,

I am trying to change a single cell (B10) in over 200 individual workbooks with different names. These workbooks are split over approximately 10 directories. Some of the workbooks are quite large (10Mb).

The cell is in a worksheet named 'Summary' in each of the workbooks.

The change is a simple numerical value swap.

Each workbook asks whether to Update Links on opening. I do not want to update links.

So, if anyone can tell me how to write a macro that opens, alters, saves and closes multiple workbooks I would be extremely grateful. I am of course happy to run a macro for each of my directories.

I am kinda new to macros so be gentle!

Many thanks,
Neil



(Using Excel 2002, Windows XP)
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Watch MrExcel Video

Forum statistics

Threads
1,118,035
Messages
5,569,782
Members
412,292
Latest member
The Bear named Joe
Top