username

Hello and thanks for reading! I have a spreadsheet that is saved on multiple users desktop. The issue is i don't (and won't) know who the users are. On the sheet there is a command button that will save it to a folder also on their desktop. This folder ("Finished Work") will have the same...

Hi The code below is meant to retrieve the username in a cell with the formula =fOSUserName() The code works flawlessly on my private desktop with Excel 2019 64 bit. However, the code does not seem to work on my company's desktop with Excel 2016 32 bit, even though the code works on this 32...

Hi everyone How am I able to insert the username in the column "Closed by" and the actual date in column "Date for closing Claim Internal"? I tried with this VBA code, but it only take line 31. Private Sub Closed_by() If Range("AJ31") = "Closed" Then Range("AK31").Value =...

Hi Team, Please note I am trying to put in place a welcome message in userform (label) but the application username needs to be restricted to only show the Name of the user ( That it is after the coma) The code is working correct but unfortunately I need to extract only the value after the ","...

Hi! I have a table that I put into a subform so users can fill out portions of the data. The user will review the work and write in who is responsible, the credit category, cause, and notes. I want to hide the TINITIALS (username) and STAMP (time stamp). I want to use an Event, but I can't...

Hello I have been trying to find a macro that autamatically fills 3 different cells with date, updated date and name of user, when someone fills certain cells in a worksheet. i have 2 macros that work independently. but i cant make them work together: (Optimally i would like to have the macro...

Hello specialists, I have a sheet called "Data", and there from row 4 and along, I have several collunms with data, like "Main Responsible" in AO, "Country" in AK and "SBU" in AL; I am also have another sheet called "AuthUsers", where I've created the below matriz; soo, I am looking for a VBA...

Hi, I’m looking for help logging in Excel, using VBA to log in ahidden sheet the username, date and time logged in and logged out of reports inshared locations. I know a solution exists because I’ve used one before, but Ican’t for the life of me remember how I did it… Does anybody have...

Hi, I wonder if someone can help me with this problem with amacro. I have a table of data that appears below(input data) whichhas usernames down a few rows and one or more accounts across 70 columns. On a regular basis, I would need to able to copy all theaccount numbers that are present...

Hi guys, I hope everything is going well with you. Look, I need your help please. I need to create Save event. So, once the active sheet is saved, the code acts as follows: Type the date and time (NOW function, I believe) in the active row, second cell (Column B). Type the username (Environ...

Hi, I a pretty new to VBA and would like some support. What I looking for is a piece of VBA code that will date stamp Column O Username Stamp Column P, based on the status in column K being changed to either - Resolved & Ignore/Resolved. Ideally id like the O & P cells to be locked down an...

I have an excel sheet that tracks documents that have been reviewed by project managers. When a PM reviews a document they select "Yes" from a drop down (only way i could figure out to limit data entry). What I am looking to do now is two seperate actions. 1. If "Yes" is in Cell D23 (the whole...

Hello, I would like to paste 3 values in 3 columns A, B, and C in the last available row. Filename = Dir(Path & "*.xls*") DateTimeStamp = DateTime.Now UserName = (Environ$("Username")) 'get last AVAILABLE cell to paste into Set iLastCellS2 = s2.Cells(s2.Rows.Count, "A").End(xlUp).Offset(1, 0)...

I don't know why I keep getting this error. I've tried BeforeUpate,AfterUpdate, enter,exit....none of them work. HELP, please Private Sub TextBox2_Exit(ByVal Cancel As MSForms.ReturnBoolean) Dim Username As String Username = TextBox2.Value MsgBox "Hello, " + Username + "...

Hi, I am looking for below. I want to extract reports from web which is having to username and password. How I can start with? Let me know. Nee

Hi, I am trying to look up two data sources and would really appreciate any help please: Call Data <tbody> Username Start End Call Id name1 01/04/19 08:01:07 01/04/19 08:13:19 100001 name2 01/04/19 08:01:45 01/04/19 08:07:12 100002 </tbody> against Interaction Data <tbody> Username...

Hello friends, hope all is well! Can you please help me with the code below: I want the code to close the workbook if: 1. UserName is NOT Johnny Case AND 2. Between times 17:45 and 17:59 OR 3. Between times 07:45 and 07:59 The code is placed below; thank you very much in advance...

Hi everyone, Is there a way to rearrange the columns based on values in the cell and not based on the headers? for example the first rearrange would be Username, Hint, Password, Site, the second rearrange would be Password, Username, Site, Hint. If i'm not being clear enough, please let me...

Hi All, I'm practicing VBA for a while now as a hobby and I want it to take a stepfurther. I want to extractdata from a website but the first step is login. Do you know howI’m able to login with username and password on the website below? https://login.transporeon.com/login/ Thanks...

Hi. We got a excel program, which uses: Worksheets("39").Range("Z100").Value = Environ("Username") with adds the users usernames into a cell (Z100), which customizes their experience depening on who they are (userform). But i am wondering. Is there a way to add it so, if a user which is not...