Excel Workbooks, user returns, extract unique data

[samanco]

I have a, Excel 2003 workbook to distribute to clients, asking them to
complete some data and return to me. The workbook contains many
macros and user forms and considers users to be a little "timid"so
automates many of the normal user controlled functions such as the
saveas & mailto features.

I have tested the code and everything seems to work fine, IThe
completed workbooks are auto emailed back to me on completion by
users. I recieve a completed workbook back attached to an email,
filename as clientname, based on a user inputform.

So I have 20 or so emails from different clients all with a
spreadsheet attached I save the attached file as the username
indicates in a folder of client returns on my hard drive. "Ok so
Far ?

Now comes the time to look at what thy have sent me back ! I need to
do one of two things

a) open the file in excel with Macros Disabled so that I can extract
the relevant data without the "on Open" macro executing which would
overwrite the username with a default file name. or
b) extract the data with a macro that looks in each "unique" filename
in the returns folder and extracts the relevant data to a new
worksheet.

has anyopne any good examples of how rthis can be achieved ?

many thanks

 

[Ron de Bruin]

You can start here
http://www.rondebruin.nl/mail/folder2/saveatt.htm

See this link on the page for merging the data
http://www.rondebruin.nl/copy3.htm

 

[Guest]

Hi,

You can use this by using MSAccess as backend to extract all details from
each excel sheet sent to you, and then by selecting the approriate DSN, you
can connect to the appropriate tables and store the data.

This way you can migrte the data by synching the Access database to
Microsoft SQl Server for future use. database.

Challa Prabhu