Hi Guys
I'm using this macro to create a list of all files in a specific folder
How can I improve the code so the macro will list 5 files that selected randomly?Please Login or Register to view this content.
Many thanks for your help.
Amit.
Hi Guys
I'm using this macro to create a list of all files in a specific folder
How can I improve the code so the macro will list 5 files that selected randomly?Please Login or Register to view this content.
Many thanks for your help.
Amit.
Last edited by furiousfox; 11-03-2011 at 02:56 AM. Reason: Solved
Using Excel 2007.
Amit Cohen
Amit,
If you want the output to be 5 random files instead of all of them, you can use the following:
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi tigeravatar
This is awesome,
Works like a charm.
Many thanks for your help.
Amit
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks