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 have a function written in VBA that does what I want it to (see below. note: I did not write this function myself)  What I wanted was to a function, say, "=LastModifiedDateOf(CELL)", where CELL, is a parameter that indicates the cell I want...
I'm trying to manipulate Word from an HTA file application. Currently, when I open word, it opens underneath my application. I'd like to open it on top. I've tried using the following JScript to give Word the focus:  wshShell = new Active...
I have seen this question posted before, but my situation is somewhat different so I was hoping I could get some help from the community and maybe a fresh perspective. I have a macro written in vba that's supposed to pull return data from this co...
I'm trying to grab som data from a webpage with Excel VBA.  The HTML code is:  <div id="PriceLabel" class="skuPrice formRow">   <span class="skuPriceWrp">     <strong class="price red" id="skuPri...
I’m a beginner and desperately seeking for help. I would kindly request your support and apologize in advance for the poor wording and eventual lack of info (again, I’m a rookie). I’m building an Excel macro to fill in a (private) webpage and a...
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 am trying to execute a javascript function using VBA but without success.  I select an item in the list box.  My goal: refresh the result after item selected.  VBA:  IEdoc_NEW2.getElementById("native_dropdown_selected_size_name").selectedIn...
Summary:  Basically trying to edit a website with Excel VBA. The edits appear to work, but when I use the save button, nothing is saved. I know the save button works, explained below. So why isn't my updated data, which is visible on the screen b...
I know a similar question has been asked and answered before a few times: Parsing JSON in Excel VBA, Excel VBA: Parsed JSON Object Loop  However, the above solution doesn't work if I am trying to access an array within the returned object.  I'...

Tags

Recent Questions

Top Questions

Home Tags Terms of Service Privacy Policy DMCA Contact Us

©2020 All rights reserved.