I need a macro that I can assign to a toolbar button that
when clicked will lauch Access with a specific file open
and the Access application window maximized if at all
possible.  I'm currently using
ActiveDocument.FollowHyperlink Address:= "D:\mydata.mdb"
because I don't know of a better way to open another
file\app.  This is opening the file but not maximizing the
window.  Any other (better) suggestions for opening the
file and getting it to maximize??  I need this to work in
both 97 and XP if that makes a difference.  Thanks.

Hi Kevin,

Take a look at the SHELL function in the general Office VBA
Help.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)