Hello, I have a module that asks the user to open a file using GetFileOpen property because it is used in the code in that module.
That file path text is pasted into Sheet1 on cell C7 using the .FullName property. Example: C:\***\***
My questions is, I would want the user to use that same file/file path because in a different module they will need it but would not want them to have to open and select it again.
Is there a way to use the file path that is pasted in C7 instead of having to do Application.GetOpenFilename and the user having to select the same file again in this separate module
That file path text is pasted into Sheet1 on cell C7 using the .FullName property. Example: C:\***\***
My questions is, I would want the user to use that same file/file path because in a different module they will need it but would not want them to have to open and select it again.
Is there a way to use the file path that is pasted in C7 instead of having to do Application.GetOpenFilename and the user having to select the same file again in this separate module