Thanks for your advice.

I just entered Workbook()1.Activate and it seemed to work!

Jim

"Jim Berglund" wrote in message
news:3ZtGf.466350$2k.393433@pd7tw1no...
I have a pricing spreadsheet which I typically modify and save for each
prospect under the account name. As such, I have t go into the code and
replace all the current filename references.

There must be a better way to do this...

Any ideas, please?

Thanks much,
Jim Berglund