VBA code to import text file to the fixed excel file

Hi

Currently I need a macro to import text file into a excel file and this is the code below. However every time when the text file is import, a new excel file will be created, can anyone help me to change the code, so that the text file will always import into the same excel file name " monthly standard working file".

Please Login or Register  to view this content.