View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric[_6_] Eric[_6_] is offline
external usenet poster
 
Posts: 23
Default How to use an array

Hi,

I am creating a macro for this plane text file something
like this:
0123456abc111GNP
0312443DEF222VCF
....so on
I want to put them into an array and convert to an excel
file, if may data (or different files) is variable not
fixed not the same above.

If my other file is longer or not the same format. I am
converting different files with different length and I
don't want to modify my macro every now and then.

003131333gnperd141414jkjk141414
111144444sdfdsf324323bbbb333333
.... so on

appreciate very much your help.

Regards
Eric