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
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