Search results for query: *

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...

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...

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...

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...

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...

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...

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...

I am trying to run macros in excel VBA to open a web page and interact with forms. The code works great but sometimes the opened browser window is not brought to the front, so I am trying to use a couple of APIs to make that happen: Public Declare Function FindWindow Lib "user32" Alias...

I am scraping data from a web page HTMLtable using Excel 2010 VBA and have succesfully captured all of the table cell values. However, for one of the cells, the value is a partial string of the data I need. The actual value is contained in the onmouseover property/event. In other words the...

I am using Sharepoint 2003 and need to be able to create a large number of views for a particular table. The only difference in the views is that they are filtered by a field with an incrementing counter. In other words View 1 will have a filter of field = 1. View 2 is field = 2 etc...

I am an experienced VBA user in Excel but I have never written anything for outlook. I have a local folder that contains individual email files that I need to open using Excel 2007 VBA My problem is I don't know how to open the email files in a format to read them. For example, if it were...

I know this should be easy but I can't get anything to work. I have an Excel macro that needs to End if the active cell is null but run otherwise. My problem is that everything I try reads a 0 (zero) as null/empty and ends the script. I need a 0 to still trigger the code and only a true null...

I am using VBA in Excel to create a 3 dimensional array. I need to write the contents of that array to various sheets in a workbook. I know I can write them field by field but that is a very slow process. With 2d arrays I just usually assign to a range like below: Sheets(1).Range("A2:Z60000")...

Using VBA within Excel 2007, I am writing a 1-deminsional array to a text file by opening a file for output, looping through each element of the array and printing them to the file. Open (path of file) For Output As #1 For a = 0 To b Print #1, Data(a) Next a Close It...

I am using Excel VBA and the FileScriptingObject to open, read and close all text files in a folder. The script works great on my local drive but when I apply it to the network it slows to a crawl. I expected it to be slower, but it is taking over 15 times as long. Here is the relevant code...

I'm using Excel 2002 and I want to tie a mouse event to a shape. I know that isn't supported and that charts does offer those events. But that solution does not work for what I need to do. I really need to apply a mouse event to a shape. Is that competely impossible?

I am using Excel 2002 and have a series of shapes grouped together. Half of them are Form Control TextBoxes and half of them are freeform shapes. I want to be able to identify the textboxes and change the properties using the mousemove event but I am having problems. Here is the code I am...

I am using Excel 2002 and am creating an interactive map using shapes. I have grouped multiple shapes together and I have assigned a macro to fire when the group is clicked. I need to be able to identify the individual shape within the group that was clicked. For example, if the group is a map...

I am using Sharepoint 2003. I need to set up an issue list so that when a user submits an issue an alert is sent to a specific group of users. Currently, the issues list Ihave only allows a single user to be selected.

I need to create a spreadsheet with two drop down lists: State and city. I need the user to be able to choose a state in the first box and then based upon that result, the second box gives choices of cities only in those states. The trick is that I can't use any macros or VB. Any ideas?