Excel XLSM file support

[jserrg]

Hi,

I am trying to set up a connection to Excel file. Everything seems to be working fine with xlsx file. But my file is xlsm. It is a standard Excel format for Excel files with VBA macroses. Pubbly does not see xlsm files at all. It displays only xlsx files in the dropdown when I choose Excel files.
I cannot re-save my xlsm file as xlsx or xls. It says VBA code can only be saved in the xlsm file.

Pubbly's purpose is automation. Excel uses VBA for automation. So most Excel files will be xlsm files.

Do you plan to add support for xlsm files?

Thank you in advance

 

[ArshilAhmad]

Hi @jserrg,

Please allow me some time to look into this. I will get back to you shortly.

 

[ArshilAhmad]

You can use the 'Search File in My Drive' action event in MS Excel to capture xlsm type files and enter the File ID in the Workbook field by enabling the mapping button. This will provide you with the xlsm type files. Once you have obtained the File ID, you can remove the 'Search File in My Drive' action event from your workflow.