Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
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.
What's the absolute simplest way to replace my 3 "For..Next" lines and achieve the same result? They're all ".xls" files if that makes it any simpler.
Sub DoItAll() Dim iPath As String, iFile As String, i As Long iPath = "H:\Depts\css\A_ILS & Reliability\Reliability\1-CURRENT\System Reporting\SDAE\KAL\2013\Originals Data Files\330_09~03\" For i = 3 To 16 Workbooks.Open Filename:=iPath & ThisWorkbook.Sheets("Sheet1").Cells(i, 10).Value Next i ThisWorkbook.Activate Sheets("All Files").Activate Call AggregateFiles End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|compare column in an Excel spreadsheet.||1||42|
|Outlook 2013 Contacts - comma-separated-field||20||35|
|Target.Address conflict in Excel VBA||3||22|
|loading data from a spreadsheet into an array or equivalent and retrieving data using key value||7||21|