t;
> 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 the folder in
> Next fldr
> Cells(I, 2) = folderlist 'Add list to cell
> End If
> End If
> Next I
> End Sub
>
> I put the above into VBA module
>
> hth,
>
> Paul
>
> - Original Message
> > From:
I have the following folder(or directory) structure:
list_folders.xls (in ROOT)
&
/Folder01/Subfolder01
/Folder01/Subfolder02
/Folder02/Subfolder01
/Folder02/Subfolder02
I want the makro to read the foldernames in Column A, and as a result
i would like to see the Subfolder Names in Column B (S
I have the following folder structure:
/Folder01/Subfolder01
/Folder01/Subfolder02
/Folder02/Subfolder01
/Folder02/Subfolder02
list_folders.xls should be in the ROOT
I want the makro to read the foldernames in Column A, and as a result
i would like to see the Subfolder Names in Column B (Seper
Application.EnableEvents = True
> Else
> Application.EnableEvents = False
> Target.Offset(0, 1) = Format(Now, "dd.mm.")
> Application.EnableEvents = True
> End If
> End Sub
>
> Paul
>
> - Original Message
> > From: Tob
This does not have to be a makro, if its possible.
Source:
A1:5
A2:7
A3:7
what i want from this:
B1: 5,7,7
(those values seperated by kommas)
so can it be done without a makro?
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.ex
Hey everyone,
I wanted to have an entry of date everytime i make a new entry in
A1:A100
the dates should dissapear when i delete the content.
I thought this should work:
Sub auto_date()
'Quelle: tob
If Intersect(Target, Range("A1:A100")) Is Nothing Then Exit Sub
If Target.Count > 1 Then
