I need to substitute an Excel master file in many PC and would like to do this via macro. I know the names of the PC, all the
usernames and all are accessable via LAN.
The path is always "C:\Documents and Settings\Username\Documents\Master\random_named_folder\master.xls" but my problem is that
the only certain date is that the pattern of the "random_named_folder" is "1d34c6b8.default" (8 random numbers/letters dot default)
and that it is the only subfolder of the "Master" folder.
There is a command in VB that reads the subfolders whatever their name is but how can I do this with Excel 2003.
Any idea for a script to retrieve the random folder names ? Thank you in advance.