Re: $$Excel-Macros$$ Re: Excel table Copy Paste in word (with formatting) *

2012-10-19 Thread Sam Mathai Chacko
This might help http://www.excelfox.com/forum/f13/extract-number-alphanumeric-text-186/ Regards, Sam On Fri, Oct 19, 2012 at 8:24 PM, Shiva Prasad wrote: > hi experts, > > how to separate the number, > i mentioned in excel cell > mentioned example > > > *example > > asdfhfgh9825101236sdfge, > 9

Re: $$Excel-Macros$$ Re: Excel table Copy Paste in word (with formatting) *

2012-10-19 Thread ashish koul
hi i tried ur file its working fine at my place. Can you share the actual file and output in word document On Fri, Oct 19, 2012 at 4:54 PM, amar takale wrote: > Pls help me on below topic > > > On Thu, Oct 18, 2012 at 6:31 PM, amar takale wrote: > >> Dear Hilary >> Your code not working it sh

Re: $$Excel-Macros$$ Re: Excel table Copy Paste in word (with formatting) *

2012-10-19 Thread amar takale
Pls help me on below topic On Thu, Oct 18, 2012 at 6:31 PM, amar takale wrote: > Dear Hilary > Your code not working it show out of range I will attached file as per you > suggest link below It also not working Pl see file > > > On Wed, Oct 17, 2012 at 10:33 PM, Hilary Lomotey wrote: > >> try th

Re: $$Excel-Macros$$ Re: Excel table Copy Paste in word (with formatting)

2012-10-17 Thread amar takale
Hi Ashish Thanks for reply for solution is very good.I will attached file in which One table I want to copy this table in word through VBA code Button as it with formatting.If there are increase person name Then I will change only range table then automatically that range table copy paste in word.P

Re: $$Excel-Macros$$ Re: Excel table Copy Paste in word (with formatting) *

2012-10-17 Thread Hilary Lomotey
try this Sub exportToWord() Dim SheetName As String, NumLines As Integer Dim WordApp As Object Set WordApp = CreateObject("Word.Application") WordApp.Visible = True Worksheets(SheetName).Range("frontcover").Copy 'you can replace the next line of code with ===>WordApp.Docum

Re: $$Excel-Macros$$ Re: Excel table Copy Paste in word (with formatting)

2012-10-17 Thread ashish koul
share excel file and word document or visit http://www.excelvbamacros.com/2011/11/find-row-and-column-number-of.html http://www.excelvbamacros.com/2011/10/copy-range-from-excel-and-paste-as.html On Wed, Oct 17, 2012 at 10:07 AM, amar takale wrote: > Pls help me for this solution > > > On Tue

$$Excel-Macros$$ Re: Excel table Copy Paste in word (with formatting)

2012-10-16 Thread amar takale
Pls help me for this solution On Tue, Oct 16, 2012 at 5:26 PM, amar takale wrote: > *Hi All Champs* > Can anybody tell me how to copy paste excel table in word as it with > formatting.So I want to VBA code for that then I will create button & only > click it So table automatically copy paste in