Hi guys

I have some experience with making macros in excel, however never don
it with word. So some guidance would be nice.

What I’m trying to do is... See attached file (picture).

The picture is an example of a reference to a journal. My documen
contains several of these references.

I want to copy the name of the author in word into in column A in
excel spreadsheet, then the source (column B) and then the documen
type (column C).

Then go to the next reference in the document and past all the inf
into the specific columns on a new row in Excel....



I hope my question is understandable,
thanks for all help so far.

+-------------------------------------------------------------------
|Filename: databse-ie.jpg
|Download: http://www.excelforum.com/attachment.php?postid=4252
+-------------------------------------------------------------------

--
Ctec

-----------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...fo&userid=2774
View this thread: http://www.excelforum.com/showthread.php?threadid=50367

Does this mean that there is noone here which knws how to make macros in
Word?


--
Ctech


------------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=503675

Hi Ctech,

the link below leads me to a page,
I don't know what to do with.

|Download: http://www.excelforum.com/attachment.php?postid=4252 |

For WordVBA related questions visit, e.g.:
microsoft.public.word.vba.general

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

Im not sure I understand what the problem is?
Are you trying to tell me that my attachment doesn't work?

The attachement is a screenprint of the word document which Im trying
to pull date from, to excel.

I guess the macro have to be something like this:

Set i = number of "Authors:" in document

For each i in Document

Find "Author".... take text in next cell and copy.
Paste this in excel(row 2, column A)

Find "Source"... take next cell and copy.
Paste this in excel (row 2, column B)

Next i

Hope this helps you guys understand the objective of the macro.

Hi Ctech,

the link below leads me to a page,
I don't know what to do with.

|Download: http://www.excelforum.com/attachment.php?postid=4252 |

For WordVBA related questions visit, e.g.:
microsoft.public.word.vba.general



--
Ctech


------------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=503675

Ctech,

When I selected your link, it took me to a different Excel forum and there
was no screenshot to help me understand how the document is structured.
There are plenty of people here who could advise you on using VBA from Excel
to extract content from a Word document but without knowing details about
that document we would be shooting in the dark.

Steve



"Ctech" wrote in
message ...

Im not sure I understand what the problem is?
Are you trying to tell me that my attachment doesn't work?

The attachement is a screenprint of the word document which Im trying
to pull date from, to excel.

I guess the macro have to be something like this:

Set i = number of "Authors:" in document

For each i in Document

Find "Author".... take text in next cell and copy.
Paste this in excel(row 2, column A)

Find "Source"... take next cell and copy.
Paste this in excel (row 2, column B)

Next i

Hope this helps you guys understand the objective of the macro.

Hi Ctech,

the link below leads me to a page,
I don't know what to do with.

|Download: http://www.excelforum.com/attachment.php?postid=4252 |

For WordVBA related questions visit, e.g.:
microsoft.public.word.vba.general



--
Ctech


------------------------------------------------------------------------
Ctech's Profile:
http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=503675

Im sorry the attached photo in my first post works for me... anyway, I
have now uploaded the picture to another localtion on the net.

http://www.amedisin.no/crissimo/databse-ie.jpg

The picture is a "print screen" from the word document I'm working
with.


I hope this explains it.


--
Ctech


------------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=503675

The link to the jpg works now.

You have a picture of a Word table but there is a comment below the table
that references a pdf file. Is the Word document saved as a file with a doc
extension and available on your hard drive or your network or is it
something created in Word but saved as a PDF file?

Steve


"Ctech" wrote in message
...

Im sorry the attached photo in my first post works for me... anyway, I
have now uploaded the picture to another localtion on the net.

http://www.amedisin.no/crissimo/databse-ie.jpg

The picture is a "print screen" from the word document I'm working
with.


I hope this explains it.


--
Ctech


------------------------------------------------------------------------
Ctech's Profile:
http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=503675

Is there really noone that can help me on this matter?


--
Ctech


------------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=503675