I have the following code in a a macro:

ChDir "N:\pay\payroll\positive pay"
myfile = Application.GetOpenFilename("Text Files,*.txt")
Workbooks.OpenText FileName:=myfile, StartRow:=1,_
DataType:=xlDelimited, 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))

Everytime I execute the macro it does not start the open
file command from N:\pay\payroll\positive pay....it starts
from what ever folder I last had excel looking in. Did I
not code this correctly ?

Thanks !