textbox input = file path

[Eraengineer]

I am looking for a fast way to move data from the old spreadsheet to the new revision. My thought is to use a form where one would enter the file path to the new sheet and then click the ok button which then does copy paste, etc. Any thoughts on how to have the textbox contents equal that of a file path?

 

[bertie]

I would just let the user select the file:

Sub test()
   Dim strFullPath As String
   
   strFullPath = Application.GetOpenFilename()
   
  MsgBox strFullPath
End Sub