importing data from excel form

[jmann444]

I am trying to import data from a form into an excel file. The file would have the same headings/similar that are on the form. There are about 700 of them. i would suspect that since the form is an excel worksheet this might no be very hard, just unsure how to go about it. There is an associated MS Access database that is in use, where the data would eventually end up

[mrice]

Can we assume that the 700 items you are referring to exist as 700 workbooks in a single folder with all the data on a worksheet called Sheet1 and that you are after an output which has a tabular arrangement of a set of headers followed by 700 rows of data?

[jmann444]

Yes, and No,

Thre are some 700 work sheets in 7 folders 0-100, 200, and so on. All of the file names are 001, 002, 003, and the like. My desired output is each worksheet become a sinle line in a database that I can work with.

[mrice]

Can you try the attached?

The macro code on the Module1 sheet is as follows

Please Login or Register  to view this content.

You will need to amend and add some extra lines to the Test subroutine, one for each of your folders. You will also need to add some extra fields as I've just done the first four plus the name of the file.

Hopefully this will get you started.