$$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

2011-08-01 Thread skyping1
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

Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

2011-08-02 Thread skyping1
Please find attached files...hope you can help On Aug 2, 10:23 am, "Rajan_Verma" wrote: > Please Attached  a sample file > > > > > > > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > >

Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

2011-08-02 Thread skyping1
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 Tra

Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

2011-08-08 Thread skyping1
> To: excel-macros@googlegroups.com > > Hi > There is No attachment. > > Best Regards,Venkat > Chennai > > On Tue, Aug 2, 2011 at 10:41 PM, skyping1 wrote: > > Please find attached files...hope you can help > > On Aug 2, 10:23 am, "Rajan_Verma

Re: $$Excel-Macros$$ Amend code to copy worksheets to new Worksheets upon selection via drop down lists.

2012-07-27 Thread skyping1
Hi David, Thanks for the reply. However, your amendment to the code does not result in the required output. If I implement your changes then I no longer get 'new' worksheets whether there is anything in the J12-31 range. I really need the code to make the worksheets named as per C12-c31, and

$$Excel-Macros$$ Re: Amend code to copy worksheets to new Worksheets upon selection via drop down lists.

2012-07-29 Thread skyping1
On Thursday, July 26, 2012 6:57:03 PM UTC+1, skyping1 wrote: > > Need your help once again!!! > > A previous project needs to be updated and I simply cannot my head around > it. > > I have a workbook that currently comprises of 5 worksheets, 3 of which are > relati

$$Excel-Macros$$ Re: Amend code to copy worksheets to new Worksheets upon selection via drop down lists.

2012-07-29 Thread skyping1
Hi David... Once again thanks for your response, but no workbook attached, so I cant test your code!!! Please could you resend? On Sunday, July 29, 2012 11:27:01 AM UTC+1, skyping1 wrote: > > > > On Thursday, July 26, 2012 6:57:03 PM UTC+1, skyping1 wrote: >> >> N

$$Excel-Macros$$ Re: Amend code to copy worksheets to new Worksheets upon selection via drop down lists.

2012-07-29 Thread skyping1
Hi David... Once again thanks for your response, but no workbook attached, so I cant test your code!!! Please could you resend? > > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, For

$$Excel-Macros$$ Re: Amend code to copy worksheets to new Worksheets upon selection via drop down lists.

2012-07-29 Thread skyping1
Hi David, Thank you for the file...it looks exactly what I'm after!!! Many thanks for all your help! Kevin > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Pr