Excel Macro Code that imports data from text file

[Aisha Ali]

Hi all,
I am new to excel macros and usually record macros.
I want to create a macro that imports data from text file when ever it is updated. The text file is separated by TABS and I want the data to be recorded in a template.
Can anyone tell me a macro code to do so??????????

 

[Momentman]

I guess recording the import steps with the macro recorder will give you a good idea, you can import and do the text to column thingy , then we can tweak the macro afterwards

 

[Aisha Ali]

Thanks for your response. So I can create a macro to import text file by recording the steps?

 

[Momentman]

Yes you can

 

[Aisha Ali]

Okay thanks . I'll try doing it