![]() Tab:=False, Semicolon:=False, Comma:=False, Space:=False, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, _ Workbooks.OpenText Filename:=MyFile, Origin:=xlWindows, _ 'Open the Text file with the OpenText method. ' Ask the user for the file name to open. and the values are in hex datei which has to be converted to decimal.ĭim i As Long, p As Long, LimitRow As Long The excel should parse the data such a way that column 1 has time, and column 2,3,4,5,6,7 the values corresponding to the variables in column 2 of the text file. The column 1 corresponds to the time, column 2 the variable and column 3 the value corresponding the variable. I have lot of data in a text file arranged as 3 columns. I am new to VBA and I could use a little bit of help for a program which I am struggling with for the past 3 days.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |