-----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.