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'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 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...
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...
I know it's a bit silly to load a js into VBA, but I need to load the libphonenumber library by Google to perform an analysis of a big bunch of phone numbers.  I tried to adapt the following code borrowed from here, but the compiled library is to...
I have an Excel file that we keep for things we find around my job.  We have to log into a website in order to check certain things. With VBA, I've gotten an IE window to open, I get it to log in to the website and fill out a form (and submit it!...
I have an HTML document that contains geographic information within a block of Javascript. It is the source code from this web page: https://energy.ehawaii.gov/epd/public/energy-projects-map.html  This can be viewed as a map and also as a list.  What...
When writing my VBA macros I often used "GoTo" so as to jump to a previous part of the macro without leaving the Sub. Now that I’m converting all my macros to Google Apps Script I’m trying to find the equivalent for “GoTo”.  Sub MySub...

Tags

Recent Questions

Top Questions

Home Tags Terms of Service Privacy Policy DMCA Contact Us

©2020 All rights reserved.