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

Microsoft 365 and Office | Development | Other
Developer technologies | C++
Developer technologies | 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.
Developer technologies | Visual Studio | Other
Developer technologies | Visual Studio | Other
A family of Microsoft suites of integrated development tools for building applications for Windows, the web, mobile devices and many other platforms. Miscellaneous topics that do not fit into specific categories.
{count} votes

1 answer

Sort by: Most helpful
  1. Minxin Yu 13,506 Reputation points Microsoft External Staff
    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

Your answer

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