I'm looking for a VBA macro to do the following:
- given a specific path, search all folders and subfolders and extract text from all files named "contact.txt"
- for each .txt file insert the content into a new row under column A and its path into column B
These solutions the closest to what I'm trying to achieve
- given a specific path, search all folders and subfolders and extract text from all files named "contact.txt"
- for each .txt file insert the content into a new row under column A and its path into column B
These solutions the closest to what I'm trying to achieve
Compiling data from multiple excel files in multiple subfolders into one worksheet
I hope im on the right track. Im trying to compile data from multiple files in multiple sub folders within a directory. The code appears the hang up when trying to imbed the information into the "pull from ri" sheet. Not sure what im missing here. Sub sample() Dim FileSystem As Object...
www.mrexcel.com
Macro to extract text from .txt file into Excel
Hi, I'm completely new to macro building but here goes: I would like to extract info from an external txt file into Excel. For example: txt file: /* ----------------- Dummy ------------------- */ JobName: Dummy send_notifications: y max_runs: 5 /* ----------------- TAF-O-FF401D...
www.mrexcel.com