isaacren94
New Member
- Joined
- May 18, 2019
- Messages
- 6
Hello all I am having trouble with a code to let the user set a path in VBA
Right now I have
It keeps giving me a 1004 error code and I was wondering if there was any special rules for the naming scheme.
Thanks for the help
Right now I have
Code:
Dim filePathRop_Gamma As Variant
filePathRop_Gamma = ThisWorkbook.Worksheets("Setup Tab").Range("K4").Value 'user supplied path
'code to open the file
Workbooks.OpenText Filename:=filePathRop_Gamma, TextQualifier:= _
xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=True, Semicolon:=False, _
Comma:=False, Space:=True, Other:=False, FieldInfo:=Array(Array(1, 1), _
Array(2, 1), Array(3, 1), Array(4, 1)), TrailingMinusNumbers:=False
Thanks for the help