Hi,
I was wondering if anyone knows a way to get a specific cell loaded into a website automatically. (i.e. Cell A2 always goes into the input username box on the website, Cell A3 always goes into the input date section of the website).
Thanks.
Hi,
I was wondering if anyone knows a way to get a specific cell loaded into a website automatically. (i.e. Cell A2 always goes into the input username box on the website, Cell A3 always goes into the input date section of the website).
Thanks.
Hi,
Is there a way to create a macro that will automatically copy a cell and input it into a specific "input text" box in a website?
Thanks.
Souljive, to all intents and purposes your 2nd post here is (was) a dupe thread and as such does not comply with Rule 5 of our forum rules.
On this occasion I have merged the threads as the narratives are slightly different and each give important bits of info.. going forward do not post duplicate threads.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Hi,
I tried scouring the web and came up with this code to input a login name and a password into a website:
What I am trying to do is have the code look into the HTML of the site, find the UserId and Password fields and fill them in. I think I am really close, but the example I saw on the internet is when the intput text boxes were used as forms in HTML, not tables. Here is how my HTML looks:![]()
Sub OpenWebpageAndLogin() Dim objIE As Object On Error GoTo error_handler Set objIE = CreateObject("InternetExplorer.Application") With objIE .Navigate "https://SampleWebsite.com" Do While .Busy: DoEvents: Loop Do While .ReadyState <> 4: DoEvents: Loop .Visible = True With .Document.forms("InputFormA") .loginname.Value = "My Username" .Password.Value = "My Password" .Submit End With End With Set objIE = Nothing Exit Sub error_handler: MsgBox ("Unexpected Error, I'm quitting.") objIE.Quit Set objIE = Nothing End Sub
Please let me know if you can help me rearrange the VBA code so that it puts in the username/password! I think I am very close.![]()
<tr> <td colspan="2"> <input class="InputFormA" name="UserId" type="text" id="UserId" size="38" maxlength="48" value="username" style="background-color:#FFFFCC;"> </td> </tr> <tr> <td colspan="2" class="wdc-text-comments-bold">Password:</td> </tr> <tr> <td colspan="2"> <input class="InputFormA" name="Password" type="password" id="Password" size="38" maxlength="48" style="background-color:#FFFFCC;"> </td> </tr>
Last edited by souljive99; 10-02-2009 at 04:50 PM. Reason: codes impromperly bracketed
souljive99,
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
Please edit your prior post accordingly further please take the time to read (and subsequently adhere to) the Forum Rules before posting further.
sorry about that, I put <> instead of brackets.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks