Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
Sub Import_worksheet() Dim customerBook As Workbook Dim filter As String Dim caption As String Dim customerFilename As String Dim customerWorkbook As Workbook Dim targetWorkbook As Workbook ' active workbook is the target Set targetWorkbook = Application.ActiveWorkbook ' get the customer workbook filter = "Excel files (*.xlsx),*.xlsx" 'The open dialog is to point to the following path as a constant: C:\MyFile\Data caption = "Please Select an input file " customerFilename = Application.GetOpenFilename(filter, , caption) If customerFilename = False Then MsgBox "No File specified.", vbExclamation, "ERROR" Exit Sub Else 'Filter should be only xls and xlsx files ' If Cancel is pressed then abort the whole macro Set customerWorkbook = Application.Workbooks.Open(customerFilename) .......