Forum

Notifications
Clear all

[Help] Create-Hyperlinked-List-of-Files-in-Subfolders-Table Version.xlsm

6 Posts
2 Users
0 Reactions
77 Views
(@amhere)
Posts: 4
Active Member
Topic starter
 

Hello my friends.

I want a help about your exciting VBA file. I want it can list and hyperlink an attachment folder structure. It get an error when folders, subfolders or files by Unicode, example: é, ò,... I try to edit but i don't know vba, so i get a failure. Would you help me? Your files is very good. I like it.

 
Posted : 31/08/2016 12:45 pm
(@catalinb)
Posts: 1937
Member Admin
 

Hi,

Please test the file attached, I tested it and works with FileSystemObject. The results of the test are in the file.

Cheers,

Catalin

 
Posted : 31/08/2016 11:54 pm
(@amhere)
Posts: 4
Active Member
Topic starter
 

Incredible. Very good. You are pro. Thanks!

 
Posted : 01/09/2016 9:36 am
(@amhere)
Posts: 4
Active Member
Topic starter
 

Hi Catalin Bombea,

I have detected if a file has not an extension (has not ".txt, .doc, ....."), that code will not extract link. Why is it?

 
Posted : 01/09/2016 9:47 am
(@catalinb)
Posts: 1937
Member Admin
 

If you don't type anything in file filter input box, the default file filter is *.* , this means that a file name should any chars before and after the dot (so the dot is a must). Usually, all the files do have an extention, even if it's hidden in folder options settings. If there is no dot in the file name, then you have to specify a different pattern than the default one (*.*) .

Type a single * (asterisc) in file filter input box. This will cover any files.

 
Posted : 01/09/2016 10:39 am
(@amhere)
Posts: 4
Active Member
Topic starter
 

Very very incredible. Thank you very much.

 
Posted : 01/09/2016 10:47 am
Share: