I am using the following VBA commands, however it is opening up a new work excel work book. I would like it to be added to a new sheet in my current workbook. Any help would be appreciated.
ChDir "..path.."
Workbooks.OpenText Filename:="...path"