vents = False
> and alerts:
> Application.DisplayAlerts = False
>
> I have replaced macro modules in several hundred files in an average of 3
> seconds each!
>
> I'd be glad to look at a sample and recommend a solution..
>
> Paul
>
> _
and recommend a solution..
Paul
From: DeanL
To: MS EXCEL AND VBA MACROS
Sent: Mon, April 12, 2010 11:37:54 AM
Subject: $$Excel-Macros$$ Changing multiple spreadsheets
Hi everyone,
I have a user who has several thousand spreadsheets in a single
directory a
Hi everyone,
I have a user who has several thousand spreadsheets in a single
directory and she needs to alter each one's code. Does anyone know a
way to iterate through every spreadsheet in the directory and change a
piece of code in the back of each spreadsheet without having to do
each one manu
