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
Thanks for the prompt paul, But i tried few recording of macro, but didnt work. Can you please help me with Sample Macro so that i can mobify that as per my requirement. Regards Pankaj k Pandey On Thu, May 16, 2013 at 10:49 PM, Paul Schreiner wrote: > How comfortable are you with VBA? > How mu

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

2013-05-16 Thread Paul Schreiner
How comfortable are you with VBA? How much of this do you need help with? The Filesystem object is used to set up the folder/subfolder navigation. the function calls themselves are not difficult. Do you then need help copying rows of data?   Paul - “Do all