Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Standard Widget Toolkit (SWT) » swt ole and ExcelMacroSheet(Trying to open an *.xlsm File with Macro in Workbook_Open())
swt ole and ExcelMacroSheet [message #1511742] Mon, 15 December 2014 06:04 Go to next message
Maximilian Lerchenmüller is currently offline Maximilian LerchenmüllerFriend
Messages: 1
Registered: December 2014
Junior Member
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?

Code in Attachmenent.

Thanks in advance,
Re: swt ole and ExcelMacroSheet [message #1776219 is a reply to message #1511742] Tue, 14 November 2017 05:42 Go to previous message
Daniel Migowski is currently offline Daniel MigowskiFriend
Messages: 1
Registered: July 2009
Junior Member
Hello Maximilian,

since you have worked with XLSM files, how did you get around the macro security warning asked each time by excel, even when the macro enabled excel file resides in a trustworthy location?

Evenrytime I want to open such a file Excel comes along and askes me about the macros in it.

Thanks in advance,
Daniel Migowski
Previous Topic:Is it possible to make a dropdown SWT Menu scrollable?
Next Topic:Linux Preview is Blank
Goto Forum:

Current Time: Mon Apr 19 01:27:26 GMT 2021

Powered by FUDForum. Page generated in 0.02080 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top