Windows cannot open this file Dialog Box

[Guest]

Hello,

Through My Computer if you try to opne a file where the extension is not
registered with a program to open it, you get this Msgbox to then choose from
a list.

Is their a way through VBA Code to bring this up & work with it, etc.

I know the Windows common Dialog box can with API calls. What can be done
with this one ?

Any help would be greatly appreciated.

Thank you,
Jeff

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/api/api0018.htm at "The Access
Web"

It's that bit of code:

Shell("rundll32.exe shell32.dll,OpenAs_RunDLL " _
& stFile, WIN_NORMAL)

 

[Guest]

Thank you Doug !!

This was very helpful !

Jeff

Take a look at http://www.mvps.org/access/api/api0018.htm at "The Access
Web"

It's that bit of code:

Shell("rundll32.exe shell32.dll,OpenAs_RunDLL " _
& stFile, WIN_NORMAL)