Never thought this would be my biggest headache today.
Short version: I spent all day yesterday doing test runs and logging data (for which the physical setup took the first part of the week). Today I'm trying to sort the massive pile of log files into something that's convenient for analysis.
Problem is, the software that was logging the realtime data is an old, unsupported POS with very strange filing procedures. Essentially, for a test names "Test1", it dumps out a dozen+ files named Test1.xxx, where xxx can be, well, a LOT of different things. And every additional test gets all its files dumped in that same directory.
And, just for grins&giggles, the data I need are always in the file that has no extension.
So, today I've been bashing (ahem) together a VBA script in Excel (sucks, but it's what I've got) that opens a user dialog, sucks up the file, and rearranges the data into nice columnar format for further processing. But I'd like to have the file-select box filter out all the files that have extensions, so that when the user selects the directory where all the files from all of the tests got dumped, the user will only see the files that have no extension.
And this is where I'm stuck. Googling around I've found how to have the box filter for any extension I like, except the no-extension-at-all condition. I just can't seem to find the correct magic combination of search terms to lead me to what I need.
Anybody know how to do this?
Short version: I spent all day yesterday doing test runs and logging data (for which the physical setup took the first part of the week). Today I'm trying to sort the massive pile of log files into something that's convenient for analysis.
Problem is, the software that was logging the realtime data is an old, unsupported POS with very strange filing procedures. Essentially, for a test names "Test1", it dumps out a dozen+ files named Test1.xxx, where xxx can be, well, a LOT of different things. And every additional test gets all its files dumped in that same directory.
And, just for grins&giggles, the data I need are always in the file that has no extension.
So, today I've been bashing (ahem) together a VBA script in Excel (sucks, but it's what I've got) that opens a user dialog, sucks up the file, and rearranges the data into nice columnar format for further processing. But I'd like to have the file-select box filter out all the files that have extensions, so that when the user selects the directory where all the files from all of the tests got dumped, the user will only see the files that have no extension.
And this is where I'm stuck. Googling around I've found how to have the box filter for any extension I like, except the no-extension-at-all condition. I just can't seem to find the correct magic combination of search terms to lead me to what I need.
Anybody know how to do this?