Previous employees at the company I work at packed a customer data files into a single CAB file, for that companies data. Then the employees had this brilliant idea of using some arcane naming convention, that has no relation to anything that is going on today. My job is now to break the cab files open, read one of the files, and then rename the CAB to something that makes sense, like the customer's name. There are over a 1K+ of CAB files, so I want to automate it.
I can do all the rest except I'm getting stuck is how to open the CAB file with VBA.
I found reference to this VB6 cab
That's from https://www.experts-exchange.com/Q_24770217.html#a25449768
Anyone know how to incorporate the VB6 code into a VBA module in Access? Or does anyone have other solutions?