Excel VBA errors in SHarePoint

PKPNalcor 1 Reputation point
2022-08-30T17:40:30.77+00:00

I have a excel VBA code that errors when run from SharePoint but runs ok from the same file saved in the network drive. Get the run time error 'number' automation error invalid forward reference or reference to uncompiled type.

SharePoint version 2019

Same code works on SharePoint 2010 and on network drive

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,531 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,685 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tong Zhang_MSFT 9,116 Reputation points
    2022-08-31T05:58:11.647+00:00

    Hi @PKPNalcor ,

    Since our forum focus on C# code, and your issue is about SharePoint development with VBA. I recommend you to go Tech Community for some more professional help.

    If the answer is helpful, 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