bdl004
07-21-2010, 05:17 AM
Hi Everybody,
I have a quick question about specifying delimiters when opening a text file for input. I know that when a text file is opened in excel that it is very easy to code delimiters.
My question is whether I can do this for reading a file in to an array in vba. I have attached the file that I would like to use for input. I would like the entire date in one element of an array, the entire time in another element, and the number in a third element.
If I simply use the "Input #1, gooddata" command, it only reads in the year, and the first number of the time. My code is also attached...
PS The bit about garbage is just to skip the top few lines...
Thanks!
I have a quick question about specifying delimiters when opening a text file for input. I know that when a text file is opened in excel that it is very easy to code delimiters.
My question is whether I can do this for reading a file in to an array in vba. I have attached the file that I would like to use for input. I would like the entire date in one element of an array, the entire time in another element, and the number in a third element.
If I simply use the "Input #1, gooddata" command, it only reads in the year, and the first number of the time. My code is also attached...
PS The bit about garbage is just to skip the top few lines...
Thanks!