I'll let you play a bit with this one.
But here's some clues:
the line: set f = fso.Getfolder(...)
stores a LOT of info about the folder in the structure "f".
One attribute is "datelastmodified" (look in the Help)
so.. I'm guessing that the timestamp is for the subfolder,
so you'll want to get t
again thank you
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel
This is great!
This is so clearly structured, and it does almost exactly what i
wanted...
Thanks a lot!
The only thing that is not perfect, is that i have a timestamp in
Collumn C,
and now, wenn i Update, (by executing the macro), i get a new
timestamp in C, even if there is no change.
How can i f
Dear Group Member,
Can some one help me on attached file. I
wanted to get result from Data into summery by selecting agent name.
I wanted to done without Micro.
Regards,
Mudassar Razman
--~--~-~--~~~---~--~~
Visit the blog t
It's actually not that difficult.
In fact, if you look for "subfolders" in the VBA help, it gives a pretty good
example.
I modified it like this:
Option Explicit
Sub find_folder()
Dim fso, f, sf, fldr, folderlist
Dim I
Set fso = CreateObject("Scripting.FileSystemObject")
For I =
