I'm sure he meant to tell you to use the refence as

Activeworkbook.Name
as a varialbe rather than
Workbooks("MyWorkbook.xls")
reference
also you could refer to the workbook as

ThisWorkbook.Worksheets(1).Range("A1")
or
ActiveWorkbook.Worksheets(1).Range("A1")



--
When you lose your mind, you free your life.


"David" wrote:

Make the active.name a variable and use that in your code.
--
David


"Jim Berglund" wrote:

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