Thanks for the reply...the issue is all previous documents (to which there are many 1000's are in Word. My predecessor however wrote work instructions in Excel, but all written procedures should really be in a Word processing program, hence my question! There are still several hundred Excel files with instructions in each Worksheet labelled 1 to X which really is not a good idea (in my humble opinion) especially using Excel as a Word processor. I really need some help to transfer these Excel tabs systematically to Word, so please help!!
> From: dguille...@gmail.com > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled > 1 to X to Word. > Date: Mon, 8 Aug 2011 14:40:00 -0500 > > What do you need to do in Word that you can't do in excel? > > -----Original Message----- > From: skyping1 > Sent: Monday, August 08, 2011 12:07 PM > To: MS EXCEL AND VBA MACROS > Subject: Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets > labelled 1 to X to Word. > > Anyone have any ideas on this please? > > On Aug 3, 9:50 pm, Kevin gray <kevinrobertg...@hotmail.com> wrote: > > Please see attachments > > > > Date: Wed, 3 Aug 2011 07:48:44 +0530 > > Subject: Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets > > labelled 1 to X to Word. > > From: venkat1....@gmail.com > > To: excel-macros@googlegroups.com > > > > Hi > > There is No attachment. > > > > Best Regards,Venkat > > Chennai > > > > On Tue, Aug 2, 2011 at 10:41 PM, skyping1 <kevinrobertg...@hotmail.com> > > wrote: > > > > Please find attached files...hope you can help.... > > > > On Aug 2, 10:23 am, "Rajan_Verma" <rajanverma1...@gmail.com> wrote: > > > > > > > > > > > > > > > > > > > > > Please Attached a sample file > > > > > -----Original Message----- > > > From: excel-macros@googlegroups.com > > > [mailto:excel-macros@googlegroups.com] > > > > > On Behalf Of skyping1 > > > Sent: Tuesday, August 02, 2011 12:07 AM > > > To: MS EXCEL AND VBA MACROS > > > Subject: $$Excel-Macros$$ Code need to Transfer Excel worksheets > > > labelled 1 > > > to X to Word. > > > > > I have many Excel files in a folder which all have labelled Worksheets > > > from 1 to X where X is always an integer. > > > > > Most of the files have about 10 worksheets, and these can have both > > > text and pictures in. > > > > > I have searched, for some code (to no avail and through quite a few > > > forums!!), that would copy the content of the worksheets in numeric > > > order to a blank Word document. > > > > > I am using 2010, and ideally would like to select any number of files > > > and even perhaps the order(!) that they can be pasted into Word. > > > > > Hope you guys can help. > > > > > -- > > > --------------------------------------------------------------------------- > > > > > > - > > > ------ > > > Some important links for excel users: > > > 1. Follow us on TWITTER for tips tricks and links > > > :http://twitter.com/exceldailytip > > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > > <><><><><><><><><><><><><><><><><><><><><><> > > > Like our page on facebook , Just follow below > > > linkhttp://www.facebook.com/discussexcel > > > > -- > > > > --------------------------------------------------------------------------- > > ------- > > > > Some important links for excel users: > > > > 1. Follow us on TWITTER for tips tricks and links > > :http://twitter.com/exceldailytip > > > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > <><><><><><><><><><><><><><><><><><><><><><> > > > > Like our page on facebook , Just follow below link > > > > http://www.facebook.com/discussexcel > > > > -- > > > > -- > > > > --------------------------------------------------------------------------- > > ------- > > > > Some important links for excel users: > > > > 1. Follow us on TWITTER for tips tricks and links > > :http://twitter.com/exceldailytip > > > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > <><><><><><><><><><><><><><><><><><><><><><> > > > > Like our page on facebook , Just follow below link > > > > http://www.facebook.com/discussexcel > > > > Start.xlsm > > 971KViewDownload > > > > finish.docx > > 154KViewDownload > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
