Input Text file Missing Delimiters after Export

**karthik123qwe** · 12-21-2012, 12:43 PM

Hi all,

I wrote a macro for importing TEXT(*.txt) files to Excel files and the macro ran fine.

But after running the Macro all my Input files were missing Delimiters and the empty file names were showing (1 KB) in size causing no reusability of them.

Please help me ...

**tigeravatar** · 12-21-2012, 02:40 PM

karthik123qwe,

I often use this for importing text files:

Please Login or Register  to view this content.

For example, to import tab delimited text files I would call that with:

Please Login or Register  to view this content.

**karthik123qwe** · 12-22-2012, 04:02 AM

hi tigeravatar,

thanks for helping out, still I cant sort out the issue . What i need is, my input file shouldnt be affected by my macro. is there any way to remove connection through macro:

here is my code below,

Please Login or Register  to view this content.

**karthik123qwe** · 12-24-2012, 07:14 AM

Hi,

I solved it, the problem was that the temporary Worksheet was closed with changes, hence i discarded the changes by tWB.Close SaveChanges:=False.

thanks all