0

I like to know if the address parameter (when you want to use Hyperlink in VBA) can be dynamic like If I saved a copy of my active sheet in X folder, can VBA copy that address not mather the place I choose for saving my document?

Thanks!

Esteban
  • 1
  • 2
    Would help to show an example of the type of link you're creating. – Tim Williams Jul 27 '22 at 05:50
  • If you are "saving file as" then you can easly find [path of saved file](https://stackoverflow.com/questions/2813925/how-to-get-the-path-of-current-worksheet-in-vba). If you want VBA to find specific file that you sometimes save on desktop sometimes somewhere else it will be hard to do but you can look for [file in subfolders](https://stackoverflow.com/questions/15339006/file-searching-in-vba). – p77u77n77k Jul 27 '22 at 07:35
  • Please provide enough code so others can better understand or reproduce the problem. – Community Aug 01 '22 at 14:24

0 Answers0