search

Beakerboy / MS-OVBA

Create a vbaProject.bin file from VBA source files.
15 stars 3 forks source link

Sources #1

Closed Beakerboy closed 1 year ago

Beakerboy commented 1 year ago
sancarn commented 1 year ago

A key image I've not seen before but explains significantly better how the VBA project is built.

image

Found here. Assume the VBA projects generated from this project will contain no SRP streams.

@Beakerboy have you investigated whether the frx files map directly to the Form Designer owned storages / streams? My guess is they would but I'm not sure... Though in an ideal world (long term aspiration) we'd likely not use FRX and instead use some JSON based form representation...

Beakerboy commented 1 year ago

I've extracted the vbaProject.bin files from a few of my published xlam files, and at least one of them has SRP steams

Beakerboy commented 1 year ago

@sancarn if you wanted to help, I just created an object called Project. It seems to contain metadata for the project and some info on each of the code-containing files in the project. I have an example of what the file looks like as text here. The data is uncompressed, and in the bin file here at offset 2400. We need to know what these values are and if they need to be provided by the user, or calculated by the module.

The class file is kind of pseudo-codey right now. I need to google how to make inline objects for the modules list.

Beakerboy commented 1 year ago

Moving this list to discussions