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 Example File.Pls see it.I used Excel 2003. > I thinking VBA code is making as I change table range only & paste it > word (with formatting) bcos if I used it diffrent table in Excel. > Regards > Amar > > On Sat, Jan 19, 2013 at 11:39 AM, vijayajith VA <vjayajithi...@gmail.com> > wrote: > > Chage yourworksheet name .. as per your worksheet > > > > > > On Sat, Jan 19, 2013 at 11:38 AM, vijayajith VA <vijayajith...@gmail.com > > > > wrote: > >> > >> 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.Application > >> Dim wdDoc As Word.Document > >> Dim t As Word.Range > >> Dim myWordFile As String > >> > >> myWordFile = ThisWorkbook.Path & "\Export2Word1.dot" > >> Set rng = ws.Range(ws.Cells(1, 1), ws.Cells(21, 5)) > >> rng.Copy > >> Set wdDoc = wdApp.Documents.Add(myWordFile) > >> Set t = wdDoc.Content > >> t.Paste > >> wdApp.Visible = True > >> wdApp.Activate > >> Application.ScreenUpdating = True > >> Application.Calculation = xlCalculationAutomatic > >> End Sub > >> > >> > >> > >> On Sat, Jan 19, 2013 at 10:32 AM, amar takale <amartak...@gmail.com> > >> wrote: > >>> > >>> 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 Word.I think it is fantastic shortcut & save more time. > >>> > >>> Thanks a lot in Advance. > >>> > >>> Best Regards, > >>> > >>> Amar > >>> > >>> -- > >>> 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 post to this group, send email to excel-macros@googlegroups.com. > >>> To unsubscribe from this group, send email to > >>> excel-macros+unsubscr...@googlegroups.com. > >>> Visit this group at http://groups.google.com/group/excel-macros?hl=en. > >>> > >>> > >> > > > > -- > > 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 post to this group, send email to excel-macros@googlegroups.com. > > To unsubscribe from this group, send email to > > excel-macros+unsubscr...@googlegroups.com. > > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > > > > -- > 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 post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.