Re: $$Excel-Macros$$ Select all excel files in computer

2015-10-09 Thread Pankaj
> you can,As long as ever you can.” - John Wesley* > - > > -- > *From:* Swapnil Palande > > *To:* excel-...@googlegroups.com > *Sent:* Thursday, October 8, 2015 2:07 PM > *Subject:* Re: $$Excel-Macros$$ Select all excel files in comp

Re: $$Excel-Macros$$ Select all excel files in computer

2015-10-08 Thread Paul Schreiner
$$ Select all excel files in computer Hi,Instead of macro do it manually, it will be faster.  use search functionality of windows... Search for *.xls and *.xlsx and then move those files to destination folder. Regards, Swapnil Suresh Palande On 08-Oct-2015 8:28 am, "Pankaj Michael" w

Re: $$Excel-Macros$$ Select all excel files in computer

2015-10-08 Thread Mangesh Vimay
you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > -- > *From:* Mangesh

Re: $$Excel-Macros$$ Select all excel files in computer

2015-10-08 Thread Swapnil Palande
Hi, Instead of macro do it manually, it will be faster. use search functionality of windows... Search for *.xls and *.xlsx and then move those files to destination folder. Regards, Swapnil Suresh Palande On 08-Oct-2015 8:28 am, "Pankaj Michael" wrote: > > Hi to ALL, > > Can we search ALL excel

Re: $$Excel-Macros$$ Select all excel files in computer

2015-10-08 Thread Paul Schreiner
e places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Mangesh Vimay To: excel-macros@googlegroups.com Sent: Thursday, October 8, 2015 12:31 PM Subject: Re: $$Excel-Macros$$ Select all excel files in computer Paul, I have

Re: $$Excel-Macros$$ Select all excel files in computer

2015-10-08 Thread Mangesh Vimay
heet).Range("D1").Value = "Date Created" > Sheets(RepSheet).Range("E1").Value = "Date Modified" > ListRow = 1 > End Function > > > > *Paul* > > > - > > > > > >

Re: $$Excel-Macros$$ Select all excel files in computer

2015-10-08 Thread Paul Schreiner
e = "Date Created"     Sheets(RepSheet).Range("E1").Value = "Date Modified"    ListRow = 1 End Function  Paul --------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times

$$Excel-Macros$$ Select all excel files in computer

2015-10-07 Thread Pankaj Michael
Hi to ALL, Can we search ALL excel extension files through vba in a computer(All Drives) through VBA? Transfer to any other location. Priority is excel I want to shift all excel files from one computer to another because company is replacing systems and only ms office files needs to transfer as p