Home > IT Answers > Microsoft Windows > easy way to automate uploading data from a wo...
Help

Question

  Asked: Apr 4 2008   3:01 PM GMT
  Asked by: Juls

easy way to automate uploading data from a word document to a spreadsheet?


Microsoft Word, Microsoft Excel, Excel macros, 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?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Apr 4 2008  6:28 PM GMT  by Jlees




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.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Microsoft Windows and Development.

Looking for relevant Microsoft Windows Whitepapers? Visit the SearchWinIT.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Jlees  |   Apr 4 2008  6:29PM GMT

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

 

Juls  |   Apr 9 2008  2:29PM GMT

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  |   Apr 11 2008  7:22PM GMT

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  |   Jun 2 2008  6:24PM GMT

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

 

Juls  |   Jun 2 2008  6:25PM GMT

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 <a href="mailto:jrc_75023@yahoo.com">jrc_75023@yahoo.com</a>

thanks!
Julie