Exporting data from xls protected file to External Excel file

How can we Export data from many projects created by one xls protected file to an External One Excel file to develop One report sheet showing the data from those projects.
Regards

You can use the “XLS padlock VBA API extension”

Search in the XLS Padlock guide: “Allow saving non encrypted workbooks”

1 Like

Use the VBA API posted here: