Page 1 of 1
Format xlsm
Posted: Thu Nov 16, 2023 1:35 pm
by coheris
Hello,
We use the XLSReadWritwII dll for export our datas to xlsx.
Is it possible to associate a xlsm model format to generate a xlsx format ?
If yes, can you explain me how its possible ?
If no, how can you make this ? Another dll ? Special procedure ?
Thanks for yous answers.
Best regards,
Re: Format xlsm
Posted: Mon Nov 27, 2023 9:47 am
by larsa
Hello
Do you want to create a macro enabled file (XLSM)? You can't do that. Creating macros is not supported.
Re: Format xlsm
Posted: Mon Nov 27, 2023 11:27 am
by coheris
Hello,
Let me explain my question.
We have a software who can make a connection on a database.
After we can make a query and send the result in a report.
This report can make a export in severals files like xls, xlsx, pdf, ...
Since xlsx macro are forbidden.
To make macro we must use xlsm or xltm.
Our software use a template containing a macro and insert this macro in the result file.
There was not problem when the file format was xls.
Now we must use a template xlsm or xltm as template and to generate the final file.
My Question is :
Can we generate a xlsm or xltm file with XLSReadWrite ?
Same question for used a template
Thanks a lot for your answers
Re: Format xlsm
Posted: Tue Dec 05, 2023 2:35 pm
by coheris
Hi,
Do you have any news about this issue ?
Best regards.
Re: Format xlsm
Posted: Mon Dec 18, 2023 11:38 am
by coheris
Hi,
Do you have any news about this issue ?
It's critical.
Best regards.
Re: Format xlsm
Posted: Wed Dec 20, 2023 9:46 am
by larsa
Hello
1. You can't create an empty file with macros.
2. If there are macros in a template file they will be preserved in the output file.