I'm trying to open in edit mode, save, and then close an Excel File on SharePoint Using a Macro within another Excel file.
Here is the code I have been able to piece together so far. It only opens the workbook on the sharepoint, but it opens in read only mode, and it does not save and close.
Can someone help me fill in what I'm missing?
Dim xlApp As Excel.Application
Dim wb As Workbook
Dim xlFile As String
xlFile = "http://sharepoint/sites/MYD_18434/Report%20Library/Bankruptcy/BK%20Timely%20Setup%20Removal%20Daily%20Report/Bk%20Timely%20Setups%20Removals%20Dashboard.xls"
'Open Excel File.
Set xlApp = New Excel.Application
xlApp.Visible = True
Set wb = xlApp.Workbooks.Open(xlFile, , False)
MsgBox wb.Name & " Workbook saved"