Re: $$Excel-Macros$$ vba code for listing folder name and file name

2016-01-11 Thread Kat
Hi Mandeep, I've changed my code to the following. In terms of the revision times, I want to check whether it's following the format or not as well. Other than that, I'm not sure how to put the date modified in it as well. On Monday, 11 January 2016 17:50:35 UTC+8, Mandeep Baluja wrote: > >

Re: $$Excel-Macros$$ vba code for listing folder name and file name

2016-01-11 Thread Mandeep Baluja
Hey Kat, I am sorry but i didn't get the logic of this code which is totally different from your above query,Things which i understand its just checking whether file_name following the criteria or not, if 9th letter of the file name is equal to R then do something else show error in all column

Re: $$Excel-Macros$$ vba code for listing folder name and file name

2016-01-10 Thread Kat
Hi Mandeep, The revision time in my snapshot is the one I use writing. The real code isn't showing. It's not showing the folder name and file name as well. In terms of revision times, it's fine if the changes are done in certain interval. On Monday, 11 January 2016 15:34:15 UTC+8, Mandeep

Re: $$Excel-Macros$$ vba code for listing folder name and file name

2016-01-10 Thread Mandeep Baluja
Revision time ?? I have not heard about this while searching it on the internet I found this http://excel.tips.net/T002868_Using_Revision_Tracking.html which track the changes done workbook shared on network. Is revision time being noted anywhere in your workbook your snapshot is not showing wh

Re: $$Excel-Macros$$ vba code for listing folder name and file name

2016-01-10 Thread Kat
Hi Abhi, Unfortunately, the code doesn't apply for my case. On Monday, January 11, 2016 at 2:52:34 PM UTC+8, Abhi wrote: > > Please see if this solves your purpose - > > http://www.vbaexpress.com/kb/getarticle.php?kb_id=837 > > On Mon, Jan 11, 2016 at 11:55 AM, Kat > > wrote: > >> Hi Abhi, >> >

Re: $$Excel-Macros$$ vba code for listing folder name and file name

2016-01-10 Thread Abhishek Jain
Please see if this solves your purpose - http://www.vbaexpress.com/kb/getarticle.php?kb_id=837 On Mon, Jan 11, 2016 at 11:55 AM, Kat wrote: > Hi Abhi, > > In terms of revision times, I want to show all the current revision times. > Also, in the future, if there is any revision times being updat

Re: $$Excel-Macros$$ vba code for listing folder name and file name

2016-01-10 Thread Abhishek Jain
Please elaborate what do you mean by "revision times". Do you want to show the time when it was most recently updated or you want to show how many times has it been updated? On Mon, Jan 11, 2016 at 9:52 AM, Kat wrote: > Hi all, > > I want to create a xlsm file which list out the folder name, f