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 wb.Close True MsgBox wbname & " Workbook saved" End Sub
|Add a range in an Excel graph||5||36|
|Dlook problems updating an unbound textbox from a table with criteria from another unbound textbox||3||17|
|I don't want to use Fn or Fn lock for F1 to F11 key on a Lenovo t460p laptop||13||39|
|Excel error Could not load some object becuae they are not available on this machine||5||7|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!