I have an excel file with several excel sheets. Each excel sheet contains one or more tables. Below I have exemplified an Excel file with only three sheets.
Now, I would like to generate a MS Word file (.doc) - in fact a template .doc - that contains tables from whole Excel file, together with the data.
Is there any way of doing this using VBA? Please.
Do you mean you want to insert the tables from the workbook in a new Word document?
If posting code please use code tags, see here.
Yes, but I want to do this thing automatically, not using copy-paste.
Something Similar...
Please Login or Register to view this content.
Regards
Parth
I appreciate your feedback. Hit * if u Like.
Rules - http://www.excelforum.com/forum-rule...rum-rules.html
@Parth, thanks for the reply but isn't working, it showing the below error:
"Compile error: user-defined type not defined" ???
This is Just an code for inputting the Sheet "Cat I" in word..
You need to add refernce in excel..
Open Excel
press ALT + F11
Then go to tools
Then click References & select "Microsoft Word 14.0 Object Library" or anything similar to it & then run the code for sheet "Cat I"
I checked the Reference tab options and there is checked (default) five options: Visual Basic for Applications, Microsoft Excel 14.0 Object Library, OLE Automation, Microsoft Word 14.0 Object Library and Microsoft Office 14.0 Object Library.
I make mention that using Excel 2010. Now, after I checked "Microsoft Word 14.0 Object Library", if I try to run the macro, it displays the following error:
Run time error '5174': Application defined or object-defined error
Why? Please.
You should have a Empty Word file in D: drive location as below
D:\Excel2Word.docx
Now run the attached file code in modules & see
Well, I respect your recommendations above but after I run excel macro and I open the Word file, this file is empty (ie, nothing happens). In your case is working?
Yes its working... it doesnt paste it in the file on d drive.. it rather creates a New word file & then saveas it in your folder where your macro file iexists..
please check
Another approach is to 'pull' the data from Excel into Word. Instead of 'pushing' the data from Excel to Word.
What about creating a blank template file or .dotm file in Word. And then copy / link the various charts you want from Excel into Word. You can then update all charts/ranges in the Word document pretty easily.
You want to use a canvas excel in MSWord document and there was inserts tables using links from the original excel file? I tried this thing but isn't updating the information from the doc file, even if excel file is opened.Originally Posted by ptmuldoon
@Parth007,
I tried to run your example, but does not complete the Word file with an Excel file tables !!!! Please, attach files again.
Use this File...
Store this file in any folder & then open it & run the code..
You will see the output word file in the sasme folder..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks