realbasic-nug.de
[Top] [All Lists]

Re: Office-Automatisierung

To: REALbasic NUG German <realbasic-nug dot de at lists dot realsoftware dot com>
Subject: Re: Office-Automatisierung
From: Carsten Kobusch <carsten at merlin dot de>
Date: Mon, 21 May 2007 12:18:47 +0200
Delivered-to: listarchive at realsoftware dot com
Delivered-to: realbasic-nug dot de at lists dot realsoftware dot com
References: <E0A38F28-CB38-429C-AF60-DBE451C607F8 at andreasbe dot de> <2bf7b36227071423740d4900f142c160 at merlin dot de> <F2A522B7-C40F-4897-A4E1-772F4C53C2F6 at andreasbe dot de>

Probier mal als Mach-O-Build.. Vielleicht liegts daran..

Ansonsten muesstest Du erst einmal in Office selber testen, ob ueberhaupt die OLE-Libs installiert sind

- Word starten
- VisualBasicEditor starten
- neue Form
- eine Schaltflaeche hinzufuegen
- im ClickEvent folgenden Code einfuegen:

Dim obj as Object
Set obj = CreateObject("PowerPoint.Application")
obj.Activate

- VB-Programm starten
-> wenn nun PowerPoint startet, sind die Libs da, wenn nicht, liegt da das Problem


Hier der Orginal-Text (REALbasic-LanguageReference):

Troubleshooting

Here is a procedure to verify that the OLE libraries are installed.

One easy way is to launch Visual Basic Editor (under the Tools and Macros menu), and do some automation with VBA.

Here are the steps you can use to automate PowerPoint from Word:

Launch Word.

Launch Visual Basic Editor in Word.

Insert a UserForm.

Add a CommandButton to the form.

In the click event of the button, put in this code:

Dim obj as Object
Set obj = CreateObject("PowerPoint.Application")
obj.Activate
Run the program and click on the button.

If PowerPoint starts and you don't get any errors, then the OLE libraries are installed.


Am 25.01.2007 um 18:38 schrieb Andreas Bernhardt:


Am 25.01.2007 um 09:37 schrieb Carsten Kobusch:

1.) Welche Version RB?

rb 2007r1

2.) Liegt RB im Officeordner?

Das Programm liegt beim ausführen im Ordner Office. Da wo es vorher halt auch lag...

Grüße,

Andreas





From  Mon 21 May 2007 16:45:00 +0200
Return-Path: <realbasic-nug dot de-bounces at lists dot realsoftware dot com>
X-Original-To: listarchive at realsoftware dot com
Delivered-To: listarchive at realsoftware dot com
Received: by xmail.realsoftware.com (Postfix, from userid 1037)
        id 192DC27632CB; Mon, 21 May 2007 07:45:19 -0700 (PDT)
X-Spam-Checker-Version: SpamAssassin 3.1.1 (2006-03-10) on
        www.realsoftware.com
X-Spam-Level:
X-Spam-Status: No, score=-2.5 required=4.5 tests=AWL,BAYES_00 autolearn=ham
        version=3.1.1
Received: from lists.realsoftware.com (m.realsoftware.com [66.116.103.65])
        by xmail.realsoftware.com (Postfix) with ESMTP id D5379276325C;
        Mon, 21 May 2007 07:45:05 -0700 (PDT)
Received: from real-software-mini.local (localhost [127.0.0.1])
        by lists.realsoftware.com (Postfix) with ESMTP id 0D0D72F43EA;
        Mon, 21 May 2007 09:45:03 -0500 (CDT)
X-Original-To: realbasic-nug dot de at lists dot realsoftware dot com
Delivered-To: realbasic-nug dot de at lists dot realsoftware dot com
Received: from smtprelay07.ispgateway.de (smtprelay07.ispgateway.de
        [80.67.29.7])
        by lists.realsoftware.com (Postfix) with ESMTP id 691C42F43E0
        for <realbasic-nug dot de at lists dot realsoftware dot com>;
        Mon, 21 May 2007 09:44:59 -0500 (CDT)
Received: (qmail 6904 invoked from network); 21 May 2007 14:45:00 -0000
Received: from unknown (HELO [192.168.1.80]) (363246 at [84 dot 175 dot 102 dot 
105])
        (envelope-sender <support at monkeybreadsoftware dot de>)
        by smtprelay07.ispgateway.de (qmail-ldap-1.03) with SMTP
        for <realbasic-nug dot de at lists dot realsoftware dot com>;
        21 May 2007 14:45:00 -0000
To: realbasic-nug dot de at lists dot realsoftware dot com
Subject: Mein REALworld Bericht
From: support at monkeybreadsoftware dot de (Christian Schmitz)
Date: Mon, 21 May 2007 16:45:00 +0200
Message-ID: <1hyh2g2 dot 10djfew12sa918M%support at monkeybreadsoftware dot de>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Organization: Monkeybread Software Germany
X-Face: nrf3>{WQ6c&r+7 at e)"]0G60`-6ND^)I2mI%>)QGYa=9"=7jhd-g2|b3!>Al0+
        Ccb%xGQshhi|g at QU2$
User-Agent: MacSOUP/D-2.8 (Mac OS X version 10.4.9 (PPC))
X-BeenThere: realbasic-nug dot de at lists dot realsoftware dot com
X-Mailman-Version: 2.1.9
Precedence: list
Reply-To: REALbasic NUG German <realbasic-nug dot de at lists dot realsoftware dot 
com>
Sender: realbasic-nug dot de-bounces at lists dot realsoftware dot com
Errors-To: realbasic-nug dot de-bounces at lists dot realsoftware dot com

Hi,

ich war bei der REALworld und durfte einen kleinen Bericht schreiben:

<http://www.macwelt.de/news/software/346011/index1.html>

Schaut mal rein.

Gruß
Christian

--
Around twelve thousand functions in one REALbasic plug-in. The Monkeybread Software Realbasic Plugin v7.2. Now universal!
<http://www.monkeybreadsoftware.de/realbasic/plugins.shtml>


<Prev in Thread] Current Thread [Next in Thread>
  • Re: Office-Automatisierung, Carsten Kobusch <=