javascript

I am trying to pull the interest rates from the first table of the following page: Bank Accounts | BMO Bank of Montreal However, my code bellow isn't extracting the "0.80%" value and is only extracting "%". I think the values automatically update through javascript. Is there any way to extract...

Hello, I was wondering if you anybody came across solutions to transform excel models into user friendly mobile or web interactive dashboard. I know SAS crystal xcelsius may do that, but they have a Flash version that doesn't run on iPad. Here is an example of web model we have developed...

function ur_IScr_toNextPage(sId) { if (ur_IScr[sId].last < ur_IScr[sId].items.length - 1) { ur_IScr[sId].first = ur_IScr[sId].last + 1; ur_IScr[sId].last = - 1; ur_IScr_draw(sId); } } hello I have a webpage which I need to click the next page, I tried looping through all links but...

Farm boy needing a hand here: I am lost on this I have been puttering around with this for a month now and no luck. I want to get all the Agriculture delayed quotes from the CME website and input it into excel and update say every 20 minutes. The issue is, that all the data is being generated by...

Hi, I want to download a bunch of data from the following website:BM Unit Data I can only download a day at the time, and a unit at the time, so I don't want to do this by hand. I've written a sub that goes to the website and sets the attributes in Java. This works for everything but the...

Sounds like a weird question, but all my search efforts only yield me the opposite answer (posting an excel sheet to/on a website). I was wondering if it is possible to open and, if so, to navigate a website within a single sheet in an excel workbook... Looking for more than just a simple...

Hi relatively new to vba and particularly web querying. I am basically trying to download historical data from Zurich Life Fund Prices , have found it no problem to download the prices for today, but was wondering if there was a method to download prices for 13th, 12th etc etc. I'm not sure if...

I have a finance calculator that I wish to embed into a website. It works great using the new Embedded Web App in Excel 2013 using Skydrive but I would like to able to remove the "Excel Web App" Footer...

Not sure if this is the right section or even the right forum for this question but I hope someone here can help. I am in the process of moving a very useful Excel document that I created to Google Doc's. The problem is that it is useful because of the VBA Macros that I have built in it and of...

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 everyone, I'm new to VBA and I'm looking to write a macro that calls a JavaScript function via Internet Explorer because I'm also lazy. My work computer is networked to my phone so I'm able to dial phone numbers by clicking a link on an internal webpage that calls a JavaScript function and...

Hi, I am having trouble figuring out how to use vba to automate clicking a button that is located with one of a set of tabs in a web page. I used inspect element in firefox to figure out the element id for the button i want to click (which is "runscreen" but i cannot find this element id when...

Hi, I am having trouble figuring out how to use vba to automate clicking a button that is located with one of a set of tabs in a web page. I used inspect element in firefox to figure out the element id for the button i want to click (which is "runscreen" but i cannot find this element id when...

Excel friends, I need to read and copy a bunch of web pages in EXCEL 2010, easy to do with data-from web. The challenge for me is that the webpages have this code in there: href="Javascript:serpShowTelephone('12345678','012345678'); The phone is shown only when you click on it! So, the phone...

I am trying to loop thru all links on all pages of a website to find pages that have links to PDF files. Do you have a code sample for that? If not I think I can figure out that myself. Now to my real problem; Some links are in a cell in a table on the webpage, like this: <td...

I have an Excel VBA that opens a webpage and clicks a link. The link runs a JavaScript that generates a PDF page in a new IE window. So far all is fine, but I have not found out how to save (download) the PDF. Below is my VBA, test it and you can see what I mean: Sub GeneratedPDF() Dim...

I am trying to read the search results from an internal company web page. I can navigate to, input, click send. When the results come back I have not been able to "read" the results. Its a javascript postback The source code for the web page does not change. The end of source page reads...

There's a Javascript popup box that asks if I want to enter a color. I just need to hit the cancel button on the pop up or simply skip the popup entirely. I've achieved this using SENDKEYS but I would like this macro to run in the background so this is a last resort solution.

I am trying to import a table from a website just simply using the 'Data from web' function in Excel 2010 which seems to run fine but no data is actually shown in the worksheet even after the 'getting data......' has finished running. The website I am looking at is...

Hi all gurus, I am trying to grab data from a site. The site is http://nextview.com/quote.php?country=my. From the site, we need to sign up and login. You might need to login to reach the page I show you here. After login, I am going to look for a stock name: AIRASIA. Then, the page as shown...