Open an Excel file from SharePoint site

by

Try this code to pick a file from a SharePoint site:

Dim SummaryWB As Workbook
Dim vrtSelectedItem As Variant

With Application.FileDialog(msoFileDialogOpen)
    .InitialFileName = "https://sharepoint.com/team/folder" & "\"
    .AllowMultiSelect = False
    .Show
    For Each vrtSelectedItem In .SelectedItems
        Set SummaryWB = Workbooks.Open(vrtSelectedItem)
    Next
End With

If SummaryWB Is Nothing then Exit Sub

If I remember correctly, the Microsoft Scripting Runtime reference must be enabled. Also, your site may use backslashes, mine uses forward slashes.

More Related Contents:

  1. VBA – How to grab the cell below if a cell has text?
  2. Getting ScriptControl to work with Excel 2010 x64
  3. Pop up the Excel Statusbar?
  4. Get list of Excel files in a folder using VBA [duplicate]
  5. When one should use Set [e.g for SpecialCells return value]?
  6. Should I turn .CutCopyMode back on before exiting my sub procedure?
  7. Determine if cell contains data validation
  8. Sheet protection: UserInterFaceOnly gone
  9. VBScript – How to make program wait until process has finished?
  10. How to highlight a cell using the hex color value within the cell?
  11. Removing special characters VBA Excel
  12. VBA recognizing workbook by partial name
  13. Excel VBA wildcard search
  14. How do I loop an excel 2010 table by using his name & column reference?
  15. Excel VBA Project has generated multiple Workbook objects
  16. Copy an entire worksheet to a new worksheet in Excel 2010
  17. to make this code simpler
  18. Excel VBA deleting rows in a for loop misses rows
  19. Embed picture in outlook mail body excel vba
  20. How to check for empty array in vba macro [duplicate]
  21. What is the function of FormulaR1C1?
  22. How to send files via HTTP_POST with Excel using VBA?
  23. VBA to open Excel hyperlink does not work when hyperlink generated with a formula
  24. How to Add Date Picker To VBA UserForm
  25. Vba macro to copy row from table if value in table meets condition
  26. How to create dynamic variable names VBA
  27. Read VBA macros (or vbaProject.bin) of an Excel file without opening it in MS Excel [closed]
  28. simple vba code gives me run time error 91 object variable or with block not set
  29. Calling regasm without administrative rights for COM interop in Excel VBA
  30. Is there a way for DIR(path) in VBA to handle strings longer than 260?

Leave a Comment