Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.
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
22 Experts available now in Live!