Hey Dear community,
i have big list of users login and logout time, i need to count users work time, i use minifs and maxifs to find login and logout time minifs-maxifs=result , is there any other ( easy ) way to do this?
Names are in D:D and times are in J:J
I want to do a macro (hopefully record macro) and need to extract data from a website that requires a password. However, my colleagues have their own login ID and password, and i do not want to share my login ID and password with them. What should I do such that i can retrieve data from the...
I am trying to extract data from a web page through power query, new query using excel 2016 but unsuccessful as it requires to login to access the web page ,
Anyone knows a technique to achieve this.:confused::confused:
I have a spreadsheet as below. Is there a macro that will open my email client and send an individual email in bulk to all in the sheet? Thanks
I have a excel template where I have 8 shapes created as button and assigned a macro to each shape.
Is there a option to disable the Shapes where the users are unable to click the shapes to run the macro.
I have a shapes with names Login and Logout.
When the excel is...
I am building a customer login sheet/tracker. I have a tablet that I will be running the login sheet off of for the customer's to fill in their information and I have put a shape at the bottom that looks like a button. I want to add a macro to where when they click the button, it copies...
Hey Dear community,
I have a login details which i need to report. i can't figure out how can i ask excel to find first login and last log out data for each day of month for each person from table? Can anyone help me with VBA or formula please?
B - DATE
C - Name surname
F - Client id
J - login...
Want log in to a website automatically with vba but the problem I am having when I inspect the login box there's no ID HTML only what's in the picture below, tried using this line of code but doesn't work:
HTMLDoc.getElementById("login").Value = Worksheets("Portal_Access").Range("F20")...
Tried a lot but I can't figure out how to login on this website.
Could someone please help me out ?
I want to scrape some data from a website but I couldn't even login with VBA code because it's keep saying "Object doens't support this property or Method" with this code:
I am processing thousands of xls files and randomly I will get a popup that halts my processing. It is a login window (https://login.microsoftonline.com). Why does that come up and how do I avoid this so it does not halt my execution of my code?
Can anyone give me advice on where to get help for hiding rows based on what user you are. I have a userform where users will register and then login to access a certain sheet. Once they register it will place them in a certain row alphabetically so when they login I would like to hide all...
I have a spreadsheet which has the URLs, User Ids and Passwords mentioned in columns A, B and C.
I wish to put a button against each row, which when clicked, takes me to the URL and logs me into the website using the login Id and password.
I searched through various threads but did not...
Hi, Expert I am new in a Excel. I went to get you expert solution for Excel VBA. I create a Excel Data entry UserForm & Excel LogIn From Option. But I face some Problems, When I open the Excel file then First show log in option But when I cancel the loginform then it show my Data Entry...
When I first visit the forum, I see the article list. Then suddenly I am redirected to the login screen, and I can only return to the article list after about fifteen seconds. Ugh.
Then often I'll answer a question, spending ten minutes, taking screenshots, etc. I click on Post Quick Reply or...
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?
I'm trying to navigate a website as hundreds of time I've done. Probably I'm a little bit tired, anyway this time I cannot login because a particular framework with tabindex.
The usual strategy doesn't work (no errors but nothing happens)...
I'm trying to build a macro to go to a website, log in to an account, and retrieve data. The login form isn't on the web page as soon as it loads - you have to click a button first to make the form pop up. I'm getting an "object required" error message on the final line of the code below, even...
I have an excel spreadsheet that has a MS query where it pulls data from an Access database query.
This has always worked fine up until now.
When i attempt to run/refresh the spreadsheet i get the message:
ODBC Microsoft Access Driver login failed