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!