A
Annette
I am using Office 2007 Prof. I am having to do a repetative action with many
steps to 83 workbooks - (replacing months in a linking formula, ie Aug to
Sept) There are 83 workbooks - 5 sheets per book - 21 replacements per
sheet. Example of a link on a sheet:
='C:\Users\Annette\Desktop\Annette Daily Weekly\Daily\August\[1Charge
Sheet.xlsx]Mon'!$C$12
This is 9,775 replacements - I have been doing it per page with find and
replace but that is 415 separate actions.
Is it possible to write a macro that would replace the month in an entire
workbook ?? If you would like more information - look at "Replace Links" in
the discussion listing below (I tried to get info on a better way to use the
find and replace) Thanks to anyone who can help me - and - OH, by the way, I
have never written a macro - HELP
steps to 83 workbooks - (replacing months in a linking formula, ie Aug to
Sept) There are 83 workbooks - 5 sheets per book - 21 replacements per
sheet. Example of a link on a sheet:
='C:\Users\Annette\Desktop\Annette Daily Weekly\Daily\August\[1Charge
Sheet.xlsx]Mon'!$C$12
This is 9,775 replacements - I have been doing it per page with find and
replace but that is 415 separate actions.
Is it possible to write a macro that would replace the month in an entire
workbook ?? If you would like more information - look at "Replace Links" in
the discussion listing below (I tried to get info on a better way to use the
find and replace) Thanks to anyone who can help me - and - OH, by the way, I
have never written a macro - HELP