Re: $$Excel-Macros$$ VBA Help:Excel table copy paste in word (with formatting as it)

2013-01-27 Thread amar takale
Hi minimaster, I put into a normal code module but not work Pls send me above attached report Name Excel file with that code.I dont know why? Pls. Amar On Mon, Jan 28, 2013 at 12:53 PM, minimaster wrote: > Amar, > the code I posted must be put into a normal code module, not into the S

Re: $$Excel-Macros$$ VBA Help:Excel table copy paste in word (with formatting as it)

2013-01-27 Thread minimaster
Amar, the code I posted must be put into a normal code module, not into the Sheet object. kind regards -- 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

Re: $$Excel-Macros$$ VBA Help:Excel table copy paste in word (with formatting as it)

2013-01-25 Thread amar takale
Dear, Price,Rajan,Hilary,Noorin,Ashish..& All Expert, Pls look this matter for solution. I got answer 90% but 10% is confused why Excel table not copy paste in word. Pls try Regards Amar On Fri, Jan 25, 2013 at 12:53 PM, amar takale wrote: > Dear hartmut, > It not work,it show error.I attache

Re: $$Excel-Macros$$ VBA Help:Excel table copy paste in word (with formatting as it)

2013-01-24 Thread amar takale
Hi All Anybody tell me to answer. On Wed, Jan 23, 2013 at 4:21 PM, amar takale wrote: > Sir where is set code.it is replace old code or adjust on it.pls if > possible send me full code or sheet example which I attached above > (Report). > Thanks very much > > On Wed, Jan 23, 2013 at 3:01 AM, bpa

Re: $$Excel-Macros$$ VBA Help:Excel table copy paste in word (with formatting as it)

2013-01-23 Thread amar takale
Sir where is set code.it is replace old code or adjust on it.pls if possible send me full code or sheet example which I attached above (Report). Thanks very much On Wed, Jan 23, 2013 at 3:01 AM, bpascal123 wrote: > Set ws = wb.Worksheets("Feuil") > to > Set ws = wb.activesheet > > run the code f

Re: $$Excel-Macros$$ VBA Help:Excel table copy paste in word (with formatting as it)

2013-01-22 Thread bpascal123
Set ws = wb.Worksheets("Feuil") to Set ws = wb.activesheet run the code from the excel sheet the table is located else you can replace "Feuil" with the name of the sheet where the table is located, most likely "sheet1" btw Feuil means Sheet in French... -- Join official Facebook page of this f

Re: $$Excel-Macros$$ VBA Help:Excel table copy paste in word (with formatting as it)

2013-01-21 Thread amar takale
Hi vjayajithi, Can you Solved my Query.as per you saving, need to select tools ->refrence-> microsoft word.I select that tools but get error (Subscript out of range).Pls Suggest me Answer.I am waiting for solution Regards Amar On Sat, Jan 19, 2013 at 12:36 PM, vijayajith VA wrote: > need to selec

Re: $$Excel-Macros$$ VBA Help:Excel table copy paste in word (with formatting as it)

2013-01-18 Thread vijayajith VA
need to select tools ->refrence-> microsoft word .. i am working on it ...& will get back to you soon.. On Sat, Jan 19, 2013 at 12:04 PM, amar takale wrote: > Dear vjayajithi, > Thanks for reply.I have attached sheet.If I used code compile error.I > will send printshot with Example File.Pls see

Re: $$Excel-Macros$$ VBA Help:Excel table copy paste in word (with formatting as it)

2013-01-18 Thread vijayajith VA
Chage yourworksheet name .. as per your worksheet On Sat, Jan 19, 2013 at 11:38 AM, vijayajith VA wrote: > HI Amar, > use below code..or Could you just share your workbook.. > > Sub method1() > Application.ScreenUpdating = False > Application.Calculation = xlCalculationManual > > Dim wb As Wo

Re: $$Excel-Macros$$ VBA Help:Excel table copy paste in word (with formatting as it)

2013-01-18 Thread vijayajith VA
HI Amar, use below code..or Could you just share your workbook.. Sub method1() Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Dim wb As Workbook Dim ws As Worksheet Set wb = ThisWorkbook Set ws = wb.Worksheets("Feuil") Dim rng As Range Dim wdApp As New Word.A

$$Excel-Macros$$ VBA Help:Excel table copy paste in word (with formatting as it)

2013-01-18 Thread amar takale
Dear All Champs, Can anybody tell me first it is possible Excel table copy paste in word (with formatting as it)?If yes how to do it.I am VBA learner only not champ. So pls If anyone champ have Idea how to do it,suggest VBA code then I click Button only & automatically Excel Table copy paste in Wor