Excel Files with VBA Macros Stored on SharePoint

[Guest]

Hi All,

Does anyone know a good resource to tell me how to modify my VBA macros when
my Excel speadsheets are being stored on a SharePoint Site?

My macos execute fine when the Excel files are stored on a local drive or a
fileshare. But when the files are stored on a SharePoint site, the macros no
longer function correctly.

This is the code the Debugger flags as the problem:

Workbooks.Open SourcedatatableFull
Workbooks(Sourcedatatable).Activate
Set myObject = Workbooks(Sourcedatatable).Worksheets("Sheet1")
SourceTableOpen = True

Thanks!