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>                 <...
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...
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...
I am trying to create a web query for excel but I ran into a bit of a snag.  I figured out how to log into the web page and click a link to go to the right portalID.  However I am having trouble getting to specific reports.    To get to specific repo...
good afternoon!  I'm trying to run a Macro that opens a website, login, select an option in the menu, fill a text-box and click another button.  So far, I can open the website, login, select the option in the menu, but I can't get the text-bo...
First post. No idea how to do this. Never retrieved data from a website before. Can navigate through VBA to a page with options to open reports, but at this point everything goes from html to Javascript to open reports. How would I go about opening t...
Background (Optional): I wrote a working script in VBA that I'm trying to write in JS for Google Spreadsheets, but I'm having a tremendous amount of difficulty with the regex validation on a per cell basis.  In this VBA code snippet, I set a...

Tags

Recent Questions

Top Questions

Home Tags Terms of Service Privacy Policy DMCA Contact Us

©2020 All rights reserved.