Permajeo
10-22-2008, 06:44 AM
Hi all,
I've lurked here for a while but now have a problem with an Excel 2003 spreadsheetand just remembered that I haven't used VBA for a few years and am very rusty. Here goes!
I'm working on a survey across 27 schools with the potential of 13000 returns.
Each participant completes a word form and saves it in .doc format.
What I want to happen is to open each word form, save it as a word.txt data only (like a .csv) then import that data into Excel for analysis, then close the data form and move on to the next .doc and repeat until the last one.
Once the raw data is in the spreadsheet I'm ok but it's getting the data in there quickly I'm struggling with.
Any ideas would be great?
P
I've lurked here for a while but now have a problem with an Excel 2003 spreadsheetand just remembered that I haven't used VBA for a few years and am very rusty. Here goes!
I'm working on a survey across 27 schools with the potential of 13000 returns.
Each participant completes a word form and saves it in .doc format.
What I want to happen is to open each word form, save it as a word.txt data only (like a .csv) then import that data into Excel for analysis, then close the data form and move on to the next .doc and repeat until the last one.
Once the raw data is in the spreadsheet I'm ok but it's getting the data in there quickly I'm struggling with.
Any ideas would be great?
P