How can I adapt the code below that is currently working in Excel to work in a macro module in Access 2007 to open an excel file in SharePoint in edit mode, save it, then close it.
Here is the Excel VBA that is working which MWGainesJR recently helped create:
Private Sub Workbook_Open()
Dim wb As Workbook
Dim xlFile As String
Dim wbname 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 wb = Workbooks.Open(xlFile)
wbname = wb.Name
MsgBox wbname & " Workbook saved"