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) .......
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
14 Experts available now in Live!