TextTransfer using macros 1

[ciel220]

Hi,

I'm having problem with using TEXTTRANSFER with macros.
I have a text delimited file, namely file1. I tried to creat a macro and use textTransfer to automate the import process. However, the file imported is NOT in correct format. The text delimited filed all stick together!!!

What surpirse me is, when I do the import manually (i.e. using get external data, import...) the delimited fields work fine and I got the table in the way I want.

Any idea? Any one know what's going on? I spend so much time on this but I couldn't figure out what's going on!

PLEASE HELP!!!!

ciel

 

[Quintios]

Did you save a 'Spec' and reference that in your code? Onwards,

Q-

 

[ciel220]

Thanks!
I made a 'spec' and it works now!

ciel