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

Tags

Recent Questions

Top Questions

Home Tags Terms of Service Privacy Policy DMCA Contact Us

©2020 All rights reserved.