Open a file with a button, allow it to be comma delimeted

[skania]

Hey guys, I'm pretty new to VBA, only having minimal exposure to it a few months ago. My boss has thrown a complete curve ball at me and I'm not sure how to do this (most of the other code is taken care of ).
The program: The program will open 2 files (conveniently, ie. no File->Open->All Files->ect..)... where the first file is the output from a program from a test on a subject. The 2nd file is the subjects hear rate during the test. My task is to sync up the files to see if there was increased heart rate during certain stimulus blah blah blah.. that's taken care of, however..

There are 2 files that need to be opened (I'm assuming 2 buttons, with 2 separate subs would be the best). The only information I need from the first one luckily has a , right before the data. When I import the file and use comma delimited, the file is exactly in the format it needs to be for the current program to work.
The 2nd file is a list of times a heart beat occurred (5.3\n, ect..).

I'm not worried about the 2nd file, I feel that is pretty straight forward, but I've spent the better part of my day Googling, Binging, and reading a book in the office on VBA and can't seem to get a grasp on how to open a comma delimited file with a button on the Excel sheet. Any suggestions?

Sorry if this isn't orthodox, new to VBA, and though I ran across this forum earlier this morning, I finally registered to ask.

[tehneXus]

Hi,

you can open the file and provide the format parameter described by MS here: http://msdn.microsoft.com/en-us/libr.../ff194819.aspx
e.g.

Please Login or Register  to view this content.

where 2 is for CSV file

or import the file as text, comma separated into excel, that code is produced by the macro recorder:

Please Login or Register  to view this content.

where 'TextFileColumnDataTypes ' provides the information about the data type for the columns, so this code will not work for you file, you have to use the macro recorder yourself on the file

Regards