Hiya, I'm using MS Excel 97 to pre-process some data for input into a Neural Network. The data I have at the moment is in ASCII form. I need to develop a macro to open about 300 different asci files with two columns separated by spaces. This data needs to be formatted into two separate columns and then normalised. I'm not sure what form the macro would take. Do you have any tips for opening multiple documents and performing this transformation? Could someone advise on how to use the DIR function in VB to create a loop?
Specifically, when I try to import the ASCII files a text import wizard pops up which I cannot include in the macro as the macro would then specify the particular file I'm importing and not be generic enough. I'm using this wizard to divide the data into two columns so it is necessary for what I need to do. Any clues on how to get around this problem? Many thanks.
Specifically, when I try to import the ASCII files a text import wizard pops up which I cannot include in the macro as the macro would then specify the particular file I'm importing and not be generic enough. I'm using this wizard to divide the data into two columns so it is necessary for what I need to do. Any clues on how to get around this problem? Many thanks.