login

Hi, I'm trying to use VBA to login to this website: NetStore I started using this tutorial: Daily Dose of Excel » Blog Archive » Get Data from Website that Requires a Login but I wasn't able to fill in the username/pasword or to use VBA to click the submit button. I also tried to use this...

Hi, I am trying to write VBA code to login and chat using Excel VBA. I have used Shell command (as shown below) to open gtalk, but not able to figure out from there. Shell """" & C:\Users\Google\Google Talk\googletalk.exe & """" Thanks in advance for your help. Regards! Vikas

All: First and foremost I just want to say how vital this website is as a tool for someone who is trying to learn without a formal programming education. I have been lurking on this site for months now and in that time I have learned enough to actually start writing my own codes. After reading...

Hi all, I'm trying to create a macro, that would map a network drive to a letter, login, and post some files there. I have been able to accomplish all but the login part, which is a bit of a pain... Below is what I've got so far: Sub MapDrive() ' =================== MAP DRIVE Z...

Hi guys, I've been going around in circles for days trying to solve this problem. I am trying to login to a site and download a file using an InternetExplorer object with VBA. The problem is that once the code clicks on the hyperlink I get a prompt from Internet Explorer (version 10 in my...

Hey guys, no formal training but I like to tinker, so I'm working on a tool that will login to a website by button. I pilfered some VBA from somewhere else and got it to work. Sub Test() Const cURL = "xxxxxxx" 'Enter the web address here Const cUsername = "xxxxxxx" 'Enter your user...

I would like to write VBA code to log into the below (and other) sites. I would like to then navigate within those sites (clicking links) to get to different pages where I would eventually be able to download Year to Date Statements. I am struggling with determining which commands to use in...

I am in need of a login user form that requires a username and password to use the file, the poor protection this method offers not withstanding, I found code that seems to work (the link is below) but the only problem i'm having with it is that even when the correct login information is entered...

I found the following script on Google to login to hotmail and it works perfectly. The only thing is, I would like to open Hotmail in a new tab NOT in a new window, can anyone help with this. Sub IE_Login_Hotmail() Dim objIE As InternetExplorer Set objIE = New InternetExplorer...

Greetings! Can anyone help me how to make a vb code that will fill up the login realm when I click a command button? A have a sample here of scenario. 1. First is I have a command button that when I click, it will direct me to the webpage. Code: Sub ip_address() File = "http://" &...

Need to download and refresh data manually once a week. Created a Web query but since the website requires a login, I have to create the query all over again next time I wish to refresh the data. Even when the query is saved. Is there a way to use vba to either automate the refresh or at least...

Hello Everyone, I tried to search this one but could not. I need to track and colate user's away time and avaliable time in one hidden sheet. It is to matched withthe production tracker in excel sheet. I am a novice in this part. Please help.

Every time i want to refresh data from accounting database, DB login window pops up. Is it possible to add the login and password into the connection string below to bypass the login window?? Thanks With ActiveSheet.ListObjects.Add(SourceType:=0, Source:=Array(Array( _...

I am having an issue trying to locate the USername/Password with code to enter my text. The javascript login page is a small window that pops up but contains no source code. How Can i locate the fields to enter my text?:(

i am preparing an attendance tracker in excel 2007. In a company the login time is 10 am. and as per the time their status should get updated 10:00am - 10:15am - late 10:15am - 11:30am - Permission 11:30am - 3:00pm - halfday 3:00pm onward - fullday off or leave i have been able to use 2 nested...

Hey guys, I tried doing a search of this but was not able to find exactly what I was trying to do. I have a few websites, logins and passwords in my excel cells and I wanted excel to help me auto log in. For example: A1:www.google.com B1:login B2:Password A2:www.Yahoo.com B2:login...

Hi all, I am new to excel vb and I am using a login and password form that I have downloaded for my workbook. It works perfectly until I click on Enter without any information entered in the user name or password boxes. It then gives me a run time 1004 error which means the instruction on what...

Hey all! I have been looking at methods to refresh data from a website where you need to login and I have seen a few ways of doing this. I know it does vary from site to site and of course my preferred method, but at this point I am looking for advice on the best possible solution to my issue...