francozola25
Board Regular
- Joined
- Aug 22, 2007
- Messages
- 96
Hi i was wondering if any one would know how to build a macro to look in a specific folder.
What i want is that when the macro is click that the macro would go insert > hyperlink > and look in a folder automatically rather than being giving My Documents everytime.
I know there is a way to change default but i only want this macro for this workbook.
I am currently inserting a hyperlink everytime and have drill down and look into this specific folder rather than having the macro that will find my MYWORK folder each time.
What i want is that when the macro is click that the macro would go insert > hyperlink > and look in a folder automatically rather than being giving My Documents everytime.
I know there is a way to change default but i only want this macro for this workbook.
I am currently inserting a hyperlink everytime and have drill down and look into this specific folder rather than having the macro that will find my MYWORK folder each time.