Yeah, VBA is Visual Basic for Applications, which I guess comes with MS Office, but it looks like only the typical Windows "File Open" dialog box is available unless I want to start writing standalone VB and calling it from the VBA macro/script/whatever.
'*.' was in fact the first thing I tried, but the result was that the dialog box came up showing '*.*', which I guess makes sense from a M$ viewpoint. Gah.
I think I may be stuck following Catty's suggestion about using a separate script to add a unique extension to the extensionless filenames. Since I know there are already some pre-existing tools (non-M$ Office) that depend on those files having the original filenames, probably what I'll do is make copies. I'd been hoping to avoid that, though, so I could keep it all as a single self-contained Excel Macro. Still, I'm almost to the point of diminishing returns here -- this little R&D morsel is under-funded, so I need something quick and dirty, even if it's a lousy hack from a programmer standpoint.
'*.' was in fact the first thing I tried, but the result was that the dialog box came up showing '*.*', which I guess makes sense from a M$ viewpoint. Gah.
I think I may be stuck following Catty's suggestion about using a separate script to add a unique extension to the extensionless filenames. Since I know there are already some pre-existing tools (non-M$ Office) that depend on those files having the original filenames, probably what I'll do is make copies. I'd been hoping to avoid that, though, so I could keep it all as a single self-contained Excel Macro. Still, I'm almost to the point of diminishing returns here -- this little R&D morsel is under-funded, so I need something quick and dirty, even if it's a lousy hack from a programmer standpoint.