Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Solved: Copy data from Excel to Word Document


(!)

vinotech's Avatar
vinotech vinotech is offline
Member with 32 posts.
THREAD STARTER
 
Join Date: Oct 2011
Experience: Intermediate
02-Jun-2012, 06:42 AM #1
Smile Solved: Copy data from Excel to Word Document
Hello Everyone.

I need a help with the VBA macro.

I have one excel file & a word file. I need the data in the excel sheet to copy in to the word document.

This is what i need,

1. When you open the excel file, it has two columns Units & Comments.
2. The data in the Unit column need to replace this "XXXXXXXXXXXXX" in the word document,
3. The data in the Comments column need to replace this "cccccccc" in the word document,
4. once the unit column & comments column data is copied in to the word document. I need the word document to be saved with the file name of "XXXXXXXXXXXXX".

As a end result, i would have each file for each row in the excel file.

Is this possible? Could someone help me with this thing?

Thank you so much for looking in to this,
Attached Files
File Type: docx FILE TEMPLATE.docx (17.1 KB, 41 views)
File Type: xlsx CONTENTS CONVERT WORD.xlsx (8.5 KB, 45 views)

Last edited by vinotech; 02-Jun-2012 at 06:43 AM.. Reason: Missed to attach the file.
Keebellah's Avatar
Keebellah   (Hans) Keebellah is offline Keebellah is a Trusted Advisor with special permissions. Keebellah has a Profile Picture
Computer Specs
Trusted Advisor with 5,186 posts.
 
Join Date: Mar 2008
Location: Oegstgeest, The Netherlands
Experience: Advanced
02-Jun-2012, 03:11 PM #2
There is a post started by n3on some time ago where I helped some.

Maybe you can use the idea.
Keebellah's Avatar
Keebellah   (Hans) Keebellah is offline Keebellah is a Trusted Advisor with special permissions. Keebellah has a Profile Picture
Computer Specs
Trusted Advisor with 5,186 posts.
 
Join Date: Mar 2008
Location: Oegstgeest, The Netherlands
Experience: Advanced
04-Jun-2012, 02:43 AM #3
I'm looking up the macro I wrote for n3on and see if I can implement it.

Do you want to create all files automatically or do you want to be prompted to do so?
I also expect you would like a column that says if it was created and also one with the date it was created?

Last edited by Keebellah; 04-Jun-2012 at 02:46 AM.. Reason: Question
Keebellah's Avatar
Keebellah   (Hans) Keebellah is offline Keebellah is a Trusted Advisor with special permissions. Keebellah has a Profile Picture
Computer Specs
Trusted Advisor with 5,186 posts.
 
Join Date: Mar 2008
Location: Oegstgeest, The Netherlands
Experience: Advanced
04-Jun-2012, 04:09 AM #4
Try this one.
Make sure the Excel and the Word file are in the same folder
Attached Files
File Type: xlsm CONTENTS CONVERT WORD.xlsm (29.4 KB, 56 views)
File Type: docx FILE TEMPLATE.docx (17.1 KB, 45 views)
vinotech's Avatar
vinotech vinotech is offline
Member with 32 posts.
THREAD STARTER
 
Join Date: Oct 2011
Experience: Intermediate
04-Jun-2012, 11:14 AM #5
Thanks for your help Hans. I will take a look now and let you know.
vinotech's Avatar
vinotech vinotech is offline
Member with 32 posts.
THREAD STARTER
 
Join Date: Oct 2011
Experience: Intermediate
04-Jun-2012, 10:33 PM #6
Hans, I took a look at the macro...

I really need to create the files automatically. I dont need them to prompt to do so... The column that says the date created & file created was a good thought...

Can you just help me creating the file automatically instead of prompting for each row...

Thanks a lot for all your efforts with this... Much Helpful..
Keebellah's Avatar
Keebellah   (Hans) Keebellah is offline Keebellah is a Trusted Advisor with special permissions. Keebellah has a Profile Picture
Computer Specs
Trusted Advisor with 5,186 posts.
 
Join Date: Mar 2008
Location: Oegstgeest, The Netherlands
Experience: Advanced
05-Jun-2012, 12:59 AM #7
you should editting macro's

I mailed the solution to your regular mail
Keebellah's Avatar
Keebellah   (Hans) Keebellah is offline Keebellah is a Trusted Advisor with special permissions. Keebellah has a Profile Picture
Computer Specs
Trusted Advisor with 5,186 posts.
 
Join Date: Mar 2008
Location: Oegstgeest, The Netherlands
Experience: Advanced
05-Jun-2012, 03:07 AM #8
Don't forget to mark it solved
vinotech's Avatar
vinotech vinotech is offline
Member with 32 posts.
THREAD STARTER
 
Join Date: Oct 2011
Experience: Intermediate
06-Jun-2012, 11:25 AM #9
Hi Hans,
Thanks a lot for the Great Help... This worked very wel & matches exactly with my requirement.

Thanks a lot again.
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


Tags
excel, word

(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑