the problem i have is that most of the other people that i need this to work
with do not have access to MS Excel but every body has MS Word (WORK TASK)

I have to make a weekly/monthly workload allocation spreadsheet, which is
very basic i have their names as there tab name a list of tasks and sub
totals. and a final sheet that totals all tabs.

i have everybody email the weekly form to me in word format and i cut and
past special :- text to get excel to calculate figures, there are 17 people i
have to do this for

i have limited security level at work prompted to run macro's

Here is the question
With excel 2000/2003

How can i import there word data and input into the spreadsheet at there tab

Their Name is on the weekly Word Document which relates to their tab name

if someone could ste me on the right road, i manage to bring out the data
from a spreadsheet and put it into word, but i can not get it to work the
otherway round

cant find help with location in the word document?

--
John Hood

The format for importing data into Excel that has the least dependency on
other things is the CSV format. So, unless your source users are given Excel,
see if it possible for them to use NOTEPAD, available on all PCs. If you do
not know anything about CSV, look it up in the Excel help files.

If you have to use Word ...

-Word does not have data types; everything is text.
-In Excel you have workbooks, worksheets, ranges, cells etc; in word you
have documents, paragraphs, sentences, words, tables, bookmarks etc.
-If you like, research DDE; this may work but is tenuous.

Experiment with this:

Open one of the word documents--no other Word sessions exist. I'll assume
that the data you want to import are in tables.

Set WD=GetObject(,"Word.Application")
WD.ActiveDocument.Tables(1).Select

Rows=Selection.Rows.Count
Cols = Selection.Columns.Count

You now have the dimensions of the data in table 1. In orderto get the text,

data = wd.selection.text

As I mentioned, all data in Word is text.

The content of the table, data, contains the contents of the table; reformat
it and use array techniques to send the data to excel.