-----Original Message-----
Hi,
Are the workbooks named sequentially, eg: Hmm1, Hmm2
Hmm3 ... so I can cycle through each of them. Or do they
have odd names like thisfile, thatThing, Dooby, etc?
The name changes with each file, it does (mostly) follow
a defined format, but there is no incremental link.
Are they found in the same folder or are they in
different folders?
Different sub-folders of a main folder.
Are they in a different directory or Drive Letter?
Yes, they are on a server and the application will be
stored on a seperate server.
Is there more than one sheet in each workbook or does it
vary per workbook?
No, there should only be one sheet in each workbook.
Is there a reference to use to find the Row/Column cell
value ie: if cell.value="Library" then
Yes, there is a reference value that acts as a column
header within the workbook, but it's not in the first row
and rarely in the first column.
If you can answer any of the above questions, I might be
able to answer a few of yours. You might be able to
access the excel files directly into Access or, if not a
VB6 Userform, or Excel itself.
visit
http://au.geocities.com/excelmarksway
http://au.geocities.com/windsofmark
I will, thanks.
I am not too familiar with Access but have some user
knowledge of VB6 and Excel Userforms.
I hadn't heard of Userforms...
How could they help me?
Send a sample sheet with a scenario you have in mind.
Sent privately.
regards
Mark E. Philpot
It's free until I say its not.