LinkBack URL
About LinkBacks
Dear all
i am seeking some help regarding
how to generate link automatically in excel to files in a specific folder once you add the file to the folder or even when i click a button to check the new files in the folder
Dear all
i am seeking some help regarding
how to generate link automatically in excel to files in a specific folder once you add the file to the folder or even when i click a button to check the new files in the folder
Last edited by AliGW; 10-31-2020 at 11:25 AM. Reason: Redacted for legibility.
Please Login or Register to view this content.
thank you so much
is there any way to make it insert the folder too?
and my main question is are there any way to add the file to the sheet automatically without running the macro, and it happened once I open the file that contains the macro ??
(make the macro work automatically by opening the file and go to a specific folder determined in it and list all folders in columns with their files )
again THANK YOU SO MUCH , IT IS REALLY HELPFULL CODE
Last edited by AliGW; 10-31-2020 at 11:26 AM. Reason: Redacted for legibility.
add below to ThisWorkbook module- excel file needs to be saved as Macro-Enabled Worksheet (.xlsm)
Please Login or Register to view this content.
yes it works, thank you so much,,
is there any way to catch the folder names too?
Yes but I don’t have access to my pc right now
Will do it tomorrow
thank you so much
Try this
Please Login or Register to view this content.
thank you,, very good it works perfectly
is there any way to make any different sign like( font color, bold font ) for the folder names?
right now folder path is separated from the rest with empty row but yes you can have that too
Please Login or Register to view this content.
amazing as usual
Dear AC PORTA VIA
can add the "modified date" of the files in another column beside the column of the names of the files??
this will help to sort the file according to modified date.
kind regards,,
Try this
Please Login or Register to view this content.
Last edited by AC PORTA VIA; 11-03-2020 at 09:49 PM.
Dear AC PORTA VIA
IT WORKS
regards,,
It creates new sheet named “ Files” to prevent overwriting anything in active sheet
Everything you need should be on the same sheet-
Name DateLastModified DateCreated DateLastAccessed
thanks ,,
what i got is file names in a sheet and all other dates in another sheet, so does at what macro do?
Macro runs fine when I ran it
All info with file name hyperlink and modified date are on the same sheet named Files
There is something in your workbook that switch between sheet name Files and some other sheet in the middle of running macro
Do you have any other macro in your workbook?
Use macro below - just remainder anything in active sheet in the first 4 columns ( A-D) will be deleted before new data is added
Please Login or Register to view this content.
Last edited by AC PORTA VIA; 11-06-2020 at 09:45 AM.
perfect as usual, but there are extra "xPath" in the code, but when I remove it, it works fantastic
I really appreciated it
You are welcome
Glad it works for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks