Import spectiality delimited text file

Hello guys,

Several months back I was working on a spreadsheet to help with my tasks at work (while learning VBA in the process) and was mid project when circumstances caused me to put that project on hold. Now, 4-ish months later, I am trying to pick it back up and am having trouble figuring out where to go (and recalling the little I had started to learn about VBA in general).

I have some working VBA code that currently imports several .s2p files (specialty delimited text files) and copies them to a new workbook, each file in its own sheet.

The next step I need to accomplish is to modify what I have to make a version that only allows one file to be imported.

Below is a copy of my working "Private Sub multiple_s2p_new_sheet()" code as well as my non-functional "Private Sub single_s2p_this_sheet()" code as well as a few example .s2p files (special text files from data collection).

Any help or advice is appreciated.

In the next step I will need to solve, I will need to make a version of this code (both the single and multiple) that imports the files into new sheets within the current workbook instead of making them in a new workbook; advice on that step would also help me out. Thanks in advance!

Link to zip file containing several .s2p sample files.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Because the end goal is to give this to the technicians at work, and I am trying to make it as dummy proof as possible.

The overall process will be to upload several files of raw data (A) and upload a single calibration file (B) and divide each point of each of the data files, by each point of the calibration file (A0[1,1]/B[1,1].......A255[1601,255]/B[1601,255]).

There will also be a need to perform an equation on each point of a data file, but I'll figure that out when I get to it.

Thanks for your help and time,
Trent Spencer - KM4YTU

Thank you for reply and time once again AlphaFrog.

I'm sorry if I was unclear, but I still need a dialog box to choose the file with, I just need it to be impossible to choose more than one file.

I will however save this version of the code, as I tested it and it is functional, and I can see potentially using it in the future.

I will see if I can modify your version to suit my needs while I wait on a response.

Thank you again for your time and help.

Regards,
Trent Spencer - KM4YTU

Well....I ended up getting something that would sort of work....making the hardcoded file be defined with a form text box. It's still not what I was thinking of...a dialog box to choose the file (but limited to one file) that would make it as easy to use as possible on the 3 people who would be using it.

I changed the strFileToOpen variable from your example to the following in my modified version:

Please Login or Register  to view this content.