Recent content by FractalWalk

I appreciate the reply, unfortunately that doesn't help me. When I do that there are no little yellow boxes to click. Secondly, that seems like it is opening up and loading the web page in a browser which is what I am trying to avoid due to my issues with page loading time errors and just...

I am trying to loop through a list of NFL players and extract stats from a website. I originally was using the InternetExplorer.application object but it was waaaay too slow and often run into problems with the page loads. After searching online I think using MSXML2.XMLHTTP60 is a quicker...

OK, thanks. I will look into the library solution.

I think I know the answer to this question but I hoping someone here can confirm or deny. I have an Excel add-in that stores macros that I am using to call from other open workbooks. I am using Application.Run to call them and they work in general with the exception being when I pass a variable...

Ah! I totally misunderstood what you said. Yes, that works perfectly. Thanks!!

Maybe I wasn't clear. The second macro is to turn the function I assigned off, which I am intentionally trying to do. If I don't run it then the function I have assigned is still active. I want to de-activate my assigned function and re-activate the default function that Excel assigns when a...

I have several macros that I use all the time in Excel and so I have mapped them to function keys. However, I want to be able to toggle that ability on and off so that I can access the "original" function of those keys when I need to. So I have built a menu with drop downs to "Turn on" and...

Understood, but I am not asking to fix specific code, rather I am asking what is a better practice regarding memory leakage. I guess to put it simply, I am asking if this: Set wb = Workbooks.Open(fnme, True, True) wb.Close Set wb = Nothing is more memory efficient than this...

This is a general question and not about specific code. I utilize multiple processes that open Excel spreadsheets, extract data to arrays and then prints those arrays to text files. My problem is that after a few runs of doing this with bigger files, I end up with an "Out of memory" error. It...

OK thanks, that's a lot of info for me to digest. But before I do let me ask this. You keep referencing a user form: If you add the control to your userform . . . like in case of controls on the userform or userform itself. What userform are you talking about? I am trying to read a window that...

Thanks for the reply. Unfortunately I am not an experienced programmer so most of what you said went right over my head and a couple of days reading hasn't helped me understand it any better. How do you instantiate and manage internet explorer? Well, the original IE window is launched with...

What do you mean? I know I will likely have to utilize DoEvents in my code but that isn't my question. My question is if I know the handle of the IE notification bar is there VBA code or an API I can use to extract the text that is displayed in that bar? DoEvents doesn't do that.

I have written an Excel VBA macro that opens an IE9 window and goes through a series of forms and filters to create and download a report. The final step is to click an element to save the report to my local drive. At that point the report and its URL is created by Javascript on the fly so I...

Thanks. Evidently CCUR allows 4 decimal places and I need it fixed at 2, but I have worked around that.

The array contains text, dates and values. I can't use currency on that array. I have to use variant don't I?