Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...I always seem to find what I need in previous threads without starting my own. I have started a couple but that's it..."

Geography

Where in the world do Tek-Tips members come from?

macro to get name and address from word document and paste to excel

kepsco (TechnicalUser)
1 Apr 12 22:59
hi experts,

just want to ask if you can suggest how to do a macro (or if you have a sample macro) that will get data in a word document(like a name or an address) and paste it to excel. appreciate your help :)

thanks!
TheFitz (Programmer)
10 May 12 8:34
Hi,

I'm not sure exactly what you are trying to do, however, to me it doesn't quite seem as simple as you are talking.

Do you have fields defined in the word document to hold the name and address or is it just free text. If it's just free text, you have no way of defining the actual name or address length.

Can you expand what you need a little pls.

Thanks

Fitz
Did you know, there are 10 types of people in this world:
* Those who understand binary
  and
* Those who Don't!!

vbajock (Programmer)
14 May 12 14:22
Highlight and choose "Copy"......
SkipVought (Programmer)
14 May 12 15:47
1. what is the structure of data in your Word document?

2. why wouldn't you use either VBA in Word or Excel to code an run this process?

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close