Basic Script to separate data using variable input into Excel .csv

[jimmyj2000]

Hey guys, hope this is the right spot for this. So i have the following script I'm working on, but obviously don't know what I am doing. This is a Basic Script placed ito a PC DMIS part program (outside of Excel), and what it does when the paragraphs I have marked are left out is dump my measurement results into a spreadsheet in a format that works perfectly with our SPC software. What I'm trying to do with the two marked paragraphs is have an input box pop up, and data be separated into separate sheets (i.e by mold cavity number 1-5) based on that input:

Please Login or Register  to view this content.

[jimmyj2000]

I have a screenshot of what I get when I run this with the marked paragraphs ommitted, but cannot post a picture for some reason, hopefully this works:

[jimmyj2000]

Well, I think I'm getting closer after hours of reading, but I think I still have an issue in the block labeled #2. Any pros have any ideas?

Please Login or Register  to view this content.