Save Workbook with name generated from excel data

[andymalan]

Hello brainiacks, (said with utmost respect). Please help with my problem:

I have some code in a workbook named configureData.xlsm that creates a filename in Q2 .
I want to open a new workbook.xlsx and save it with the fileName created.

The path would always be the same:

UsersName = Environ("USERNAME")
strFileName = "C:\Users" & UsersName & _
"\Desktop\Excalibur Winner\configureData.xlsm\NewFileName.xlsx"

but the NewFileName will change depending on the data used by the code when creating the filename and storing it in Q2.
Your help will be appreciated hugely.

kind regards
Andy

 

[andymalan]

Dear Logit
thank you ever so much.

much appreciation
Andy

 

[Logit]

You are welcome.
Merry Christmas and Happy New Year.

 

[andymalan]

Can you please post the rest of your code, as there is nothing in what you have posted that saves the file.

Hi Fluff
thank you for your interest, but my question has been resolved.
mauch appreciation,
andy

 

[Logit]

.
andymalan

You are to be commended for responding to Fluff even though you received an acceptable answer.

Too many times assistance is requested from the volunteers on this and other Forums and the OP never responds with anything ... even when they receive a solution.
As a volunteer ... when this type of non-response is experienced numerous times ... it causes one to question whether continuing to volunteer is worth it.

So ... from someone who has experienced the good and bad from individuals requesting assistance ... THANK YOU for taking the time to "speak" to everyone
involved in your request.

Happy New Year !