Prompt user to enter cell value to save file name (with cell value)

Hi,
I'm new to VBA and couldn't find the exact answer to my problem in the postings. I spent 2 hours looking and trying different code examples. Can you please help?

Upon opening file "test," prompt user to "Enter cell value in A1" (e.g. name=Joe) to save file name as "test Joe.xls"

Thanks!

Hi stama100, I made a simple script for you to refine, that might do the trick.

Please Login or Register  to view this content.

Sorry that didn't work. When I compiled, I got nothing.

As you want the procedure to be executed when the workbook is opened, you need to store the routine in the "ThisWorkbook" module.

The code I wrote was untested, please change the following (as well as the Sheet name you want to store the name in, e.g. Sheet1)

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Hopefully it should be working!