instances

I use a macro to loop through all open workbooks, extracting data from them. This work fine except that I found out that if some of the workbooks are opened in an other instance of excel they are not included. Can I force the macro to run through all instances of excel and then through all...

I've developed an Excel 2003 application where the interface (both input and output) is performed exclusively through userForms. Some of my users (not all) generate input data with another Excel workbook. To ease data entry these users would like to toggle between their worksheets and my...

Hi All, this is my first ever posting so hope this is all correct (apologies if it is not please let me know what to do next time if I am incorrect) I am trying to do a spreadsheet which counts sick leave/annual leave etc so far it is all easy but I decided to take it up a notch and got stuck...

Hi there<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I'm working on a database for a Dutch nursing home, which - if I ever get it to work properly - will eventually contain data on several hundred people. To help users navigate through the...