Giter Site home page Giter Site logo

Comments (4)

nicholasdgoodman avatar nicholasdgoodman commented on July 17, 2024

The VBS and .EXE installer make the 32-bit / 64-bit determination based upon the following documentation provided by Microsoft:

Can you verify the output that is generated from running the following VBA Macro within Excel:

Sub GetProductCode()

Debug.Print Application.ProductCode

End Sub

from excel-api-example.

msz avatar msz commented on July 17, 2024

I don't seem to be able to open VBA Editor in that Excel - the button is greyed out. However, the product code I gave you comes directly from the installer script - I added a print statement within it. Running your macro in another version of Excel 2016 gives {90160000-000F-0000-0000-0000000FF1CE}, which is the same as the output from that print statement in the installer script. So I'm pretty sure the Application.ProductCode for the Excel that does not work is {9AC08E99-230B-47e8-9721-4577B7F124EA}.

from excel-api-example.

nicholasdgoodman avatar nicholasdgoodman commented on July 17, 2024

The GUID you have supplied appears show up in the registry (on my machine, at least) as the value:
PackageGUID

for the following key:
HKLM\SOFTWARE\Microsoft\Office\ClickToRun

Having only brief exposure to the MS Office Click-to-Run feature my suspicions are that the machine in question has not performed a full install of Excel, but rather currently has a partial install, with specific features such as VBA automation missing.

from excel-api-example.

msz avatar msz commented on July 17, 2024

A proper reinstall fixed the issue, so you were probably correct. Thanks!

from excel-api-example.

Related Issues (7)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.