Max Wanadoo
max.wanadoo at gmail.com
Wed Apr 1 11:49:09 CDT 2009
Susan, If you want to email me the word doc with all the stuff stripped out apart from the bit you are testing, I can give it a go as I have 2007 office. Max DOT wandoo AT gmail.com Once you have set a reference it has "access" to all the code in that library so it should work or else throw an error which should be Google'able (have I just invented a new word?) Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: 01 April 2009 17:38 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Getting error of Ribbon argument I can't recall ever using DoCmd in anything but Access -- and as part of the Access object model, it would makes sense that it isn't available to other applications, but thought I'd try. I've spent a little time in both Excel and Word's VBA Help and can't find anything helpful on hiding the ribbon -- even the Object Browser turns up nothing. Well, it turns up stuff, just nothing I could use. Surely you can hide the ribbon programmatically in Word and Excel? Susan H. > Hi Susan, > I don't know the answer but if you set a Reference to Microsoft Access 12 > Object Library then it will probably compile ok. > > Whether it works or not is another matter > > hth -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com