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

45 pts.
Tags:
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?
ASKED: April 4, 2008  3:01 PM
UPDATED: June 2, 2008  6:25 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Jerry Lees
    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
    5,335 pointsBadges:
    report
  • Juls
    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.
    45 pointsBadges:
    report
  • Juls
    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
    45 pointsBadges:
    report
  • Juls
    I what is your email address? i am working on another project also. i am sorry for the late response.
    45 pointsBadges:
    report
  • Juls
    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
    45 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following