Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
combining data from other worksheets to master sheet
You can paste this code into a module in a copy of the master worksheet to test. It should copy c6:c307 into a new column from the newest file. Function MostRecentFile(fldr) 'This uses late binding, so a reference 'is not required. 'Note that there is no error coding - it 'should be added...- Remou
- Post #7
- Forum: -Engineering spreadsheets
-
combining data from other worksheets to master sheet
The most recent file in a folder can be found using the FileSystemObject: Function MostRecentFile(fldr) 'Reference: Microsoft Scripting Runtime Dim f As File, fl As Folder, fs As FileSystemObject Dim fd As Date Dim fname As String Set fs = CreateObject("Scripting.FileSystemObject")...- Remou
- Post #2
- Forum: -Engineering spreadsheets
-
Hotkeys: alt + ?
Charmap.exe should be available if you are running Windows, Start->Run->Charmap.exe.- Remou
- Post #4
- Forum: Computer engineering general discussion
