Please see the following link, as I cant seem to upload files to this site:
http://www.excelforum.com/excel-programming/784924-export-all-worksheets-in-order-to-word-including-pictures-etc.html Thanks! 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 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
