Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Or something....
Word is integrated with our software so it does only one account at a time.

Each tab separated line is formatted like: name address acct# dob amtdue

For each account I have to load up a fresh word document, copy paste the values into an existing excel sheet, and send it on its way.

This is a lot of button pushing for me, any way to automate this? I have made a couple simple macros w/o having to program anything.

I have the following versions of ...stuff

Excel 2002 10.6501.6714 SP3
Word 2002 10.6612.6714 SP3
Visual Basic Editor: VB 6.3 v.9969 VBA Retail 6.4.8869
MS Script Editor 10.0

share|improve this question
your question doesn't make much sense . data doesn't pull anything. I guess you mean you want some macro to grab the contents of a bunch of word documents and paste them into an excel document. I don't know much about macros, but should be possible. – barlop Sep 29 '10 at 19:13
Ya that's what I mean, will edit OP. I type faster than I think. – gpryatel Sep 29 '10 at 19:27

You can adapt something like this. Right now it selects the whole word doc into a new workbook. You could paste into a template workbook, or your existing sheet location instead, and be more selective in word as well, but you get the idea.

Sub paste2excel()
Dim excelObj As Object
Set excelObj = CreateObject("excel.application")
excelObj.Visible = True
End Sub

this works in office 2003 and probably will be fine in your version

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .