File Re-open

[taha54]

hi all, i have a file lets call temp.xls , i used a VBA cde to do an operation on that file and save it in the same directory as a unicode txt file,

sub code()
operations

fname = ActiveWorkbook.Name

If Mid(fname, Len(fname) - 3, 1) = "." Then fname = Left(fname, Len(fname) - 4)
locat = "C:\Documents and Settings\Administrator\Desktop\E2A\" & fname & ".txt"
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:=locat, FileFormat:=xlUnicodeText
Application.DisplayAlerts = True
ActiveWorkbook.Close (False)

how can i re open my excel file whih is in the same directory to perform one more step in VBA on that txt file

thank you

EDIT: Added Code tags - Smitty

 

[Andrew Poulsom]

If you had:

fFullName = ActiveWorkbook.FullName

you could open it again with:

Workbooks.Open fFullName