Excel Data FIll on Folder Files availablity

[parth007]

Hello Everyone,
Can anyone suggest on below.. Seems difficult task ..
We have a Folder then sub folders & then file in it..
We want to maintain a excel which will be responsible to provide details about file & fila name..
Example -
If a particular file is exist in given path then make status = DONE with its Artist name and path of location. If file not found in given location keep it blank.
Depratment.....Model

file path ...........
\\nas\00_Projects\INDOMITABLES\01_model\char\XXXXX\INDO_XXXXX_modFinal.ma

SubFolder file path ...........
\\nas\00_Projects\INDOMITABLES\01_model\char\XXXXX\version\INDO_XXXXX_mod001_PRAS.ma

i.e.
 First path will return below details in excel for Department Modeling - \\nas\00_Projects\INDOMITABLES\01_model\char\XXXXX\INDO_XXXXX_modFinal.ma
Project name – Indomitables
Character Name – XXXXX
Status – Done (If file exists)

 Second path will return below details in excel for Department Modeling -
\\nas\00_Projects\INDOMITABLES\01_model\char\XXXXX\version\INDO_XXXXX_mod001_PRAS.ma

Modelling Artist Name - PRAS
Attached is the Excel file whcih holds sample data based on above conditions

 

[parth007]

ANybody knows how to implement this

 

[Marc L]

Hi,

'cause last time you did wild crossing posts, and you're already warned
on another forum, maybe people are waiting to see your cross post links !

Just read forum rules …
​

 

[parth007]

Ohhh i didnot knew this was issue... i am new so kept seeking help from everyone.. will take care next time for sure.. thanks for reminding.. sorry for cross post

 

[parth007]

• Cross Posting, generally it is considered poor practice to cross post, that is to post the same question on several forums in the hope of getting a response quicker.

• If you do cross post, please put that in your post.

Dear members.. My bad for this.. i didnt knew that this will be bad... i didnt do this intentionally .. will take care henceforth..

Even if i do cross post i will well inform about it on thread..

 

[Marc L]

When you do cross posting, you must post links to others forums !

Use VBA Dir function to check if a file exists and
see Split function to separate data from file path …

_____________________________________________________
Je suis Charlie
​

 

[parth007]

Yes Marc.. but one question.. in cross posting is it allowed to put the URL of another forum in thread stating that its a cross post? i am unaware.. please suggest

 

[Marc L]

On the other forum, if you're caught on cross posting without any link,
your thread could be blocked, nobody can answer …
​

 

[parth007]

Yes Marc, so whenever there is cross post.. User should provide the Link of the Thread which he has posted in other forums..