Solved

Create a button that will give it a hyperlink function and that on cell would display the total amount of file that the hyperlink has

Posted on 2016-10-25
20
27 Views
Last Modified: 2016-10-26
Hyperlink function button
---Hyperlink to be on the "N" column  of given row, With the color that "K", "L" and "M" has.
---That when directed to a folder, will show on cell the amount of file it has on the folder.
28978276c.xlsm
0
Comment
Question by:Omar Hernandez
  • 10
  • 10
20 Comments
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
I believe that I can show the file count as the hyperlink text as you are requesting, but as usual I have a few questions.

1) If a file is added to or deleted from a folder that the workbook hyperlinks to, the count won't automatically be updated. Would you like a button that will update the counts in all hyperlinks?

2) As far as I can tell, the HYPERLINK button you show in the video does the sane thing as Right-Click|Edit Hyperlink or simply clicking on the hyperlink. If you intend for it to do more then let me know. If not, do you really want a button for that?

3) You say you want the column to be the same color as K:M. Do you mean the orange color?
0
 

Author Comment

by:Omar Hernandez
Comment Utility
1) If a file is added to or deleted from a folder that the workbook hyperlinks to, the count won't automatically be updated. Would you like a button that will update the counts in all hyperlinks?

---Yes this option would be great, but to have less button is it possible to have this update implemented on the refresh button we already have called "REFRESH" to do this in addition to what it do.

2) As far as I can tell, the HYPERLINK button you show in the video does the sane thing as Right-Click|Edit Hyperlink or simply clicking on the hyperlink. If you intend for it to do more then let me know. If not, do you really want a button for that?

---Yes i would like it to have this function in the new created "HYPERLINK" button.

3) You say you want the column to be the same color as K:M. Do you mean the orange color?

---Yes
0
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
Do you want to show the number of folders or the number of files in the folder?
0
 

Author Comment

by:Omar Hernandez
Comment Utility
let's say the hyper link is going to be in sync with a folder called "A"

***If folder "A" has
4 folder inside and
4 rar files and
4 word doc
                              Have Folder "A" shown as follow (**12 Files **)
0
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
If it just has 4 folder inside do you want it to say ** 4 Files **?
0
 

Author Comment

by:Omar Hernandez
Comment Utility
yes
0
 
LVL 45

Accepted Solution

by:
Martin Liss earned 500 total points
Comment Utility
Give this a whirl.
28978771.xlsm
0
 

Author Comment

by:Omar Hernandez
Comment Utility
when i click on the refresh button it gives me an error code (run-time error '76')
0
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
It doesn't happen to me so I need to know what you did before you clicked the Refresh button.
0
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
I know what it is. Delete the hyperlinks in the workbook I attached since they point to folders on my PC.
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 

Author Comment

by:Omar Hernandez
Comment Utility
Hey Marty when creating a hyperlink and linking it to a file

It is recognizing the FOLDERS

But not PDF, Word, Excel, Photo or others
0
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
Link to a folder rather than a file and see if it works right.
0
 

Author Comment

by:Omar Hernandez
Comment Utility
When i link it to a folder and i click the hyperlink cell it works great, but is it possible to see when i click on the Hyperlink to see other type of files format and not only limiting it self to look for only folder.

For example if i click on a cell and then click on the "HYPERLINK" button is it possible that it can also show.

PDF, WORD, DOCS, RAR ETC
0
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
The hyperlink will show you the contents of the linked-to folder and you can then drill down to any subfolder and file that you want.
0
 

Author Comment

by:Omar Hernandez
Comment Utility
ok, yes i know that when i open it, it does show the actual file that way when clicking on the hyperlink cell that has a file link on there.

but, just a question...
Is it possible to have this method where i can see all those other files instead of it limiting itself to just folder.
0
 

Author Comment

by:Omar Hernandez
Comment Utility
Let's say if there is a pic i only want to be used as a hyperlink or
PDF for an actual book

i would appreciate to click on a task that say

Task : Receipt for car > Hyperlink : Actual Receipt for car Pic
Instead of me having it on a folder

Task : Book 13 laws of success > Hyperlink : Actual PDF 13 laws of success
Instead of me having it on a folder
0
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
No. It will just show you the files and sub-folders of the linked-to folder,
0
 

Author Comment

by:Omar Hernandez
Comment Utility
ok, thanks for your expertise
0
 

Author Closing Comment

by:Omar Hernandez
Comment Utility
This file is working great, Just what i wanted thanks again Marty
0
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
You're welcome.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now