Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file
Dear all excel champs friends Can any one proper guide on this topic means it uis possible or not? Regards Amar On Fri, Apr 11, 2014 at 12:21 PM, amar takale amartak...@gmail.com wrote: Dear Ashish sir Pls help me on this solution. I would appreciate very much Sir Regards Amar Takale On Mon, Apr 7, 2014 at 4:47 PM, amar takale amartak...@gmail.com wrote: Dear Expert team can anyone give me solution on this topic? Regards Amar On Wed, Apr 2, 2014 at 12:59 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder Perfect,You are done it. I am really thankful for its wonderful coding. I have some other query regarding this issue topic (If you have sufficient time regarding my query) Single Excel sheet more than 2 tables 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).there are more than two table with different range.I want all table copy paste in one word file one by one below after one click button. Single Excel sheet one table 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).code not asking for select range. As always Thank you all for your help. I greatly appreciated it. Regards Amar On Wed, Apr 2, 2014 at 12:31 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Try this file -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 12:22 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Actually it show like Missing: Microsoft Word 14.0 Object Library Attached screen shot here Regards Amar On Wed, Apr 2, 2014 at 12:09 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Press alt + F11 then go in tools then reference select Microsoft Word 14.0 Object Library library number can b 12.0 or else. Please see attached excel file. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 10:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Thanks for reply but how to do it.Pls give me guidance or give modified code. Regards Amar On Tue, Apr 1, 2014 at 9:31 PM, ravinder negi ravindervbacli...@gmail.com wrote: have u added the library word object library in vba On Mon, Mar 31, 2014 at 10:02 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder VBA Code not working.Attached Error Screen shot here.Pls see guide me.I have no knowledge of VBA. In excel there are no show Microsoft Word library in Tools-reference option but show it as Microsoft Word 11.0 Object library Pls look in this issue. Regards Amar On Mon, Mar 31, 2014 at 5:39 PM, Ravinder ravindervbacli...@gmail.com wrote: Note:- add word library Microsoft Word library This is simply copy and paste value from excel to word and you need to select range (will be asked by program) which you want to transfer in word Sub Button1_Click() Dim wrd As New Word.Application Dim doc As Word.Document Dim RNG As Range Set RNG = Application.InputBox(Please Select Range to Transfer in Word:, Type:=8) Set doc = wrd.documents.Add wrd.Visible = True 'if you dont want to show wrd application then just use false instead of true RNG.Copy wrd.Selection.Paste Set tbl = doc.Tables(1) doc.SaveAs2 ThisWorkbook.Path \ ActiveSheet.Name .doc 'change save as path as per ur requirement End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, March 31, 2014 3:35 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ashish Sir, I learned many VBA work from your Code which is a lot of time saving easy to do. Before one week on our excel forum one topic discussed as (Macro to Import Word Tables to Excel from a folder). I got code from word to excel but I required excel to word.I use excel 2003. Can you share code excel to word table as proper in one sheet with respective sheet name. I would appreciate very much if you can help me on this. Regards -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking
RE: $$Excel-Macros$$ VBA Code to Import Excel table in Word file
Visit on the below link and check if you are asking for the same http://excelvbasupport.com/forum/showthread.php?tid=22 Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 3:00 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear all excel champs friends Can any one proper guide on this topic means it uis possible or not? Regards Amar On Fri, Apr 11, 2014 at 12:21 PM, amar takale amartak...@gmail.com wrote: Dear Ashish sir Pls help me on this solution. I would appreciate very much Sir Regards Amar Takale On Mon, Apr 7, 2014 at 4:47 PM, amar takale amartak...@gmail.com wrote: Dear Expert team can anyone give me solution on this topic? Regards Amar On Wed, Apr 2, 2014 at 12:59 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder Perfect,You are done it. I am really thankful for its wonderful coding. I have some other query regarding this issue topic (If you have sufficient time regarding my query) Single Excel sheet more than 2 tables 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).there are more than two table with different range.I want all table copy paste in one word file one by one below after one click button. Single Excel sheet one table 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).code not asking for select range. As always Thank you all for your help. I greatly appreciated it. Regards Amar On Wed, Apr 2, 2014 at 12:31 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Try this file -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 12:22 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Actually it show like Missing: Microsoft Word 14.0 Object Library Attached screen shot here Regards Amar On Wed, Apr 2, 2014 at 12:09 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Press alt + F11 then go in tools then reference select Microsoft Word 14.0 Object Library library number can b 12.0 or else. Please see attached excel file. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 10:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Thanks for reply but how to do it.Pls give me guidance or give modified code. Regards Amar On Tue, Apr 1, 2014 at 9:31 PM, ravinder negi ravindervbacli...@gmail.com wrote: have u added the library word object library in vba On Mon, Mar 31, 2014 at 10:02 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder VBA Code not working.Attached Error Screen shot here.Pls see guide me.I have no knowledge of VBA. In excel there are no show Microsoft Word library in Tools-reference option but show it as Microsoft Word 11.0 Object library Pls look in this issue. Regards Amar On Mon, Mar 31, 2014 at 5:39 PM, Ravinder ravindervbacli...@gmail.com wrote: Note:- add word library Microsoft Word library This is simply copy and paste value from excel to word and you need to select range (will be asked by program) which you want to transfer in word Sub Button1_Click() Dim wrd As New Word.Application Dim doc As Word.Document Dim RNG As Range Set RNG = Application.InputBox(Please Select Range to Transfer in Word:, Type:=8) Set doc = wrd.documents.Add wrd.Visible = True 'if you dont want to show wrd application then just use false instead of true RNG.Copy wrd.Selection.Paste Set tbl = doc.Tables(1) doc.SaveAs2 ThisWorkbook.Path \ ActiveSheet.Name .doc 'change save as path as per ur requirement End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, March 31, 2014 3:35 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ashish Sir, I learned many VBA work from your Code which is a lot of time saving easy to do. Before one week on our excel forum one topic discussed as (Macro to Import Word Tables to Excel from a folder). I got code from word to excel but I required excel to word.I use excel 2003. Can you share code excel to word table as proper in one sheet with respective sheet name. I would appreciate very much if you can help me on this. Regards -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
RE: $$Excel-Macros$$ VBA Code to Import Excel table in Word file
Hi Amar, PFB link for your solution, now you can add whatever the table in excel and copy paste in word one by one,, pls revert if you are looking something else. On this... http://excelvbasupport.com/forum/showthread.php?tid=23 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ravi Kumar Sent: Monday, April 28, 2014 3:20 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Visit on the below link and check if you are asking for the same http://excelvbasupport.com/forum/showthread.php?tid=22 Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 3:00 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear all excel champs friends Can any one proper guide on this topic means it uis possible or not? Regards Amar On Fri, Apr 11, 2014 at 12:21 PM, amar takale amartak...@gmail.com wrote: Dear Ashish sir Pls help me on this solution. I would appreciate very much Sir Regards Amar Takale On Mon, Apr 7, 2014 at 4:47 PM, amar takale amartak...@gmail.com wrote: Dear Expert team can anyone give me solution on this topic? Regards Amar On Wed, Apr 2, 2014 at 12:59 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder Perfect,You are done it. I am really thankful for its wonderful coding. I have some other query regarding this issue topic (If you have sufficient time regarding my query) Single Excel sheet more than 2 tables 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).there are more than two table with different range.I want all table copy paste in one word file one by one below after one click button. Single Excel sheet one table 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).code not asking for select range. As always Thank you all for your help. I greatly appreciated it. Regards Amar On Wed, Apr 2, 2014 at 12:31 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Try this file -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 12:22 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Actually it show like Missing: Microsoft Word 14.0 Object Library Attached screen shot here Regards Amar On Wed, Apr 2, 2014 at 12:09 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Press alt + F11 then go in tools then reference select Microsoft Word 14.0 Object Library library number can b 12.0 or else. Please see attached excel file. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 10:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Thanks for reply but how to do it.Pls give me guidance or give modified code. Regards Amar On Tue, Apr 1, 2014 at 9:31 PM, ravinder negi ravindervbacli...@gmail.com wrote: have u added the library word object library in vba On Mon, Mar 31, 2014 at 10:02 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder VBA Code not working.Attached Error Screen shot here.Pls see guide me.I have no knowledge of VBA. In excel there are no show Microsoft Word library in Tools-reference option but show it as Microsoft Word 11.0 Object library Pls look in this issue. Regards Amar On Mon, Mar 31, 2014 at 5:39 PM, Ravinder ravindervbacli...@gmail.com wrote: Note:- add word library Microsoft Word library This is simply copy and paste value from excel to word and you need to select range (will be asked by program) which you want to transfer in word Sub Button1_Click() Dim wrd As New Word.Application Dim doc As Word.Document Dim RNG As Range Set RNG = Application.InputBox(Please Select Range to Transfer in Word:, Type:=8) Set doc = wrd.documents.Add wrd.Visible = True 'if you dont want to show wrd application then just use false instead of true RNG.Copy wrd.Selection.Paste Set tbl = doc.Tables(1) doc.SaveAs2 ThisWorkbook.Path \ ActiveSheet.Name .doc 'change save as path as per ur requirement End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, March 31, 2014 3:35 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ashish Sir, I learned many VBA
RE: $$Excel-Macros$$ VBA Code to Import Excel table in Word file
No need to do anything just comment the two lines 'Dim wrdapps As Word.Application 'Dim wrddoc As Word.Document It would work Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 3:34 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravi I found example file in above link forum but there are error show cant find project or library.PFA both file.Pls see it Regards Amar On Mon, Apr 28, 2014 at 3:19 PM, Ravi Kumar excellearn2...@gmail.com wrote: Visit on the below link and check if you are asking for the same http://excelvbasupport.com/forum/showthread.php?tid=22 Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 3:00 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear all excel champs friends Can any one proper guide on this topic means it uis possible or not? Regards Amar On Fri, Apr 11, 2014 at 12:21 PM, amar takale amartak...@gmail.com wrote: Dear Ashish sir Pls help me on this solution. I would appreciate very much Sir Regards Amar Takale On Mon, Apr 7, 2014 at 4:47 PM, amar takale amartak...@gmail.com wrote: Dear Expert team can anyone give me solution on this topic? Regards Amar On Wed, Apr 2, 2014 at 12:59 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder Perfect,You are done it. I am really thankful for its wonderful coding. I have some other query regarding this issue topic (If you have sufficient time regarding my query) Single Excel sheet more than 2 tables 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).there are more than two table with different range.I want all table copy paste in one word file one by one below after one click button. Single Excel sheet one table 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).code not asking for select range. As always Thank you all for your help. I greatly appreciated it. Regards Amar On Wed, Apr 2, 2014 at 12:31 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Try this file -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 12:22 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Actually it show like Missing: Microsoft Word 14.0 Object Library Attached screen shot here Regards Amar On Wed, Apr 2, 2014 at 12:09 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Press alt + F11 then go in tools then reference select Microsoft Word 14.0 Object Library library number can b 12.0 or else. Please see attached excel file. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 10:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Thanks for reply but how to do it.Pls give me guidance or give modified code. Regards Amar On Tue, Apr 1, 2014 at 9:31 PM, ravinder negi ravindervbacli...@gmail.com wrote: have u added the library word object library in vba On Mon, Mar 31, 2014 at 10:02 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder VBA Code not working.Attached Error Screen shot here.Pls see guide me.I have no knowledge of VBA. In excel there are no show Microsoft Word library in Tools-reference option but show it as Microsoft Word 11.0 Object library Pls look in this issue. Regards Amar On Mon, Mar 31, 2014 at 5:39 PM, Ravinder ravindervbacli...@gmail.com wrote: Note:- add word library Microsoft Word library This is simply copy and paste value from excel to word and you need to select range (will be asked by program) which you want to transfer in word Sub Button1_Click() Dim wrd As New Word.Application Dim doc As Word.Document Dim RNG As Range Set RNG = Application.InputBox(Please Select Range to Transfer in Word:, Type:=8) Set doc = wrd.documents.Add wrd.Visible = True 'if you dont want to show wrd application then just use false instead of true RNG.Copy wrd.Selection.Paste Set tbl = doc.Tables(1) doc.SaveAs2 ThisWorkbook.Path \ ActiveSheet.Name .doc 'change save as path as per ur requirement End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, March 31
Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file
Dear Ravi Sheet not work with modified code Pls send me excel sheet with this modified code. (In references show Missing: Microsoft Word 14.0 Object Library) Regards amar On Mon, Apr 28, 2014 at 3:40 PM, Ravi Kumar excellearn2...@gmail.com wrote: No need to do anything just comment the two lines 'Dim wrdapps As Word.Application 'Dim wrddoc As Word.Document It would work Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 3:34 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravi I found example file in above link forum but there are error show cant find project or library.PFA both file.Pls see it Regards Amar On Mon, Apr 28, 2014 at 3:19 PM, Ravi Kumar excellearn2...@gmail.com wrote: Visit on the below link and check if you are asking for the same http://excelvbasupport.com/forum/showthread.php?tid=22 Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 3:00 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear all excel champs friends Can any one proper guide on this topic means it uis possible or not? Regards Amar On Fri, Apr 11, 2014 at 12:21 PM, amar takale amartak...@gmail.com wrote: Dear Ashish sir Pls help me on this solution. I would appreciate very much Sir Regards Amar Takale On Mon, Apr 7, 2014 at 4:47 PM, amar takale amartak...@gmail.com wrote: Dear Expert team can anyone give me solution on this topic? Regards Amar On Wed, Apr 2, 2014 at 12:59 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder Perfect,You are done it. I am really thankful for its wonderful coding. I have some other query regarding this issue topic (If you have sufficient time regarding my query) Single Excel sheet more than 2 tables 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).there are more than two table with different range.I want all table copy paste in one word file one by one below after one click button. Single Excel sheet one table 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).code not asking for select range. As always Thank you all for your help. I greatly appreciated it. Regards Amar On Wed, Apr 2, 2014 at 12:31 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Try this file -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 12:22 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Actually it show like Missing: Microsoft Word 14.0 Object Library Attached screen shot here Regards Amar On Wed, Apr 2, 2014 at 12:09 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Press alt + F11 then go in tools then reference select Microsoft Word 14.0 Object Library library number can b 12.0 or else. Please see attached excel file. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 10:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Thanks for reply but how to do it.Pls give me guidance or give modified code. Regards Amar On Tue, Apr 1, 2014 at 9:31 PM, ravinder negi ravindervbacli...@gmail.com wrote: have u added the library word object library in vba On Mon, Mar 31, 2014 at 10:02 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder VBA Code not working.Attached Error Screen shot here.Pls see guide me.I have no knowledge of VBA. In excel there are no show Microsoft Word library in Tools-reference option but show it as Microsoft Word 11.0 Object library Pls look in this issue. Regards Amar On Mon, Mar 31, 2014 at 5:39 PM, Ravinder ravindervbacli...@gmail.com wrote: Note:- add word library Microsoft Word library This is simply copy and paste value from excel to word and you need to select range (will be asked by program) which you want to transfer in word Sub Button1_Click() Dim wrd As New Word.Application Dim doc As Word.Document Dim RNG As Range Set RNG = Application.InputBox(Please Select Range to Transfer in Word:, Type:=8) Set doc = wrd.documents.Add wrd.Visible = True 'if you dont want to show wrd application then just use false instead of true RNG.Copy wrd.Selection.Paste Set tbl = doc.Tables(1) doc.SaveAs2 ThisWorkbook.Path
RE: $$Excel-Macros$$ VBA Code to Import Excel table in Word file
Ok check the below link http://excelvbasupport.com/forum/showthread.php?tid=23 Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 4:02 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravi Sheet not work with modified code Pls send me excel sheet with this modified code. (In references show Missing: Microsoft Word 14.0 Object Library) Regards amar On Mon, Apr 28, 2014 at 3:40 PM, Ravi Kumar excellearn2...@gmail.com wrote: No need to do anything just comment the two lines 'Dim wrdapps As Word.Application 'Dim wrddoc As Word.Document It would work Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 3:34 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravi I found example file in above link forum but there are error show cant find project or library.PFA both file.Pls see it Regards Amar On Mon, Apr 28, 2014 at 3:19 PM, Ravi Kumar excellearn2...@gmail.com wrote: Visit on the below link and check if you are asking for the same http://excelvbasupport.com/forum/showthread.php?tid=22 Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 3:00 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear all excel champs friends Can any one proper guide on this topic means it uis possible or not? Regards Amar On Fri, Apr 11, 2014 at 12:21 PM, amar takale amartak...@gmail.com wrote: Dear Ashish sir Pls help me on this solution. I would appreciate very much Sir Regards Amar Takale On Mon, Apr 7, 2014 at 4:47 PM, amar takale amartak...@gmail.com wrote: Dear Expert team can anyone give me solution on this topic? Regards Amar On Wed, Apr 2, 2014 at 12:59 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder Perfect,You are done it. I am really thankful for its wonderful coding. I have some other query regarding this issue topic (If you have sufficient time regarding my query) Single Excel sheet more than 2 tables 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).there are more than two table with different range.I want all table copy paste in one word file one by one below after one click button. Single Excel sheet one table 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).code not asking for select range. As always Thank you all for your help. I greatly appreciated it. Regards Amar On Wed, Apr 2, 2014 at 12:31 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Try this file -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 12:22 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Actually it show like Missing: Microsoft Word 14.0 Object Library Attached screen shot here Regards Amar On Wed, Apr 2, 2014 at 12:09 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Press alt + F11 then go in tools then reference select Microsoft Word 14.0 Object Library library number can b 12.0 or else. Please see attached excel file. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 10:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Thanks for reply but how to do it.Pls give me guidance or give modified code. Regards Amar On Tue, Apr 1, 2014 at 9:31 PM, ravinder negi ravindervbacli...@gmail.com wrote: have u added the library word object library in vba On Mon, Mar 31, 2014 at 10:02 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder VBA Code not working.Attached Error Screen shot here.Pls see guide me.I have no knowledge of VBA. In excel there are no show Microsoft Word library in Tools-reference option but show it as Microsoft Word 11.0 Object library Pls look in this issue. Regards Amar On Mon, Mar 31, 2014 at 5:39 PM, Ravinder ravindervbacli...@gmail.com wrote: Note:- add word library Microsoft Word library This is simply copy and paste value from excel to word and you need to select range (will be asked by program) which you want to transfer in word Sub
Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file
Same error show cant find project or library On Mon, Apr 28, 2014 at 4:10 PM, Ravi Kumar excellearn2...@gmail.com wrote: Ok check the below link http://excelvbasupport.com/forum/showthread.php?tid=23 Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 4:02 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravi Sheet not work with modified code Pls send me excel sheet with this modified code. (In references show Missing: Microsoft Word 14.0 Object Library) Regards amar On Mon, Apr 28, 2014 at 3:40 PM, Ravi Kumar excellearn2...@gmail.com wrote: No need to do anything just comment the two lines 'Dim wrdapps As Word.Application 'Dim wrddoc As Word.Document It would work Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 3:34 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravi I found example file in above link forum but there are error show cant find project or library.PFA both file.Pls see it Regards Amar On Mon, Apr 28, 2014 at 3:19 PM, Ravi Kumar excellearn2...@gmail.com wrote: Visit on the below link and check if you are asking for the same http://excelvbasupport.com/forum/showthread.php?tid=22 Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 3:00 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear all excel champs friends Can any one proper guide on this topic means it uis possible or not? Regards Amar On Fri, Apr 11, 2014 at 12:21 PM, amar takale amartak...@gmail.com wrote: Dear Ashish sir Pls help me on this solution. I would appreciate very much Sir Regards Amar Takale On Mon, Apr 7, 2014 at 4:47 PM, amar takale amartak...@gmail.com wrote: Dear Expert team can anyone give me solution on this topic? Regards Amar On Wed, Apr 2, 2014 at 12:59 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder Perfect,You are done it. I am really thankful for its wonderful coding. I have some other query regarding this issue topic (If you have sufficient time regarding my query) Single Excel sheet more than 2 tables 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).there are more than two table with different range.I want all table copy paste in one word file one by one below after one click button. Single Excel sheet one table 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).code not asking for select range. As always Thank you all for your help. I greatly appreciated it. Regards Amar On Wed, Apr 2, 2014 at 12:31 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Try this file -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 12:22 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Actually it show like Missing: Microsoft Word 14.0 Object Library Attached screen shot here Regards Amar On Wed, Apr 2, 2014 at 12:09 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Press alt + F11 then go in tools then reference select Microsoft Word 14.0 Object Library library number can b 12.0 or else. Please see attached excel file. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 10:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Thanks for reply but how to do it.Pls give me guidance or give modified code. Regards Amar On Tue, Apr 1, 2014 at 9:31 PM, ravinder negi ravindervbacli...@gmail.com wrote: have u added the library word object library in vba On Mon, Mar 31, 2014 at 10:02 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder VBA Code not working.Attached Error Screen shot here.Pls see guide me.I have no knowledge of VBA. In excel there are no show Microsoft Word library in Tools-reference option but show it as Microsoft Word 11.0 Object library Pls look in this issue. Regards Amar On Mon, Mar 31, 2014 at 5:39 PM, Ravinder ravindervbacli...@gmail.com wrote: Note:- add word library Microsoft Word library This is simply copy and paste value from
RE: $$Excel-Macros$$ VBA Code to Import Excel table in Word file
Try this Sub Button1_Click() Dim wb As Workbook Dim ws As Worksheet Dim tbl As ListObject Dim wrd As Object Dim doc As Object Dim sel As Object Set wb = ThisWorkbook Set ws = wb.Sheets(1) Set wrd = CreateObject(word.application) wrd.Visible = True Set doc = wrd.Documents.Add For Each tbl In ws.ListObjects tbl.Range.Copy wrd.Selection.Paste wrd.Selection.TypeParagraph Next Application.CutCopyMode = xlCopy MsgBox Done End Sub Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 4:15 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Same error show cant find project or library On Mon, Apr 28, 2014 at 4:10 PM, Ravi Kumar excellearn2...@gmail.com wrote: Ok check the below link http://excelvbasupport.com/forum/showthread.php?tid=23 Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 4:02 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravi Sheet not work with modified code Pls send me excel sheet with this modified code. (In references show Missing: Microsoft Word 14.0 Object Library) Regards amar On Mon, Apr 28, 2014 at 3:40 PM, Ravi Kumar excellearn2...@gmail.com wrote: No need to do anything just comment the two lines 'Dim wrdapps As Word.Application 'Dim wrddoc As Word.Document It would work Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 3:34 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravi I found example file in above link forum but there are error show cant find project or library.PFA both file.Pls see it Regards Amar On Mon, Apr 28, 2014 at 3:19 PM, Ravi Kumar excellearn2...@gmail.com wrote: Visit on the below link and check if you are asking for the same http://excelvbasupport.com/forum/showthread.php?tid=22 Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 3:00 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear all excel champs friends Can any one proper guide on this topic means it uis possible or not? Regards Amar On Fri, Apr 11, 2014 at 12:21 PM, amar takale amartak...@gmail.com wrote: Dear Ashish sir Pls help me on this solution. I would appreciate very much Sir Regards Amar Takale On Mon, Apr 7, 2014 at 4:47 PM, amar takale amartak...@gmail.com wrote: Dear Expert team can anyone give me solution on this topic? Regards Amar On Wed, Apr 2, 2014 at 12:59 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder Perfect,You are done it. I am really thankful for its wonderful coding. I have some other query regarding this issue topic (If you have sufficient time regarding my query) Single Excel sheet more than 2 tables 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).there are more than two table with different range.I want all table copy paste in one word file one by one below after one click button. Single Excel sheet one table 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).code not asking for select range. As always Thank you all for your help. I greatly appreciated it. Regards Amar On Wed, Apr 2, 2014 at 12:31 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Try this file -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 12:22 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Actually it show like Missing: Microsoft Word 14.0 Object Library Attached screen shot here Regards Amar On Wed, Apr 2, 2014 at 12:09 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Press alt + F11 then go in tools then reference select Microsoft Word 14.0 Object Library library number can b 12.0 or else. Please see attached excel file. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 10:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Thanks for reply but how
Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file
Dear ravi ,Can you Pls send me sample excel On Mon, Apr 28, 2014 at 4:24 PM, Ravi Kumar excellearn2...@gmail.com wrote: Try this Sub Button1_Click() Dim wb As Workbook Dim ws As Worksheet Dim tbl As ListObject Dim wrd As Object Dim doc As Object Dim sel As Object Set wb = ThisWorkbook Set ws = wb.Sheets(1) Set wrd = CreateObject(word.application) wrd.Visible = True Set doc = wrd.Documents.Add For Each tbl In ws.ListObjects tbl.Range.Copy wrd.Selection.Paste wrd.Selection.TypeParagraph Next Application.CutCopyMode = xlCopy MsgBox Done End Sub Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 4:15 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Same error show cant find project or library On Mon, Apr 28, 2014 at 4:10 PM, Ravi Kumar excellearn2...@gmail.com wrote: Ok check the below link http://excelvbasupport.com/forum/showthread.php?tid=23 Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 4:02 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravi Sheet not work with modified code Pls send me excel sheet with this modified code. (In references show Missing: Microsoft Word 14.0 Object Library) Regards amar On Mon, Apr 28, 2014 at 3:40 PM, Ravi Kumar excellearn2...@gmail.com wrote: No need to do anything just comment the two lines 'Dim wrdapps As Word.Application 'Dim wrddoc As Word.Document It would work Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 3:34 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravi I found example file in above link forum but there are error show cant find project or library.PFA both file.Pls see it Regards Amar On Mon, Apr 28, 2014 at 3:19 PM, Ravi Kumar excellearn2...@gmail.com wrote: Visit on the below link and check if you are asking for the same http://excelvbasupport.com/forum/showthread.php?tid=22 Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 3:00 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear all excel champs friends Can any one proper guide on this topic means it uis possible or not? Regards Amar On Fri, Apr 11, 2014 at 12:21 PM, amar takale amartak...@gmail.com wrote: Dear Ashish sir Pls help me on this solution. I would appreciate very much Sir Regards Amar Takale On Mon, Apr 7, 2014 at 4:47 PM, amar takale amartak...@gmail.com wrote: Dear Expert team can anyone give me solution on this topic? Regards Amar On Wed, Apr 2, 2014 at 12:59 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder Perfect,You are done it. I am really thankful for its wonderful coding. I have some other query regarding this issue topic (If you have sufficient time regarding my query) Single Excel sheet more than 2 tables 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).there are more than two table with different range.I want all table copy paste in one word file one by one below after one click button. Single Excel sheet one table 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).code not asking for select range. As always Thank you all for your help. I greatly appreciated it. Regards Amar On Wed, Apr 2, 2014 at 12:31 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Try this file -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 12:22 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Actually it show like Missing: Microsoft Word 14.0 Object Library Attached screen shot here Regards Amar On Wed, Apr 2, 2014 at 12:09 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Press alt + F11 then go in tools then reference select Microsoft Word 14.0 Object Library library number can b 12.0 or else. Please see attached excel file. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 10:50 AM To: excel
Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file
OK On Mon, Apr 28, 2014 at 4:55 PM, Ravi Kumar excellearn2...@gmail.com wrote: Ok PFA... You can also post your queries in below link by click on New Thread http://excelvbasupport.com/forum/forumdisplay.php?fid=6 Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 4:48 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear ravi ,Can you Pls send me sample excel On Mon, Apr 28, 2014 at 4:24 PM, Ravi Kumar excellearn2...@gmail.com wrote: Try this Sub Button1_Click() Dim wb As Workbook Dim ws As Worksheet Dim tbl As ListObject Dim wrd As Object Dim doc As Object Dim sel As Object Set wb = ThisWorkbook Set ws = wb.Sheets(1) Set wrd = CreateObject(word.application) wrd.Visible = True Set doc = wrd.Documents.Add For Each tbl In ws.ListObjects tbl.Range.Copy wrd.Selection.Paste wrd.Selection.TypeParagraph Next Application.CutCopyMode = xlCopy MsgBox Done End Sub Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 4:15 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Same error show cant find project or library On Mon, Apr 28, 2014 at 4:10 PM, Ravi Kumar excellearn2...@gmail.com wrote: Ok check the below link http://excelvbasupport.com/forum/showthread.php?tid=23 Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 4:02 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravi Sheet not work with modified code Pls send me excel sheet with this modified code. (In references show Missing: Microsoft Word 14.0 Object Library) Regards amar On Mon, Apr 28, 2014 at 3:40 PM, Ravi Kumar excellearn2...@gmail.com wrote: No need to do anything just comment the two lines 'Dim wrdapps As Word.Application 'Dim wrddoc As Word.Document It would work Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 3:34 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravi I found example file in above link forum but there are error show cant find project or library.PFA both file.Pls see it Regards Amar On Mon, Apr 28, 2014 at 3:19 PM, Ravi Kumar excellearn2...@gmail.com wrote: Visit on the below link and check if you are asking for the same http://excelvbasupport.com/forum/showthread.php?tid=22 Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 3:00 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear all excel champs friends Can any one proper guide on this topic means it uis possible or not? Regards Amar On Fri, Apr 11, 2014 at 12:21 PM, amar takale amartak...@gmail.com wrote: Dear Ashish sir Pls help me on this solution. I would appreciate very much Sir Regards Amar Takale On Mon, Apr 7, 2014 at 4:47 PM, amar takale amartak...@gmail.com wrote: Dear Expert team can anyone give me solution on this topic? Regards Amar On Wed, Apr 2, 2014 at 12:59 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder Perfect,You are done it. I am really thankful for its wonderful coding. I have some other query regarding this issue topic (If you have sufficient time regarding my query) Single Excel sheet more than 2 tables 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).there are more than two table with different range.I want all table copy paste in one word file one by one below after one click button. Single Excel sheet one table 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).code not asking for select range. As always Thank you all for your help. I greatly appreciated it. Regards Amar On Wed, Apr 2, 2014 at 12:31 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Try this file -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 12:22 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder
Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file
Dear Ashish sir Pls help me on this solution. I would appreciate very much Sir Regards Amar Takale On Mon, Apr 7, 2014 at 4:47 PM, amar takale amartak...@gmail.com wrote: Dear Expert team can anyone give me solution on this topic? Regards Amar On Wed, Apr 2, 2014 at 12:59 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder Perfect,You are done it. I am really thankful for its wonderful coding. I have some other query regarding this issue topic (If you have sufficient time regarding my query) Single Excel sheet more than 2 tables 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).there are more than two table with different range.I want all table copy paste in one word file one by one below after one click button. Single Excel sheet one table 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).code not asking for select range. As always Thank you all for your help. I greatly appreciated it. Regards Amar On Wed, Apr 2, 2014 at 12:31 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Try this file -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 12:22 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Actually it show like Missing: Microsoft Word 14.0 Object Library Attached screen shot here Regards Amar On Wed, Apr 2, 2014 at 12:09 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Press alt + F11 then go in tools then reference select Microsoft Word 14.0 Object Library library number can b 12.0 or else. Please see attached excel file. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 10:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Thanks for reply but how to do it.Pls give me guidance or give modified code. Regards Amar On Tue, Apr 1, 2014 at 9:31 PM, ravinder negi ravindervbacli...@gmail.com wrote: have u added the library word object library in vba On Mon, Mar 31, 2014 at 10:02 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder VBA Code not working.Attached Error Screen shot here.Pls see guide me.I have no knowledge of VBA. In excel there are no show Microsoft Word library in Tools-reference option but show it as Microsoft Word 11.0 Object library Pls look in this issue. Regards Amar On Mon, Mar 31, 2014 at 5:39 PM, Ravinder ravindervbacli...@gmail.com wrote: Note:- add word library Microsoft Word library This is simply copy and paste value from excel to word and you need to select range (will be asked by program) which you want to transfer in word Sub Button1_Click() Dim wrd As New Word.Application Dim doc As Word.Document Dim RNG As Range Set RNG = Application.InputBox(Please Select Range to Transfer in Word:, Type:=8) Set doc = wrd.documents.Add wrd.Visible = True 'if you dont want to show wrd application then just use false instead of true RNG.Copy wrd.Selection.Paste Set tbl = doc.Tables(1) doc.SaveAs2 ThisWorkbook.Path \ ActiveSheet.Name .doc 'change save as path as per ur requirement End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, March 31, 2014 3:35 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ashish Sir, I learned many VBA work from your Code which is a lot of time saving easy to do. Before one week on our excel forum one topic discussed as (Macro to Import Word Tables to Excel from a folder). I got code from word to excel but I required excel to word.I use excel 2003. Can you share code excel to word table as proper in one sheet with respective sheet name. I would appreciate very much if you can help me on this. Regards -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE
Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file
Dear Expert team can anyone give me solution on this topic? Regards Amar On Wed, Apr 2, 2014 at 12:59 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder Perfect,You are done it. I am really thankful for its wonderful coding. I have some other query regarding this issue topic (If you have sufficient time regarding my query) Single Excel sheet more than 2 tables 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).there are more than two table with different range.I want all table copy paste in one word file one by one below after one click button. Single Excel sheet one table 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).code not asking for select range. As always Thank you all for your help. I greatly appreciated it. Regards Amar On Wed, Apr 2, 2014 at 12:31 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Try this file -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 12:22 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Actually it show like Missing: Microsoft Word 14.0 Object Library Attached screen shot here Regards Amar On Wed, Apr 2, 2014 at 12:09 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Press alt + F11 then go in tools then reference select Microsoft Word 14.0 Object Library library number can b 12.0 or else. Please see attached excel file. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 10:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Thanks for reply but how to do it.Pls give me guidance or give modified code. Regards Amar On Tue, Apr 1, 2014 at 9:31 PM, ravinder negi ravindervbacli...@gmail.com wrote: have u added the library word object library in vba On Mon, Mar 31, 2014 at 10:02 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder VBA Code not working.Attached Error Screen shot here.Pls see guide me.I have no knowledge of VBA. In excel there are no show Microsoft Word library in Tools-reference option but show it as Microsoft Word 11.0 Object library Pls look in this issue. Regards Amar On Mon, Mar 31, 2014 at 5:39 PM, Ravinder ravindervbacli...@gmail.com wrote: Note:- add word library Microsoft Word library This is simply copy and paste value from excel to word and you need to select range (will be asked by program) which you want to transfer in word Sub Button1_Click() Dim wrd As New Word.Application Dim doc As Word.Document Dim RNG As Range Set RNG = Application.InputBox(Please Select Range to Transfer in Word:, Type:=8) Set doc = wrd.documents.Add wrd.Visible = True 'if you dont want to show wrd application then just use false instead of true RNG.Copy wrd.Selection.Paste Set tbl = doc.Tables(1) doc.SaveAs2 ThisWorkbook.Path \ ActiveSheet.Name .doc 'change save as path as per ur requirement End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, March 31, 2014 3:35 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ashish Sir, I learned many VBA work from your Code which is a lot of time saving easy to do. Before one week on our excel forum one topic discussed as (Macro to Import Word Tables to Excel from a folder). I got code from word to excel but I required excel to word.I use excel 2003. Can you share code excel to word table as proper in one sheet with respective sheet name. I would appreciate very much if you can help me on this. Regards -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed
RE: $$Excel-Macros$$ VBA Code to Import Excel table in Word file
Try this file -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 12:22 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Actually it show like Missing: Microsoft Word 14.0 Object Library Attached screen shot here Regards Amar On Wed, Apr 2, 2014 at 12:09 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Press alt + F11 then go in tools then reference select Microsoft Word 14.0 Object Library library number can b 12.0 or else. Please see attached excel file. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 10:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Thanks for reply but how to do it.Pls give me guidance or give modified code. Regards Amar On Tue, Apr 1, 2014 at 9:31 PM, ravinder negi ravindervbacli...@gmail.com wrote: have u added the library word object library in vba On Mon, Mar 31, 2014 at 10:02 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder VBA Code not working.Attached Error Screen shot here.Pls see guide me.I have no knowledge of VBA. In excel there are no show Microsoft Word library in Tools-reference option but show it as Microsoft Word 11.0 Object library Pls look in this issue. Regards Amar On Mon, Mar 31, 2014 at 5:39 PM, Ravinder ravindervbacli...@gmail.com wrote: Note:- add word library Microsoft Word library This is simply copy and paste value from excel to word and you need to select range (will be asked by program) which you want to transfer in word Sub Button1_Click() Dim wrd As New Word.Application Dim doc As Word.Document Dim RNG As Range Set RNG = Application.InputBox(Please Select Range to Transfer in Word:, Type:=8) Set doc = wrd.documents.Add wrd.Visible = True 'if you dont want to show wrd application then just use false instead of true RNG.Copy wrd.Selection.Paste Set tbl = doc.Tables(1) doc.SaveAs2 ThisWorkbook.Path \ ActiveSheet.Name .doc 'change save as path as per ur requirement End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, March 31, 2014 3:35 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ashish Sir, I learned many VBA work from your Code which is a lot of time saving easy to do. Before one week on our excel forum one topic discussed as (Macro to Import Word Tables to Excel from a folder). I got code from word to excel but I required excel to word.I use excel 2003. Can you share code excel to word table as proper in one sheet with respective sheet name. I would appreciate very much if you can help me on this. Regards -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge
Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file
Dear Ravinder Perfect,You are done it. I am really thankful for its wonderful coding. I have some other query regarding this issue topic (If you have sufficient time regarding my query) Single Excel sheet more than 2 tables 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).there are more than two table with different range.I want all table copy paste in one word file one by one below after one click button. Single Excel sheet one table 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).code not asking for select range. As always Thank you all for your help. I greatly appreciated it. Regards Amar On Wed, Apr 2, 2014 at 12:31 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Try this file -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 12:22 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Actually it show like Missing: Microsoft Word 14.0 Object Library Attached screen shot here Regards Amar On Wed, Apr 2, 2014 at 12:09 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Press alt + F11 then go in tools then reference select Microsoft Word 14.0 Object Library library number can b 12.0 or else. Please see attached excel file. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 10:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Thanks for reply but how to do it.Pls give me guidance or give modified code. Regards Amar On Tue, Apr 1, 2014 at 9:31 PM, ravinder negi ravindervbacli...@gmail.com wrote: have u added the library word object library in vba On Mon, Mar 31, 2014 at 10:02 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder VBA Code not working.Attached Error Screen shot here.Pls see guide me.I have no knowledge of VBA. In excel there are no show Microsoft Word library in Tools-reference option but show it as Microsoft Word 11.0 Object library Pls look in this issue. Regards Amar On Mon, Mar 31, 2014 at 5:39 PM, Ravinder ravindervbacli...@gmail.com wrote: Note:- add word library Microsoft Word library This is simply copy and paste value from excel to word and you need to select range (will be asked by program) which you want to transfer in word Sub Button1_Click() Dim wrd As New Word.Application Dim doc As Word.Document Dim RNG As Range Set RNG = Application.InputBox(Please Select Range to Transfer in Word:, Type:=8) Set doc = wrd.documents.Add wrd.Visible = True 'if you dont want to show wrd application then just use false instead of true RNG.Copy wrd.Selection.Paste Set tbl = doc.Tables(1) doc.SaveAs2 ThisWorkbook.Path \ ActiveSheet.Name .doc 'change save as path as per ur requirement End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, March 31, 2014 3:35 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ashish Sir, I learned many VBA work from your Code which is a lot of time saving easy to do. Before one week on our excel forum one topic discussed as (Macro to Import Word Tables to Excel from a folder). I got code from word to excel but I required excel to word.I use excel 2003. Can you share code excel to word table as proper in one sheet with respective sheet name. I would appreciate very much if you can help me on this. Regards -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr
Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file
have u added the library word object library in vba On Mon, Mar 31, 2014 at 10:02 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder VBA Code not working.Attached Error Screen shot here.Pls see guide me.I have no knowledge of VBA. In excel there are no show Microsoft Word library in Tools-reference option but show it as Microsoft Word 11.0 Object library Pls look in this issue. Regards Amar On Mon, Mar 31, 2014 at 5:39 PM, Ravinder ravindervbacli...@gmail.com wrote: Note:- add word library Microsoft Word library This is simply copy and paste value from excel to word and you need to select range (will be asked by program) which you want to transfer in word Sub Button1_Click() Dim wrd As New Word.Application Dim doc As Word.Document Dim RNG As Range Set RNG = Application.InputBox(Please Select Range to Transfer in Word:, Type:=8) Set doc = wrd.documents.Add wrd.Visible = True 'if you dont want to show wrd application then just use false instead of true RNG.Copy wrd.Selection.Paste Set tbl = doc.Tables(1) doc.SaveAs2 ThisWorkbook.Path \ ActiveSheet.Name .doc 'change save as path as per ur requirement End Sub -Original Message- From: excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, March 31, 2014 3:35 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ashish Sir, I learned many VBA work from your Code which is a lot of time saving easy to do. Before one week on our excel forum one topic discussed as (Macro to Import Word Tables to Excel from a folder). I got code from word to excel but I required excel to word.I use excel 2003. Can you share code excel to word table as proper in one sheet with respective sheet name. I would appreciate very much if you can help me on this. Regards -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions
Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file
Dear Ravinder Thanks for reply but how to do it.Pls give me guidance or give modified code. Regards Amar On Tue, Apr 1, 2014 at 9:31 PM, ravinder negi ravindervbacli...@gmail.com wrote: have u added the library word object library in vba On Mon, Mar 31, 2014 at 10:02 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder VBA Code not working.Attached Error Screen shot here.Pls see guide me.I have no knowledge of VBA. In excel there are no show Microsoft Word library in Tools-reference option but show it as Microsoft Word 11.0 Object library Pls look in this issue. Regards Amar On Mon, Mar 31, 2014 at 5:39 PM, Ravinder ravindervbacli...@gmail.com wrote: Note:- add word library Microsoft Word library This is simply copy and paste value from excel to word and you need to select range (will be asked by program) which you want to transfer in word Sub Button1_Click() Dim wrd As New Word.Application Dim doc As Word.Document Dim RNG As Range Set RNG = Application.InputBox(Please Select Range to Transfer in Word:, Type:=8) Set doc = wrd.documents.Add wrd.Visible = True 'if you dont want to show wrd application then just use false instead of true RNG.Copy wrd.Selection.Paste Set tbl = doc.Tables(1) doc.SaveAs2 ThisWorkbook.Path \ ActiveSheet.Name .doc 'change save as path as per ur requirement End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, March 31, 2014 3:35 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ashish Sir, I learned many VBA work from your Code which is a lot of time saving easy to do. Before one week on our excel forum one topic discussed as (Macro to Import Word Tables to Excel from a folder). I got code from word to excel but I required excel to word.I use excel 2003. Can you share code excel to word table as proper in one sheet with respective sheet name. I would appreciate very much if you can help me on this. Regards -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like
RE: $$Excel-Macros$$ VBA Code to Import Excel table in Word file
Note:- add word library Microsoft Word library This is simply copy and paste value from excel to word and you need to select range (will be asked by program) which you want to transfer in word Sub Button1_Click() Dim wrd As New Word.Application Dim doc As Word.Document Dim RNG As Range Set RNG = Application.InputBox(Please Select Range to Transfer in Word:, Type:=8) Set doc = wrd.documents.Add wrd.Visible = True 'if you dont want to show wrd application then just use false instead of true RNG.Copy wrd.Selection.Paste Set tbl = doc.Tables(1) doc.SaveAs2 ThisWorkbook.Path \ ActiveSheet.Name .doc 'change save as path as per ur requirement End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, March 31, 2014 3:35 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ashish Sir, I learned many VBA work from your Code which is a lot of time saving easy to do. Before one week on our excel forum one topic discussed as (Macro to Import Word Tables to Excel from a folder). I got code from word to excel but I required excel to word.I use excel 2003. Can you share code excel to word table as proper in one sheet with respective sheet name. I would appreciate very much if you can help me on this. Regards -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. EXCEL TO WORD(TBL).xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12