Ok, so I've got some data in a comma separated text file, and I need to import it into an Excel spreadsheet. Now, I can just about manage that manually 🙂 but we're going to be doing it over and over, so one of the guys in the lab said "just write a visual basic macro".
Now, I've never looked at VB before. I'm a reasonable programmer, just not in this language. All I want to do is have a button on the spreadsheet that causes this file to be read in and dumped to the spreadsheet. I could do it in C, or Tcl, but I'm new to the wonderful world of Excel and VB. Can anyone help me with the commands I need, or even better, point me in the direction of a "getting started" website for this kind of stuff? I've had no luck googling on the subject, I'm not afraid of doing the work myself (I'd actually prefer it that way!), but I do need a little help getting going.
Thanks guys!
Now, I've never looked at VB before. I'm a reasonable programmer, just not in this language. All I want to do is have a button on the spreadsheet that causes this file to be read in and dumped to the spreadsheet. I could do it in C, or Tcl, but I'm new to the wonderful world of Excel and VB. Can anyone help me with the commands I need, or even better, point me in the direction of a "getting started" website for this kind of stuff? I've had no luck googling on the subject, I'm not afraid of doing the work myself (I'd actually prefer it that way!), but I do need a little help getting going.
Thanks guys!
