Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
automate data retrieval from folder
We recieve excel spreadsheets that have data on one line on the second sheet
in the workbook as an outlook email attachment. These are all in one outlook folder. the one line contains information on customers our sales people have signed up for our services. It's a standard worksheet that all the salespeople use and fill out then email to us. I have to copy that one line manually from each attachment into another spreadsheet (and eventually to a database). I would like to be able to automate the copying of this one line into the "table" spreadsheet. If moving 7 detaching all the attachments to one file somewhere would make this easier that's not a problem. I just want excel to copy this one line from each spreadsheet so I don't have to do it manually and past then all in a single spreadsheet. (also maybe move the files to a "completed" folder would be nice too). Thanks for anyones help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data storage/retrieval | Excel Discussion (Misc queries) | |||
Data Retrieval | Excel Discussion (Misc queries) | |||
Data Retrieval | Excel Programming | |||
retrieval of data from web to excel | Excel Programming | |||
Troubles doing Data Retrieval from SQL | Excel Programming |