Why is my MFC DLL project missing many interfaces when adding EXCEL library?

Arthur Zeng 0 Reputation points
2023-04-13T07:09:17.6933333+00:00

Why is my MFC DLL project missing many interfaces when adding EXCEL library? For example, _Application, _Workbook, _Worksheet, Workbooks, Worksheets, Range... None of these, so I can't use them right now. How can I solve this? Please help me. Thank you. Is there any MFC DLL using EXCEL com interface related documentation tutorial? If anyone has one, please send it to me. Thank you!vs

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,888 questions
C++
C++
A high-level, general-purpose programming language, created as an extension of the C programming language, that has object-oriented, generic, and functional features in addition to facilities for low-level memory manipulation.
3,636 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,720 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Minxin Yu 11,026 Reputation points Microsoft Vendor
    2023-04-18T08:53:24.1333333+00:00

    Hi,

    VS2022 can add these interfaces, but not 2019

    Glad to know that VS2022 and Microsoft Excel 16.0 Object work for you. For problems about VS2019, I found a fix for add class:https://developercommunity.visualstudio.com/t/MFC-Long-list-of-errors-generated-when/1588036 Please consider using VS2022 instead of VS2019. Best regards, Minxin Yu


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments