I am creating a workbook (WB1) from sheets in an existing workbook (WB2).
WB1 is saved to a location of choice by using Application.GetSaveAsFilename, a message box then informs the user of the path to WB1 using Application.ActiveWorkbook.path and WB1 is then closed.
The problem I have is that I need to somehow capture the file path for WB1 and enter it into WB2 as a hyperlink to WB1.
Does anyone know how to capture the file path using Application.ActiveWorkbook.path ?
I need to get the path name for WB1 and record it somehow programatically before I close the file so that I can use it in the hyperlink creation for WB2.
Any ideas ? Sounds straight forward but I'm stuck !