memory

Hi, I am encoutering "Out of Memory" error when running my macro, i have zoom down to this sub that make the memory usage increase from 100,000k to over 500,000k until the error hit This sub will take around 5k data and expand to more than 150k data in another sheet. The funny thing is when...

I'm experiencing this for the first time: I'm using Excel to import about 20,000 web pages. I've noticed that Excel started off flying: 1 page every 3 seconds. Around 1000 it was noticeably slower. Around 2000 it was pulling 1 page every 30 seconds. One thing I've been doing is stop the macro...

Hello, Not entirely sure if this is possible... I'd like to somehow get a count of how many locations each player has scored 5 or more points in, details below. Basically there is an Olap cube set up which I do not have access to change. As a simplified example the data that I have is set...

Basically, I'm using SUMIFS, and the final criterion could go one of two ways: either EMER or APPC are valid values. Here's my formula: =SUMIFS(Data2011[Net Amount],Data2011[Internet Site],A13,Data2011[Confidence %],"B",Data2011[Ad Unit],"EMER") The last criterion, Data2011[Ad Unit],"EMER" is...

Quick Summary: Is it possible to simulate closing Excel and opening Excel from within a workbook using a Macro? Some Details: Basically I have a workbook which runs and when it is done I see that the memory use (in the Ctrl+alt+del system tasks section) for Excel is at 1,250MB. It won't let...

I opened a memory stick on a XP system does evcel store any of the data anywhere ofter the memory stick is removed, files where saved back to the memory stick at that time thanks

This is a bit complicated...<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> Basically I have recaps (excel based reports) which run every wednesday. They are typically approx 1000 rows x 70 columns. One of the columns is usually "ID#" which...

Hello, all. MS-Office apps 2003, Windows XP, 1 Gig RAM. On an annoyingly regular basis, my Excel (and Word for that matter) apps will freeze and go totally whitescreen for a good minute or two. It happens when I close (not open) IE (7 in this case) or other foreign app, or switch from one...

I have some macros that I have setup to continuously run under Excel 2007. Among other things, the macros connect to a webpage and import data from there, also import data from local HTML files and from other workbooks. The macros run 24/7, unattended, on a dedicated machine. Now everything...

I have an excel workbook with 400 rows of data 40 columns wide. I need to be able to view the data in a paredo chart. This data is updated monthly so the chart will need to be updated once the data has been cut and paste. I have tried it 2 ways-building 400 tabs with VLOOKUPS to gather the data...