vba to determine user and computer name, then add to existing formula

[andymalan]

Hi most learned people.
I have a formula in a worksheet that references the user and the computer name (in bold below)

='C:\Users\andym\Documents\ExcaliburDataConfig\ConfigPLANITData\[DrawingData.xlsx]Page 1'!B1

This formula needs to run on a variety of computers, whose user name and computer name is unknown to me.
is there some method to
A) determine user and computer name
B) replace the existing formula with the new references.

I could really use some help on this, pretty please?

 

[Fluff]

Maybe something like

Sub chk()
Range("A1") = Environ("userprofile")
End Sub

You can then concatenate that with the rest of the file path/name

 

[andymalan]

Thank you very much, will try this and let you know if it was successful.☺