People,
I'm looking for a (simple) way to read the timestamp of files before reading the actual files into Excell. I would have thought this be a simple task but so far I've not been succesfull. Thnx in advance.
Printable View
People,
I'm looking for a (simple) way to read the timestamp of files before reading the actual files into Excell. I would have thought this be a simple task but so far I've not been succesfull. Thnx in advance.
try reading about getattr function.
Otherwise it might be FileSystemObject (class/reference).
Ecniv,
If tried FileSystemObject but this seems to be Vb property and unknown in VBA, which I am using. Or should I include some dll for this to work?
The getattr property might be a way to get things done but I have not been able to read up on it since I have a limited help-function on this particular machine. Could you enlighten me?
Thnx.
As Ecniv pointed out quit clearly FileSystemObject only works with a reference; this should be a reference to Microsoft Scripting Runtime. With this it works like a charme.
Thnx again Ecniv. :thumb: