Format xlsm

[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,

[larsa]

Hello

Do you want to create a macro enabled file (XLSM)? You can't do that. Creating macros is not supported.

[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

[coheris]

Hi,

Do you have any news about this issue ?

Best regards.

[coheris]

Hi,

Do you have any news about this issue ?

It's critical.

Best regards.

[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.