Home > IT Answers > Development > easy way to automate uploading data from a word document to a spreadsheet?
Juls
45 pts.
 easy way to automate uploading data from a word document to a spreadsheet?
Excel macros, Microsoft Excel, Microsoft Word, VBA, Visual Basic for Applications
I have a spreadsheet to verify datafields for. This needs to test for example state all the valid entries. I do not want to save off a spreadsheet form of the template i am testing one for each data value I need to test. Is there an easy way to create many spreadsheets off of a data file I create in word or .txt for the data to fill it out with?

Software/Hardware used:
ASKED: April 4, 2008  3:01 PM
UPDATED: June 2, 2008  6:25 PM
RELATED QUESTIONS
Answer Wiki:
I believe you can, I do this often from the scripts I create. You can import a Comma Separated Value (csv) or Tab Delemited document via the file/open dialog in excel.
Last Wiki Answer Submitted:  April 4, 2008  6:28 pm  by  Jerry Lees   5,320 pts.
All Answer Wiki Contributors:  Jerry Lees   5,320 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

does this answer your question, Juls? Let me know and I can provide more information with more details.

Be sure and check out my blog here on ITKE for more Network administration and VBSCRIPT tips.
The VBScript Network and Systems Administrator’s Cafe

Jerry Lees
 5,320 pts.
 

Thanks for the help.
i was thinking after talking with a coworker that I might just use the WinRunner automation tool we have with the spreadsheet being my System under test. i had not thought about the csv import that might be even easier.

Juls
 45 pts.
 

Hi Jlees, I have been busy on other things and just now getting back to this. Can you please send me more information on the easiest way to do this. I want to have several files with the same data format but a little different data and be able to quickly import them to the spreadsheets.
Thanks
Julie

Juls
 45 pts.
 

I what is your email address? i am working on another project also. i am sorry for the late response.

Juls
 45 pts.
 

actually i have been moved off this project. i will get back to you if we need more help on it later.
I can pass on any examples you have though if you want to send them to me at jrc_75023@yahoo.com

thanks!
Julie

Juls
 45 pts.