.
Trying to create a VBScript using Environ. All the examples I can locate online are not helpful (actually there are very few examples).

Here is the script currently used, that includes the USERNAME. I want to use ENVIRON in place of the USERNAME.

Thanks for any assistance.

Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = false
Set objWorkbook = objExcel.Workbooks.Open("C:\Users\USERNAME HERE\Desktop\WORKBOOK NAME.xlsm")
objExcel.Visible = true