Hey Folks,,
I have figured out a code to match the text file with excel sheet name.but
not able to open thetext file. Error in red line.
I want to open without using get openfilename.
Sub Read_text_File()
Dim fso, fld, fil As Object
Dim fldpth As String
fldpth = C:\Documents and
Try
Workbooks.OpenText Filename:=fldpth fname, _
Origin:=xlWindows, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:= _
Array(0, 2), TrailingMinusNumbers:=True
On Mon, Sep 12, 2011 at 6:40 PM, mrinal saha mris...@gmail.com wrote:
Hey Folks,,
I have figured out a code to match the text file