Feature request: workbook_add_vba_project()

[jmcnamara]

Add workbook_add_vba_project() function like the Python XlsxWriter Workbook method add_vba_project().
See https://xlsxwriter.readthedocs.org/index.html

• Difficulty: 3 (Easy 1 - 5 Hard)
• Priority: 3 (High 1 - 5 Low)

Add +1 as a comment to vote for this feature and to get an update when it is implemented.

If you would like to make a donation to accelerate this feature you can do so via PayPal or contact me directly. Currently $0 of $300.

[nelson2005]

+1

[jmcnamara]

Since I've had a few requests about this I've added a note about making donations to prioritize this feature.

[jmcnamara]

I've pushed an initial version of this to master. You will have to use the Python vba_extract utility (installed with xlsxwriter) for now.

Here is an example:

#include "xlsxwriter.h"

int main() {

    lxw_workbook  *workbook  = new_workbook("test_macro01.xlsm");
    lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);

    workbook_add_vba_project(workbook, "vbaProject01.bin");

    worksheet_write_number(worksheet, CELL("A1"), 123 , NULL);

    return workbook_close(workbook);
}

[jmcnamara]

Added docs and an example file.

[jmcnamara]

Added in version 0.8.7. See https://libxlsxwriter.github.io/working_with_macros.html