how to use xlsm in report generation toolkit

[framework]

Hi,

I'm using Labview 8.6 with Report Generation Toolkit 1.1.4.  I'm trying to use an xlsm file as my template to create a new report, modify a few cells, and then save it as an xlsm file.  I got this to work with .xlsx file format, so I'm guessing the toolkit can't work with .xlsm?

Thanks in advance.

[muks]

XLSM is supported i think

[Burt_S]

Unfortunately I do not believe xlsm files are currently supported.  I will let you know if I can find a workaround for this.

[framework]

Thanks for your replies.  I received an e-mail from NI support saying the exact same thing and they suggested as a work around to use that Excel data plugin to get around the issue.  Do you think this file format will be supported natively anytime soon?  I can't imagine its a priority but I think its an important feature to have since it seems like the two basic Excel file formats for 2007 is the .xlsx and the xlsm.

[muks]

---

Unfortunately I do not believe xlsm files are currently supported.  I will let you know if I can find a workaround for this

---

oops then it is misleading.....

[Burt_S · Accepted solution]

The following may be a workaround for you:

1.       Navigate to the following VI:

C:\Program Files\National Instruments\LabVIEW 8.6\vi.lib\addons\_office\_exclsub.llb\Excel_Save_Workbook.vi

2.       Add a “.xlsm” case to the case structure and use 52 as the numeric value:

Note: Please make sure to save this as a new VI so that the original vi.lib is intact. You may also want to edit the icon so you remember this is not the original version.  Let me know if this helps.

[framework]

Alright so I've made the adjustments, and as far as I can tell I can open, edit, and save .xlsm files.  Awesome, thanks a lot Burt.

[muks]

Nice work around. Thanks for posting it burt.

[MathieuSteiner]

---

@Burt S wrote:

The following may be a workaround for you:

1.       Navigate to the following VI:

C:\Program Files\National Instruments\LabVIEW 8.6\vi.lib\addons\_office\_exclsub.llb\Excel_Save_Workbook.vi

2.       Add a “.xlsm” case to the case structure and use 52 as the numeric value:

Note: Please make sure to save this as a new VI so that the original vi.lib is intact. You may also want to edit the icon so you remember this is not the original version.  Let me know if this helps.

---

This is helpfull

Works great ! Please handle this natively in the toolkit 🙂