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.