Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [platform-swt-dev] swt ole and ExcelMacroSheet

Hi Max,
Please use SWT community forum: https://www.eclipse.org/forums/index.php/f/100/  for such queries.
This mailing list is meant for developers discussions.

Thanks,
Niraj


From:        Lerchenmüller Maximilian <m.lerchenmueller@xxxxxxxxx>
To:        "platform-swt-dev@xxxxxxxxxxx" <platform-swt-dev@xxxxxxxxxxx>
Date:        12/12/2014 03:56 PM
Subject:        [platform-swt-dev] swt ole and ExcelMacroSheet
Sent by:        platform-swt-dev-bounces@xxxxxxxxxxx




Dear Community Members,
I’m trying to open up an ExcelMacroSheet (.xlsm) with swt.
The Sheet is opened and displayed correctly. But there is a Macro in the Sheet which is called on Workbook_Open(). There the Macros craches, because it can’t find ActiveWorkbook.Path and  ActiveWorkbook.Name.
The ActiveWorkbook Variable doesn’t seem to be set.
 
Also if opened via OleClientSite it seems that there is created an copy of the VbaProject in the workbook every time it gets opened.
 
Can anybody please help?
 
 
Here goes the current code:
 
        Display display = new Display();
        final Shell shell = new Shell(display);
        shell.setText("Excel Demo");
        shell.setSize(640, 480);
        shell.setLayout(new FillLayout());
        frame = new OleFrame(shell, SWT.NONE);
 
        clientSite = new OleClientSite(frame, SWT.NONE, "Excel.SheetMacroEnabled.12", new File(“FILEPATH”));
        clientSite.doVerb(OLE.OLEIVERB_UIACTIVATE);
        shell.open();
       
        shell.addDisposeListener(new DisposeListener()
        {
            public void widgetDisposed(DisposeEvent event)
            {
               
               
                 MessageBox messageBox = new MessageBox(shell, SWT.YES | SWT.NO);
                 
                 messageBox.setText("Achtung");
                 messageBox.setMessage("Änderungen abspeichern");
                 int buttonID = messageBox.open();
                 switch(buttonID)
                 {
                   case SWT.YES:
                                  clientSite.save(new File(fileName), true);
                                  break;
                   case SWT.NO:
                     // exits here ...
                     break;
                 }
            }
        });
        while (!shell.isDisposed())
            if (!display.readAndDispatch())
                display.sleep();
        clientSite.deactivateInPlaceClient();
        clientSite.dispose();
 
 
Thanks in advance,
Max

 

MIT der Nachricht versandtes Bild (Inline-Image)
   
Otto Bihler Maschinenfabrik GmbH & Co. KG
Lechbrucker Str. 15
87642 Halblech
Deutschland
http://www.bihler.de
 
Maximilian Lerchenmüller
IT/Business
 
Tel: +49-8368/18-226
Fax: +49-8368/18-181

Ust-ID-Nr.: DE 128 288 234
Sitz Halblech, Registergericht Kempten, HR A 325
Persönlich haftende Gesellschafterin:
Otto Bihler Maschinenfabrik Verwaltungs-GmbH,
Sitz Halblech, Registergericht Kempten, HR B 2981
Geschäftsführer: Mathias Bihler, Manfred Grundner

Bitte beachten Sie, dass dies eine urheberrechtlich geschützte, vertrauliche Mitteilung ist. Wenn Sie nicht der richtige Adressat sind, oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte den Absender und löschen Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail und der darin enthaltenen Informationen sind nicht gestattet.

Jede von uns versendete E-Mail ist virengeprüft. Dennoch schließen wir, außer für den Fall von Vorsatz oder grober Fahrlässigkeit, die Haftung für jeglichen Verlust oder Schäden durch virenbefallene Software oder E-Mails aus.

_______________________________________________
platform-swt-dev mailing list
platform-swt-dev@xxxxxxxxxxx
To change your delivery options, retrieve your password, or unsubscribe from this list, visit
https://dev.eclipse.org/mailman/listinfo/platform-swt-dev


Back to the top