Search results for query: *

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?

OK, thanks. That should work for this section. But there are multiple parts to my code and one of them uses a variant array. Same issue there. WHen Iread the currency values into the variant array, the values change. I can't use currency for the whole array so how can I get proper accuracy...

I am having trouble with the simplest of issues. I am using VBA in Excel 2010 to read a list of prices from a spreadsheet. I then summarize the array by categories from the spreadsheet to get subtotal prices by category. But when I add the prices together, VBA does not total the price...

Of course after days of researching I finally post and then find my own answer a few minutes later. I located a refernce to Microsoft.XMLHTTP. Not exatly sure what it is but it works. UserName = [I will setup a menu for this] pw = [I will setup a menu for this] sharepointUrl =...

I need to be able to replace a text file to an existing folder on a Sharepoint site using VBA. Due to network admin constraints, I can not use a shared drive solution and the site itself requires a username login and password. When I search the web (and this site) the solutions tend to be...

Again, this is your problem right here: If MsgBox(Prompt$, vbYesNo + vbQuestion + vbMsgBoxSetForeground, "Check for Attachment") = vbNo Then Exit Sub Exiting the subroutine does not cancel the send event, it just leaves the rutine that is run before sending it. You need to cancel the event...