Excel on Mac - add the MS HMTL object library VBA reference not possible

You can't do that on a Mac, only on a Windows PC.

Geht halt nicht, tut mir leid, da läßt sich nichts machen.

Andreas.

Hallo TobiasEierund,



Macros werden nicht von uns unterstützt, sondern von den Kollegen
hier.



Hier habe ich einen Tipp für Dich gefunden:



"To use early binding, you first need to set a reference to the Outlook object library. Use the Reference command on the Visual Basic for Applications (VBA) Tools menu to set a reference to Microsoft Outlook xx.x Object Library, where xx.x represents the
version of Outlook that you are working with. You can then use the following syntax to start an Outlook session."



Bedanke mich für Dein Verständnis.



Mit freundlichen Grüßen,



Desislava Dimova



Microsoft Office 365 Support Engineer

Bitte markieren Sie diese Antwort als ‚überprüft‘, wenn diese Ihnen weiterhelfen konnte, so dass auch andere Teilnehmer von der Lösung profitieren können. Die Teilnehmer, die die meisten Antworten zur Verfügung stellen, erhalten
ein ‚Antwort-Abzeichen‘.

Sascha,

For reference, this is an English language forum so please translate before you post.

For anyone who wishes to respond, this is the translated version of Sascha's post.

Dear Sir or Madam,

In the MS project there is the function to export reports in Excel or Visio. The Visio export works without difficulty. However, exporting to an Excel file does not work. When trying to export a report to Excel, the following error message appears:

XML for Analysis (XMLA) parser: The Localeldentifier property is not overwritable. The property can not be assigned a new value.

The program MS-Project is only recently installed on my PC (Win 10). The mistake has been made since the beginning.

On my computer I installed the products Office 2016 and MS Project 2016

John

The R1C1 reference style can only be set on application level, not at workbook level.

Means this setting affects all files!

At first, delete your template Book.xltx then do as follows:

Close Excel

Open Excel

Open File\Options\Formulas and check the option "R1C1 Reference Style"

Close Excel

Open Excel

If the reference style is back to A1 you have other workbooks that are loaded at startup, e.g. PERSONAL.XLSB

Click View\Unhide window and make the hidden workbook visible

Open File\Options\Formulas and check the option "R1C1 Reference Style"

Click View\Hide window and the hide the workbook

Close Excel

When Excel asks you to save the PERSONAL.XLSB choose Yes

Open Excel

Andreas.

Hallo,

schau mal im VBA-Editor unter Extras => Verweise welche Verweise da gesetzt sind.

Normal sollten gesetzt sein:

• Visual Basic for Applications
• Microsoft Excel 14.0 Object Library
• Microsoft Office 14.0 Object Library
• OLE Automation

Mit freundlichen Grüßen

Claus