determine username computer name and save worksheet to filename in a cell

[andymalan]

Hello brainiacks, (said with utmost respect). here is my problem:

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

The path would always be the same:

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

the NewFileName (inQ2) will change depending on the customers name and quote number that is used by the code when creating the filename and storing it in Q2.

in the workbook configureData.xlsm, the existing macro uses the current customers name and quote number and concatenates these into Q1. then the macro copies Q1 and pastes to Q2 using save special values.

Your help will be appreciated hugely.

 

[Peter_SSs]

Duplicate to https://www.mrexcel.com/forum/excel-questions/1113820-save-workbook-name-generated-excel-data.html

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.