Timeline for Looping through Files in a Folder
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 7, 2016 at 12:23 | vote | accept | Doug Coats | ||
| Mar 2, 2016 at 12:48 | comment | added | Raystafarian | @DougCoats you can use something like this if you always use the same sheet name and cell range. | |
| Mar 1, 2016 at 11:34 | comment | added | RubberDuck | You connect to it via ADODB @DougCoats. | |
| Mar 1, 2016 at 9:47 | history | edited | Kaz | CC BY-SA 3.0 | added 1 character in body |
| Feb 29, 2016 at 17:40 | comment | added | Kaz | If you want to read the data without actually opening the workbook? That's a good question. I'm not very familiar with doing that myself. I recommend googling around and looking through SO. | |
| Feb 29, 2016 at 17:06 | comment | added | Doug Coats | Original OP here. I didnt know I could get all this information without opening the workbooks. I am still new at this. What is the generic syntax to be able to do that? I didnt think to load the copy'd information into an array, so that is actually a really good idea. | |
| Feb 29, 2016 at 16:45 | history | answered | Kaz | CC BY-SA 3.0 |