New software at work downloads a prn file to a location on our network within Network Neighborhood. I recorded a macro which changes directory and opens a specific file. When I run the recorded macro it brings up a dialog box within the current directory.
1- How can the macro be made to change drive to Network Neighborhood?
2- How can the macro be made to allow the user to select a file (like *.prn) from the dialog box (instead of the file recorded in this macro?
' ChDir "Lv40bQDLSGL2KFLRFNPVDCP"
' Workbooks.OpenText FileName:="Lv40bQDLSGL2KFLRFNPVDCP03PAY.PRN", _
' Origin:=xlWindows, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _
' xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, _
' Comma:=True, Space:=False, Other:=False, FieldInfo:=Array(Array(1, 1), _
' Array(2, 1))