[Solved] VBA: String Capture

  • Hi All,


    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 !


    Thanks


    AJW

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!