> I am trying to open up a different database w/ vba.  I am
> aware of the hyperlink property, but I need some code to
> run before it opens the database so it is not possible to
> use in this instance.  How do I run/launch (not connect)
> another database from a vba?

>-----Original Message-----


>> I am trying to open up a different database w/ vba.  I
am
>> aware of the hyperlink property, but I need some code to
>> run before it opens the database so it is not possible
to
>> use in this instance.  How do I run/launch (not connect)
>> another database from a vba?

>Look in help for Shell() command.

>BTW, if you want to run code before opening the second
instance, you can
>still use hyperlinking.  Just use . . .

>some code
>some more code
>Application.FollowHyperlink "PathToFile"

>.