Wildcard for File Extension?

Hints, tips and tricks for newbies

Moderators: Dorian (MJT support), JRL

Post Reply
Dexter1
Pro Scripter
Posts: 64
Joined: Mon Jun 19, 2006 3:28 pm

Wildcard for File Extension?

Post by Dexter1 » Mon Jun 16, 2008 5:24 pm

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*


User avatar
Marcus Tettmar
Site Admin
Posts: 7395
Joined: Thu Sep 19, 2002 3:00 pm
Location: Dorset, UK
Contact:

Post by Marcus Tettmar » Mon Jun 16, 2008 5:48 pm

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
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar

Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?

Dexter1
Pro Scripter
Posts: 64
Joined: Mon Jun 19, 2006 3:28 pm

Post by Dexter1 » Mon Jun 16, 2008 7:30 pm

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.
Thanks,
Josh

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts