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-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 hartmut.gruenha...@bakerhughes.com wrote: Amar, the code I posted must be put into a

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 amartak...@gmail.com wrote: Dear hartmut, It not work,it

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 bpascal...@gmail.com wrote: Set ws = wb.Worksheets(Feuil) to Set ws = wb.activesheet

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 forum

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 vijayajith...@gmail.com

$$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

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

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 vijayajith...@gmail.comwrote: HI Amar, use below code..or Could you just share your workbook.. Sub method1() Application.ScreenUpdating = False Application.Calculation =

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 amartak...@gmail.com wrote: Dear vjayajithi, Thanks for reply.I have attached sheet.If I used code compile error.I will send printshot with