Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.
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) .......
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.