Originally Posted by
TheShabz
Hi everyone.
I'm working on a workflow db that has multiple processes, each of which outputs multiple excel docs. This will be a very commonly used db which will have anywhere from 100-50k+ records in each run. I want to be able to save these resulting tables for archival purposes. Obviously, my db will exceed the 2gb max very quickly. A possible solution I have come up with is to have archive dbs that will store these tables. While I am able to open another db and save a table into it with VBA, I'm not able to figure out how to manipulate the folders with VBA. For example:
Has anyone ever done something like this? Some tips would be appreciated