Hi killer
The problem is, the data is not the same order between the command syntax. So when imported it to excel, its difficult to arrange either using tab or delimeted.
But i will try to do per command syntax, which is have to extract manually first..
User Profile
Collapse
-
Importing Text Files in Excel
Hi there,
I have a data in text files. I need to write some macros / vba to import into Excel . The text files is base on command syntax, as this format;
Command-X;
Data1 Data2 Data3
--------- --------- --------
valuex valueb valuec
Command Executed
So My macro's have to search the command-X, search a Data then collect the value.
...
No activity results to display
Show More
Leave a comment: