VBA code in .xlsb lost after saving in v8.5.0.4

Aspose.Cells Product Family
1

Hi Aspose,


In v8.5.0.4, all VBA code in an .xlsb file is lost after merely re-saving the file. Using Alt+F11 from Excel, you can see there are VBA code in the original file, but it’s gone after saving by Aspose.Cells.

Attached is the Excel file which can reproduce the problem. Corresponding Java code:

// Open Excel file.
final Workbook workbook = new Workbook(“C:\Temp\vba.xlsb”);
// Save Excel file.
workbook.save(“C:\Temp\vba_out.xlsb”);

Please advise how we can resolve this issue. Thanks.
2

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue after executing your sample code with your source xlsb file using the latest version: Aspose.Cells
for Java v8.5.0.4. VBA code is lost when source xlsb file is saved.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

  • CELLSJAVA-41407 - VBA code in .xlsb lost after saving

3

Hi,


It is to inform you that we have fixed your issue logged earlier as “CELLSJAVA-41407”. We will perform QA and include other enhancements and fixes before publishing the fix for the users. Hopefully we will be able to provide the fix before the end of this week or so.

Thank you.
4

The issues you have found earlier (filed as CELLSJAVA-41407) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
5

Hi Aspose,


Thanks for the fix. I can confirm that VBA code is now retained for .xlsb files in v8.5.1.

However we ran into another problem regarding “unreadable content” in v8.5.1; I have created another topic about it.

Thanks.

6

Hi,

Thanks for your feedback and using Aspose.Cells.

It is good to know that your earlier issue is resolved. We have also checked your newer issue and updated you in your newer thread.