Wildcard for File Extension?

[Dexter1]

I tried to search the forums for this, I swear!

I have a file I use as a shortcut to start an Access database that I place on my users' desktops. It's compiled into an .exe.

Code: Select all

executefile>C:\Documents and Settings\%USER_NAME%.hemaster\Folder\Database.mdb

The problem is that some of my users have their file extensions turned off. In these instances the file cannot call the database. I tried altering the macro to look for anything with most of the title in it but that doesn't work. As usual, I'm sure I'm missing something simple and any help will be greatly appreciated.

Code: Select all

executefile>C:\Documents and Settings\%USER_NAME%.hemaster\Folder\Database*

[Marcus Tettmar]

The file extension still exists. The option you are returning to does not turn then off it just HIDES them from view in Windows Explorer. The file is still Database.mdb so just leave it like that. If you open up a DOS prompt and do a DIR on that folder you will see the file WITH the extension.

http://filext.com/faq/file_extension_information.php

[Dexter1]

That's what I thought but that was the only obvious thing that had changed over the weekend. I'll have to dig deeper. Thanks a bunch.