Timeline for Speed up processing between VBA and IE
Current License: CC BY-SA 3.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 23, 2017 at 12:41 | history | edited | CommunityBot |
replaced http://stackoverflow.com/ with https://stackoverflow.com/
|
|
| Apr 4, 2014 at 14:06 | comment | added | PlainsWind | I know some of the outputs, but not 100% on the inputs. I figured this question was good - thank you for all the help - so I posted a new one under this StackExchange question | |
| Apr 4, 2014 at 13:52 | comment | added | Mathieu Guindon | It all depends on what you want to do with the returned value, but if RunRates is going to return the value returned by FillInternetForm then both will have to be functions. Identify your inputs+outputs first, then write the code ;) | |
| Apr 4, 2014 at 13:47 | comment | added | PlainsWind |
If i were to use a function I should acrtually be doing it for the RunRates () if I am wanting to return a value and not on the FillInternetForm correct?
|
|
| Apr 4, 2014 at 13:39 | comment | added | PlainsWind | It's not part of the code shown bc it's not created yet. I first wanted to make sure sending the information was quick and accurate, then I was going to work on the return portion of it. | |
| Apr 4, 2014 at 13:38 | comment | added | Mathieu Guindon |
If FillInternetForm should return a value, then you're missing a line of code that would assign such a return value (FillInternetForm = TheReturnValue). You're not showing the code that's calling FillInternetForm, but if it's a procedure (sub) it will look like FillInternetForm and if it's a function it will look like Value = FillInternetForm. I don't know of any articles that return results from iframe (maybe Google does), but my initial thought was that if the form is on a .asp page you probably could get away with sending a simple HTTP request with your parameters, to the URL.
|
|
| Apr 4, 2014 at 13:28 | comment | added | PlainsWind |
My overall plan with this code is to return the values from the webpage back into the excel sheet: 1. Wouldn't I need to leave it as a funciton as I am seeking to return a value? 2. Do you know of any articles that will return results from iframe?
|
|
| Apr 4, 2014 at 13:26 | vote | accept | PlainsWind | ||
| Apr 2, 2014 at 20:59 | comment | added | Mathieu Guindon | That would make a good reason to put a comment, so that call doesn't get inadvertantly removed by a future maintainer (could be future you!) - feel free to upvote any useful answers you get ;) | |
| Apr 2, 2014 at 20:48 | comment | added | PlainsWind |
Thank you for the response - haven't gotten a chance, as of yet, to take your suggestions, but wanted to answer the Num Lock question. I have it in place because when I run the Sendkeys it actually turns the Num Lock off. By having this code it place it will turn it back on.
|
|
| Apr 2, 2014 at 19:48 | history | answered | Mathieu Guindon | CC BY-SA 3.0 |