login

Hello everybody. 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)...

Get current system login details with Email id and update in Excel sheet by Vba

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...

Hi, 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 C:\users\****\desktop\predictor.2015.mdb...

Hi, I am looking for a login and logout time tracker for my team. Below is what i have in my mind any better ideas are much appreciated. 1.When User Enter the Employee ID in Sheet 1 Page, it should fetch the name from "Sheet 2"(Data). More people will be added later 2. When LOGIN Button is...

OK the title is a tad long, here is what I need: Say you have a login time and a logout time, this will give you a specific duration in hours and minutes. I would like to spread the minutes across the hours for the day in question: Example: Login Time Logout Time Total...

Hi All, I am a complete novice but trying to do the following in 2 steps. I have a dashboard in an excel document that uses data from a .csv download from a site. There is a direct download URL that requires me to enter my username and password before it starts downloading. I then want the macro...

I have a process where it loops and opens thousands of excel files and then copies each tab to a blank spreadsheet. At some point when it opens the file, it prompts for a sharepoint login. How can i disable it so that it does not prompt me for that info?

Hi all, I created a macro enabled workbook for one of the directors. Works fine in Excel 2007 which we use. he on the other hand uses Office 365. Placing the workbook on his desktop, the macro will not run from the button I created. We have set macro to run without warning and added the...

I tried to come up with a solution, but I am throwing in the towel after 3 hours. (how embarrassing) OK gurus and resident experts here is my Excel puzzle. Details About The Excel File: I have an Excel file with two sheets. Let’s call one DATA and two SUMMARY. DATA Sheet. DATA has been a...

Hi there! I have created a login screen for users, and installed a VBA code to notify them of a successful or unsuccessful login (with the click of a button). From a successful login, I would like Access to default to a specified form to add new records. What code would I use? Do I enter the...

I'm creating an excel macro that will auto login to a website using the credentials from excel. It's working fine except the last part, in which, the website button is supposed to be executed. Sub GoToWebsiteTest() Dim appIE As InternetExplorerMedium Dim objElement As Object Dim objCollection...

<tbody> Abc School Processing date 7/7/2018 to 7/7/2018 ABC school Clearing type 1 productivity report login level cust name domain name slp chq micr chq date slip l1 l2 l3 chi login id 123456 l3 verfication Abc School new Abc...

I have a Access DB which I want to upon a successful Login, allow the user to view tables with read or write permissions or both...This is what I have thus far...Any help would be greatly appreciated... Private Sub btnLogin_Click() Dim strCBOPassword As String Dim strPassword As String...

Hello Sir, I need to know how can I login into the following website using vba. following is the website; firstly I have to open/navigate the following web. Once it is opened I need to click login page . https://www.tdscpc.gov.in/ regards, motherindia

Long code short, I've created an ERP system for tracking shelf life for materials. The open sequence is as follows: On Workbook Object Private Sub Workbook_Open() Sheets("Lists").Visible = True Sheets("Materials").Visible = True Sheets("CurrentMaterial").Visible = True...

Hello, I have a question on trying to run a query. So I have a report that has all my information and I ran a query to pull up all duplicates. I created another query to add up those duplicates. Now I want to to bring those duplicate totals back to my original spreadsheet. Ive been stuck with...

Hi guys. Can anyone help me with a code to export data from a website with login? access www.myurlfake.com/login user: userME pass: user123 after login goes to this page www.myurlfake.com/requests and exports the entire webpage

Hi, I'm trying to write a piece of code to login to a website, and then do some other stuff like pull data etc but I'll worry about that later. I think I understand using this to enter the username and password, and then click the submit button doc.GetElementByID("username").Value = User...

Hello, I have a website, for which I would like to write a macro for providing username and password, and log in with specific credentials. The website is written in JavaScript language. I am using MS Excel 2016, IE v11. Here is my current code (I needed to provide "xxx" where necessary): Sub...