I'm currently undertaking a project on my own, in which a tool creates a .DAT file with a ton of channel values, in a pretty complicated format when opened with notepad.
What i'm trying to figure out how to do is:
1. create a button that allows me to browse on my computer and select the specific file I want to import.
2. Create ( a macro maybe?) that will pull out specific values out of this .dat file which, I believe, are always in the same place regardless of which tool produced them.
3. Determine whether these values fall within a tolerance, and have and adjacent cell reading good/bad and color coded Green/Red for within and outside of the tolerance respectively.
I'm pretty much a macro n00b. I could do #3 pretty easily. It's the button creation and being able to locate the specific values in the .DAT file and assigning it to a cell that I'm having trouble figuring out. Any tutorials, reading materials, advice, videos, or anything would be immensely helpful.
Apologies for my terrible punctuation and grammar.
Bookmarks