When will Microsoft fix the Mac Office CreateObject problem

Peter Jamieson 116 Reputation points
2020-07-14T21:20:32.937+00:00

When you try to use Mac Word VBA to automate Excel, there is a problem because when you use

Dim xapp As Object
Set xapp = CreateObject(-Excel.Application-)

*NB, I had to use a - instead of a double quotation mark because your web interface rejected double quotation marks.

if xapp is returned at all, it actually returns an Excel.Workbook object.

So it is possible to work around that, but what I would like to know is when is Microsoft going to fix the problem, or document a solution if that is what is required.

Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
514 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 25,626 Reputation points Microsoft Vendor
    2020-07-15T05:42:45.827+00:00

    Give a feedback to Office Developer UserVoice forum

    This is a way for users give feedback to Microsoft when using Microsoft products.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.