multiple instances

Hi all, This is a little Class which should allow for iterating over all running instances of excel, access and word in your computer. The GetAllApplicationsRefs Method gets you a COM reference to each and every instance of each application. As we know, the vb GetObject function attaches to...

Hello everyone, I am working simultaneously with multiple instances of Excel, as this is a way to utilize more CPU and decrease calculation time per instance. Basically, there is one "Master" instance and several "Slave" instances. When I start the day, I first open the Master Instance, and...

Do While ia < 16383 'limited to how many columns are available to be populated ActiveCell.Offset(0, 1).Select 'shift cell to seach If ActiveCell.Value = SN Then ia = ia + 1 'counter for columns Do While ib < 13...

I have a process that runs all day, gathering data from the web, storing that data on an xlsx file, closing that file, and starting another xlsm book that further process the data while the original process goes back for more collection ( collection of other "parts" of the whole range of data...

I apologize in advance if this has already been addressed and I just couldn't find the answer by searching for it... I have Excel 2003 and Vista 64 bit (which actually seems to matter here). I click a spreadsheet and it opens OK. I click another spreadsheet on my desktop and it opens in the...

Hey guys, I am working on an application for a monthly sports tournament that I run. There are three workbooks to this application: the Administration workbook, the Bracket workbook, and the Leaderboard workbook. I currently have a dual monitor setup (extended, not clone) with my laptop in...