It's actually because your application has to be in the same folder as the Microsoft Office Automation libraries which are included in MS Office. That is what is stored in the "Office" folder in MS Office. Whenever an RB application is compiled to a format that produces a bundle, your actual application file does not reside in the Office folder - it now resides in a sub-folder within the bundle inside the Office folder and thus cannot get access to the Automation libraries. (At least that's my understanding of it.)
Bundles are basically folders that have the bundle bit set. When the bundle bit is set the OS makes the entire folder and its contents look like a single application file. This is why projects that use Office Automation can never be Universal Binaries. The "fix" for this is when Microsoft releases the new Office for Mac and supplies a (hopefully) robust library for AppleScript. MS has decided that AppleScript will be the preferred communication channel with Office for Mac. Greg On Mar 13, 2007, at 12:37 PM, Robert Carroll wrote: > Hi, > > I am also setting up some simple excel automation with RB 5.5.5 > (Mac). All was running fine until I switched my build settings from > Pef to Mach-O. > > With a Mach-O build running in the debugger, I get the following OLE > error message: > > "no automation server present" > > the same code running in RB 2007 demo gives "OLE not supported on > this platform" > > Once I switch back to Pef in either version of RB, the file works as > expected. > > Is this because of the relatively early version of Excel (10) I have > installed, or is it something built into RB's excel capabilities? > > thanks > > Robert Carroll > Toronto > _______________________________________________ > Unsubscribe or switch delivery mode: > <http://www.realsoftware.com/support/listmanager/> > > Search the archives: > <http://support.realsoftware.com/listarchives/lists.html> > > -- Greg Kraus President LecShare, Inc. Cary, NC 919.300.7512 (voice) 919.882.1275 (fax) http://www.lecshare.com _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
