Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 61
  • Last Modified:

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

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
Omar Hernandez
Asked:
Omar Hernandez
  • 10
  • 10
1 Solution
 
Martin LissRetired ProgrammerCommented:
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
 
Omar HernandezAuthor Commented:
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
 
Martin LissRetired ProgrammerCommented:
Do you want to show the number of folders or the number of files in the folder?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Omar HernandezAuthor Commented:
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
 
Martin LissRetired ProgrammerCommented:
If it just has 4 folder inside do you want it to say ** 4 Files **?
0
 
Omar HernandezAuthor Commented:
yes
0
 
Martin LissRetired ProgrammerCommented:
Give this a whirl.
28978771.xlsm
0
 
Omar HernandezAuthor Commented:
when i click on the refresh button it gives me an error code (run-time error '76')
0
 
Martin LissRetired ProgrammerCommented:
It doesn't happen to me so I need to know what you did before you clicked the Refresh button.
0
 
Martin LissRetired ProgrammerCommented:
I know what it is. Delete the hyperlinks in the workbook I attached since they point to folders on my PC.
0
 
Omar HernandezAuthor Commented:
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
 
Martin LissRetired ProgrammerCommented:
Link to a folder rather than a file and see if it works right.
0
 
Omar HernandezAuthor Commented:
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
 
Martin LissRetired ProgrammerCommented:
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
 
Omar HernandezAuthor Commented:
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
 
Omar HernandezAuthor Commented:
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
 
Martin LissRetired ProgrammerCommented:
No. It will just show you the files and sub-folders of the linked-to folder,
0
 
Omar HernandezAuthor Commented:
ok, thanks for your expertise
0
 
Omar HernandezAuthor Commented:
This file is working great, Just what i wanted thanks again Marty
0
 
Martin LissRetired ProgrammerCommented:
You're welcome.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 10
  • 10
Tackle projects and never again get stuck behind a technical roadblock.
Join Now