Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Tech Request -- Accessing extensionless files from VBA
 
#6
Doing the text file processing isn't a problem, I've got that sorted.  What I'm doing is, when the VBA macro is started, it opens a standard Windows VB file-select window for the user to select the file s/he wants to work on.  Now, in my VBA code, I can set the "file types" box to only one extension, or several, and there's lots of information on-line about doing that.  I can have the visible files only show .txt, or .txt and .mp3, or whatever... but so far, everything I've tried to make it only show the files with no extension generates a runtime failure.  
This isn't really a critical part of the script, but given that I'm building this script for someone else whose VBA skills are even weaker than mine (and mine ain't too hot), and that any given file name can show up a dozen+ times in the file list with different extensions, not to mention that so far, the only way to get the extensionless files to even be visible is to set the box to *.*, and that all the different tests get stored in the same directory (we can't control the logging software at that level), well... it would just be a Really Nice feature if I could filter out all the files that this script isn't supposed to deal with.  It's an ergonomic thing, more than anything else.  I need the filtering to take place in the file-select box, which, as I understand it, is a completely standard Windows VB control (form?).  My problem is that I'm trying to get it to do something that, from my research so far, seems pretty atypical.  It's possible that the standard Windows file-select box just won't support what I want to do.
Reply


Messages In This Thread
[No subject] - by jpub - 07-23-2010, 07:31 PM
[No subject] - by SkyeFire - 07-23-2010, 09:17 PM
[No subject] - by paladindythe - 07-24-2010, 12:35 AM
[No subject] - by Ankhani - 07-24-2010, 01:26 AM
[No subject] - by SkyeFire - 07-24-2010, 03:03 AM
[No subject] - by Kurisu - 07-24-2010, 09:23 AM
[No subject] - by Ankhani - 07-24-2010, 08:17 PM
[No subject] - by CattyNebulart - 07-25-2010, 05:01 AM
[No subject] - by Sofaspud - 07-25-2010, 08:03 AM
[No subject] - by SkyeFire - 07-25-2010, 04:44 PM
[No subject] - by LilFluff - 07-25-2010, 10:44 PM
[No subject] - by Sofaspud - 07-26-2010, 03:16 AM

Forum Jump:


Users browsing this thread: 2 Guest(s)