I'm having trouble figuring out how to set this up to automatically loop through our hundreds of .xlsm files and export the code from each. I know how to open files automatically using the file system object technique, but I'm hitting a wall trying to integrate that method with the vbaDeveloper code. I want to adapt the program to (one-by-one) 1) open every xlsm file in a folder 2) automatically export all of the objects and modules from each file 3) close the file without saving and 4) open the next file until all files in the folder have been processed.
Also, many of these xlsm files have Workbook Open events that I don't want to execute during the process of capturing the object and module code. I found some guidance online on how to set this up, but if you have a simple solution that is known to work with vbaDeveloper, this would be very helpful.
Hello and thanks for creating this.
I'm having trouble figuring out how to set this up to automatically loop through our hundreds of .xlsm files and export the code from each. I know how to open files automatically using the file system object technique, but I'm hitting a wall trying to integrate that method with the vbaDeveloper code. I want to adapt the program to (one-by-one) 1) open every xlsm file in a folder 2) automatically export all of the objects and modules from each file 3) close the file without saving and 4) open the next file until all files in the folder have been processed.
Also, many of these xlsm files have Workbook Open events that I don't want to execute during the process of capturing the object and module code. I found some guidance online on how to set this up, but if you have a simple solution that is known to work with vbaDeveloper, this would be very helpful.
Thanks!