Re: $$Excel-Macros$$ Macro to open all file in folder

2013-05-20 Thread Paul Schreiner
mes you can, To all the people you can, As long as ever you can.” - John Wesley - From: Secret Shot To: excel-macros@googlegroups.com Sent: Sun, May 19, 2013 5:05:44 AM Subject: Re: $$Excel-Macros$$ Macro to open all file in

Re: $$Excel-Macros$$ Macro to open all file in folder

2013-05-19 Thread Secret Shot
& "Book1.xls" > ' copy stuff ... > Workbooks("Book1.xls").Close savechanges:=False > Application.ScreenUpdating = True > Copy_FileData = True > End Function > > > *Paul* > > --------- > *“Do

Re: $$Excel-Macros$$ Macro to open all file in folder

2013-05-16 Thread Paul Schreiner
long as ever you can.” - John Wesley --------------------- From: Secret Shot To: excel-macros@googlegroups.com Sent: Thu, May 16, 2013 1:24:51 PM Subject: Re: $$Excel-Macros$$ Macro to open all file in folder Thanks for the prompt paul, But i

Re: $$Excel-Macros$$ Macro to open all file in folder

2013-05-16 Thread Secret Shot
gt; > -- > *From:* Secret Shot > *To:* excel-macros@googlegroups.com > *Sent:* Thu, May 16, 2013 12:52:34 PM > *Subject:* $$Excel-Macros$$ Macro to open all file in folder > > Dear Group, > > I want help in writing a macro to make a list of of all

Re: $$Excel-Macros$$ Macro to open all file in folder

2013-05-16 Thread Paul Schreiner
-macros@googlegroups.com Sent: Thu, May 16, 2013 12:52:34 PM Subject: $$Excel-Macros$$ Macro to open all file in folder Dear Group, I want help in writing a macro to make a list of of all sub folder in a folder and then open each sub folder and then open a common file from each sub folder and