comma delimited files
-
I'm somewhat new to vb, although i feel like i know what im doing. I have a external program (not a excel macro) that I want to load a comma delimited file into. I need to load it and add up a few fields. Nothing complicated I'm sure, but I need some help on how to load the file into a excel worksheet (or whatever is best to do it with). Thanks in advance if you can help.
-
I'm somewhat new to vb, although i feel like i know what im doing. I have a external program (not a excel macro) that I want to load a comma delimited file into. I need to load it and add up a few fields. Nothing complicated I'm sure, but I need some help on how to load the file into a excel worksheet (or whatever is best to do it with). Thanks in advance if you can help.
Instantiate an Excel Application object (try get before you try create) and use the Excel object model to load the CSV. If it was me I'd use the filesystem object (part of scripting) and then parse it with the Split function into an array or some such, but I gues that dependes on where and what you want to do with the data.