I’m developing a new Userform control for Excel the “Virtual Forms for Excel”
It’s an ActiveX control.
For now, this control is storing it’s data to a separate file that is in the same folder as the ExcelWorkbook.xlsx file.
I’m thinking to convert this data to xml format and to embed this xml file in the xlsx file (if it is not allowed to embed my custom .vf file) so that users don’t need to take care of this additional file when they want to share their workbook with virtual forms with other users.
What are the best practice to store this custom xml (or maybe custom vf) files, if what folder in the xlsx?
You can certainly embed custom XML files in an XLSX.
If you don’t want to convert to XML format, you could convert your file to base64 encoded ascii, and put that in a simple XML file. This would probably entail almost no work at all for you.
You can put the custom XML file in the root directory of the XLSX, or you can create your own subdirectory, and put the custom XML file there. It probably would be a little neater to put it into your own subdirectory.
You must be logged in to reply to this topic.