Hi,
I am running a simple excel macro which opens up a .dat file, then copies it over into an excel spreadsheet and finally saves it as an .xls file. However each time I run it I get an error saying "Compile error: Out of memory".
It highlights the code at the following place: FieldInfo:= ......Array(58, 1).The dat file itself is just 993 KB so whats the problem?? Any help would be appreciated!
I am running a simple excel macro which opens up a .dat file, then copies it over into an excel spreadsheet and finally saves it as an .xls file. However each time I run it I get an error saying "Compile error: Out of memory".
It highlights the code at the following place: FieldInfo:= ......Array(58, 1).The dat file itself is just 993 KB so whats the problem?? Any help would be appreciated!
