Without knowing where:
• your script is kept (eg a text file or a worksheet); or
• the values you want replaced can be found on the other sheet,
responding to your request requires some guesswork.

The attached Excel workbook assumes your script is kept on Sheet1 and the values are kept on Sheet2. Once you've input the data on Sheet 2, simply enter the number of a required script in cell A1 of Sheet1 and the script below will be updated. You can then copy/paste or export the script to wherever else you require it.

PS: When posting code, please use the code tags. They're on the 'Go Advanced' tab.

Attached Files

Script Generator.xls (60.0 KB, 9 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]