How to return to runtime version of Access from Excel

M

Mo

I have an Access 97 application that outputs to Excel and sometimes I have a
need to return to Access to display a message. I was able to get this
working using Create Object (,"Excel.Application") and GetObject(,
"Excel.Application". I was returning to Acces using 'AppActivate "Microsoft
Access". This was working well on my machine but my users run the
application from Access Runtime and get the message "invalid procedure or
object" when it hits the "AppActivate "Microsoft Access" code once Excel has
been opened. Any hints on how to eliminate this problem would be most
appreciated. Thanks
 
Top