run macro after name change

[sick stigma]

In the attached workbook "Quote Sheets" I recorded a macro to copy information to workbook "Quote review". Only after finishing did it dawn on me that the 1st thing users will do is save "Quote sheets" to a new workbook name. Is there a way to have the macro reflect the new workbook name or is there a command like "previous workbook.
Thank you,
Sick
Here's the code:

Please Login or Register  to view this content.

[JBeaucaire]

The trick is to refer to worksheets and workbooks by variable names that you set at the start of the macro. That way you don't need to know names of things.

Also, selecting and activating are unnecessary once you have variable names to address commands to directly:

Please Login or Register  to view this content.

[sick stigma]

Jerry,
Thanks for the improved macro. The new workbook names are random (by customer name). The new workbook name will be cell "C7". Any suggestion?

[JBeaucaire]

For what? If you're asking something specific try again. I'm not getting it.

[JBeaucaire]

I see C7 is a cell you copied into the wbReview you opened. Are you wanting to save the wbReview with that name instead of saving it back to its original name?

[sick stigma]

wbQuotes will be saved as C7 before this macro runs. wbQuotes is opened. C6:C10 are changed. wbQuotes is then saved as a new wb (C7.xlsw). Then macro "savetoquotereview" is run. Does that make sense?

[JBeaucaire]

Where does this macro reside? My macro above presumed it was in the workbook with the data to be copied from, which is why I named the variable wsData. Look at the code.

I don't know what you mean by .xlsw.

[sick stigma]

JB,
I finally worked through it. Thank you so much for your help!
"thisworkbook.activesheet" solved all my problems. Now it's ready to roll out.
One last question: In the code listed below, "J" represents my name on my computer. Is there something that could replace my name to allow the project to run on anyones computer? i.e. C:\Users\'Allusers" or "Anyuser" or something?

Please Login or Register  to view this content.

Thanks again for the great advice!

[JBeaucaire]

This snippet will return the current logged in username:

Please Login or Register  to view this content.

Once you've got the username in a string, slip it into your text string where needed using standard syntax.

[sick stigma]

Beautiful! Thanks again!