environ username

  1. M

    How to change old Environ file path to work with one drive

    I had a number of workbooks that other co-workers use. I have have vba code: Workbooks.Open filename:=(Environ(“userprofile”) & how do I convert that to work with One drive? Unfortunately my dept. received no warning on this update from our higher ups so it’s reeking havoc with running van...
  2. C

    Place Name in selected Cell from UserName lookup result

    Hello all. I am struggling with this one. What im trying to do is if a cell is selected in the range of C3:J30 it looks up the = Environ("username") in Settings!A1:B35 (A-usernames, B-Actual Name) and places the Actual Name in the selected cell. Then if the cell is selected again when it...
  3. D

    Evaluating current user name in ambitious formula string via VBA

    Hi all, Perhaps this is a little too ambitious for a formula string, but it seems like it should be made able to work. Set up: I'm trying to place numerous items into the single cell "A1" of worksheet "Sheet1" via a formula produced by a VBA macro. Here's a visual sample of the output of the...
  4. R

    Environ(UserName) on Remote Machine

    I've been working on a project for buyers to get data using a userform. If the data they want isn't there they can send a request to me via email to get the data entered. In the sendmail sub I used sUserName = Environ("UserName") & "@company.com" and it worked while I was testing it...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top