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.
Bookmarks