We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
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
|Update target table column value when source table column value is different||3||13|
|Excel hyperlinks - add custom and dynamic text to email body||2||29|
|Compare data between two sheets in Excel||6||30|
|Excel - Data Validation - Dynamic Weekday||9||16|