Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Files with VBA Macros Stored on SharePoint
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! -- Jane |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Preview Excel 2007 files in Outlook from SharePoint | Excel Discussion (Misc queries) | |||
Wht can't I open Excel files from Sharepoint any more? | Excel Discussion (Misc queries) | |||
Excel links & SharePoint 3.0 (worked fine with SharePoint 2.0) | Excel Discussion (Misc queries) | |||
XP Excel program changes all my files to not duplex as stored | Setting up and Configuration of Excel | |||
Excel files stored on a different server | Excel Discussion (Misc queries) |