Hi Guys,
My code is almost over, objective is need to retrieve File names with its Last Modified Date,Last Modified User,File Size into Excel...
Everything is over but still am bottleneck to get Last Modified user's username
Any idea on this........thanks in advance
Here is few piece of my code .... (code format will be in improper format dont mind that)
Please Login or Register to view this content.
Last edited by arlu1201; 01-05-2013 at 05:32 AM.
impossible to test, missing Module2.DirLoop, attach file
If solved remember to mark Thread as solved
@patel45:
you do have the code for Sheet1.CommandButton2_Click? Please show it as that call happens prior to what you mention. TIA.
Ciao,
Holger
Last edited by arlu1201; 01-05-2013 at 05:32 AM. Reason: Put code tags for newbie.
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
elavarasans,
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi Patel45
Thanks for your reply Module2.DirLoop doesn't need for my requirement(i used just for testing the code in different way) , my code was not finished and also not in good format, it may confuse you ..... Any way if you get an idea to retrieve Username of Last Modified User for a file in a specified folder ..
Thanks in Advance
Please Login or Register to view this content.
Hi, elavarasans,
AFAIR there´s no way of retrieving the name of the person which last saved the file via FSO (maybe have a look at Properties in FileSystemObject yourself). I only remember
Cia,Please Login or Register to view this content.
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks