macro to Read Data Strings

I have written the macro below to read data string from text file. Can any one tell me where i did wrong? when i run this macro it says "Compile error: Expected array".
Please help me with these code.

Please Login or Register  to view this content.

Hi mithil,

First - edit your post and then go to advanced. Put Code Tabs (the # icon above the message) and save. This will allow us to read your code much easier. Please do this first.

Second a possible answer. Code like Record_Type(1) thinks Record_Type is a single dimension array. It thinks you are looking for a single element in the array. (Arrays default to zero base so the first thing in them is number zero) This may give you the first explaination.

Third - Put above all your code int he Module "Option Base Explicit". This will keep the code from compiling without dimensioning your variables.

Last - Arrays need to be dimensioned as Variant.

Look here for examples http://www.cpearson.com/excel/VBAArrays.htm

OK - here is some code to put in your module. Then go down to the immediate window and type ShowMithil and press enter. See if this helps..

Please Login or Register  to view this content.