[newbe]

Hi I was wondering if the above can be achieved? My scenario is I have an issues log and the file name is saved as the issue title is there a way to get the saved file name into another workbook appearing as a hyper link back to the...

Hi

I was wondering if the above can be achieved?


My scenario is I have an issues log and the file name is saved as the issue title is there a way to get the saved file name into another workbook appearing as a hyper link back to the original?

I am assuming VBA will be needed and added on to the code below which i already have, the code takes the value of C9 (the issue title) and saves it in the right folder.

Code:
If Range("C9") = "" Then
Msgbox "Please ensure you fill out the Issue Title. Thanks"
Else
Saveactiveworkbook.saveas "C:\filename\filename\ & Range("C9")"
Msgbox " Thank you, your issue has now been saved."
Endif