Hello All,
I would like to ask you for help. I have in cell F8 this =HYPERLINK(F9) in cell F9 is changing content based on other cells example (C:\Users\xxx\Desktop\AAA\BBB\CCC\) . I need a button that open the hyperlink in cell F8 by clicking on it. I tried few codes that are work for opening files, but they are not working for folders. Could you please help me whit that? Thanks very much.
Why not just click on the hyperlink cell itself?
One way that can be done is using Shell to run explorer, but not recommended.
多么想要告诉你 我好喜欢你
Well i know its easiest by clicking on the hyperlink, but button looks nicer, so you saying is not worth to make a button?
What I am saying is, if you're gonna use VBA to open the folder, both cells F8 and F9 are not necessary, unless you want to display visibly the directory. Then the next thing is, using Shell is the only way I know to open a folder with VBA, but may not be the best solution.
If you really want to try it:
Please Login or Register to view this content.
Edit:
I suggest using VBA to create the hyperlink into a cell (i.e. F8), and then follow the link. Use the record macro function, you will get the code readily. Then bind the code (recorded macro) to a button.
Hello millz,
thanks for the code its working exactly as i expected, but it is possible after i click the button that the opened folder will be in front and not behind the excel? Thanks
Just add the second argument of Shell. You can look up Shell function in the VBA help file.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks