Recent content by Dryseals

Just a follow up, its running like clock work. I was pulled off of it for a few days but got back on it yesterday and found a few things that needed attention. A simple Workbooks open and close was all I needed. I was using the excel.application and having troubles. In a nut shell, do a...

1. Do all of the columns change exactly once in the data set or can the inputs toggle back and forth more than once? Back and forth at any time 2. Do all of the columns always start in a predictable state? (Like always FALSE, e.g.) No. 3. If the inputs toggle back and forth, do you need...

Thank's to all, I did manage to get it working using just objects in Excel with out doing an import of the entire sheet, its much slower than doing an import and working it as a recordset. So I have two methods, one with the import which I limit it to 300 sheets, takes about five seconds to...

Thank You The_Doc_Man, exactly what I was looking for. I've been using Access now since version one back in windows on 386 machines, no formal training, school of hard knocks and lots of trial and error and I don't use it every day, but some how they found out I could do some things special...

Thank you!! I will give it a try.

Need some help. I have just over 14,000 excel files to process, each work book has a sheet “Data1” which is a time and date stamped record of Boolean outputs on a system. The first two columns are Time and Date the remaining columns are the names of each Boolean output. What I am looking for is...