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:
>
>
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
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
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
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,
>>
>
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
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
Hi all,
I want to create a xlsm file which list out the folder name, file name and
revision times with its corresponding date modified. When there is new file
updated, i hope it can be updated automatically in the workbook. may I know
how can I achieve this?
Thanks in advanced.
Cheers
--
