I'm using excel to get values from a webpage. Among other elements, the HTML contains the following table:  <div id="myDiv">     <table class="myTable">         <tbody>             <tr>                 <...
First Time Long Time.  New to this VBA thing, however catching on.  I'm interested in pulling the upside/downside capture ratio for a lot of mutual funds and want to automate the process. The table I am taking the info from is not your typical ta...
I need to pass arguments to a Excel VBA code from JavaScript of HTA.   I can successfully call VBA function, but unable to pass string arguments correctly. JavaScript function can pass different string arguments.  Below is code in simple and demo fo...
How to call a javascript file (.js) via Excel VBA?    So as i am opposed to the same kind of problem i'll try to submit you guys my case.  I am trying to automate datas extraction from valeo's catalogue using excel vba macro.  I have a list o...
I can't for the life of me figure out how to click the button below with VBA. Any help would be appreciated. I've been able to populate the username/password fields since they have a name so I use getElementsByName but the button doesn't...
This is my first post ever, so I hope not to bore you.  I am trying to use excel vba to access this website to get its data. I can get the data and I can change the dates, my problem is to change the times (e.g. 00:00 - 01:00 to 01:00 - 02:00). I gue...
I'm trying to extract a table from a website using Excel VBA, but the table is created using JavaScript, and I really don't know how to do it.  Generally, I extract a table something like this:  Dim Document As Object Dim StatementTable As HT...
I've looked through several forums, but unfortunately my html skills are not what they should be. Can somebody please help me find the correct command to log onto www.emo.no with Excel VBA? (See code in bottom).  I have successfully managed to fi...
I'm writing my first data scraper using Excel and VBA.  I'm stuck trying to go to the next page of a website. The source code looks as follows:  <li><a href="#" onclick="changePage(2); return false;">Page 2 of 24&l...
I need to by pass an IE confirm 'OK'/'Cancel' pop-up message. I have a problem running a JavaScript function in my VBA script. My JavaScript:   function ConfirmSave() { var Ok = confirm('Are you sure all Documents and Information...

Tags

Recent Questions

Top Questions

Home Tags Terms of Service Privacy Policy DMCA Contact Us

©2020 All rights reserved.