Insert a message question asking for a path

Viewed 24
Sub open_file()

' declare variable
Dim pathname

' assign a value
pathname = "C:\objetive_file.xlsx"
Workbooks.Open pathname

End Sub

any suggestion for insert a message box asking for the path? in example

pathname = "here asking to the user for the path"

Thanks anyway...

0 Answers
Related