S
Snoopy
Hey guys
My macro makes a list (in sheet "BOARD") of all files in a folder
given as variable path.
To each file my macro generates an hyperlink / "open-file funktion" as
well.
This file-list is placed in range A5-A?? (depending of number of
files).
The macro works well (Hurra!!!)
Now I want to write (short) comments to the file-names in column B /
respectivly row (you know there are a lots of incomprehensible
filenames in the world, and I want to add and save some information of
content in my file-list machine).
My aim is to save the filenames + comments in range A5-C?? (one and
last comment pr file) in a sheet "COMMENTS" in a way that when running
the macro (listing updated files of the folder) the allready saved
comments (where they exist - else blanks B) will appear in column B /
respectivly (updated if changed number of files) in my file-list in
sheet "BOARD"
I hope the problem is clearly described and would appreciate your
support and help
Best Regards
Snoopy
My macro makes a list (in sheet "BOARD") of all files in a folder
given as variable path.
To each file my macro generates an hyperlink / "open-file funktion" as
well.
This file-list is placed in range A5-A?? (depending of number of
files).
The macro works well (Hurra!!!)
Now I want to write (short) comments to the file-names in column B /
respectivly row (you know there are a lots of incomprehensible
filenames in the world, and I want to add and save some information of
content in my file-list machine).
My aim is to save the filenames + comments in range A5-C?? (one and
last comment pr file) in a sheet "COMMENTS" in a way that when running
the macro (listing updated files of the folder) the allready saved
comments (where they exist - else blanks B) will appear in column B /
respectivly (updated if changed number of files) in my file-list in
sheet "BOARD"
I hope the problem is clearly described and would appreciate your
support and help
Best Regards
Snoopy