[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 !



Participate now!

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