[AccessD] Need Open File Dialog Box

Bill Benson bensonforums at gmail.com
Wed Aug 8 00:48:12 CDT 2018


Can you write some code to create the reference on the fly with On Error
Resume Next? That is what I do in Excel. Just keep adding references by
GUID until one of them "sticks". But it is a good observation.

On Tue, Aug 7, 2018 at 8:46 PM, Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> The gotcha will be when you  distribute your application.
>
> Office.FileDialog relies on a reference to the Microsoft Office Object
> Model library, which is
> version specific.
>
> So it will be problematic if you build  in one version of Office and run
> it in another (especially if
> you are distributing an accde!)
>
>
> On 7 Aug 2018 at 16:38, Rocky Smolin wrote:
>
> > David:
> >
> > I fixed it by using the Office.FileDialog object.  Simple and
> > effective.  So far.  Don't know what kind of gotchas accrue to this
> > object but it's working. :)
> >
> > Best,
> >
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list