Programmatically Exporting VBA Project Modules Doesn’t work
I’m writing a macro to automatically export the code modules. I’m adapting code I found here: /questions/62744015/how-to-programmatically-export-and-import-code-into-excel-worksheet. I have a command button on a worksheet to initiate the process. I like to group my exports by type; a folder for worksheets, forms, modules, and classes. The problem is the code runs without error but does not actually export or do anything from what I can tell. I do realize that there are more backups than I need. It’s an silly office process to back up in a couple of locations. Anyway, any help would be greatly appreciated.