Relative Content

Tag Archive for vba7

Need to be able to parse data from multiple user selected files

Hoping to get some help. I’m working with an older established Macro that would open the file browser and allow the selection of multiple files and then parse specific data from them into an excel sheet. I have updated it the best I can and will function except it will only transfer data from the last file selected. What I need is to be able to select multiple files and have it write a new Row for each file. Below is the code I’m using