Opening an excel file which contains macro

[Administrator]

How to open an excel file using Syncfusion APIs, if the file contains macros?

[Yavanaarasi G]

Hi Venkatesan,

Thank you for your interest in Syncfusion products.

Normally an excel file is open with XlsIO using the below code snippet. The similar way is used to open the file that contains macros. It has no difference. But currently we have support only for preserving macros from the template. XlsIO does not have any support for manipulating/running macros at runtime.

Here is the code snippet:

[C#]
//Step 1 : Instantiate the spreadsheet creation engine.
ExcelEngine excelEngine = new ExcelEngine();
//Step 2 : Instantiate the excel application object.
IApplication application = excelEngine.Excel;
//Open an existing spreadsheet 
IWorkbook workbook = application.Workbooks.Open(@"..\..\VBATemplate.xls"); 

Please let me know if you have any other concerns.

Regards,
G.Yavana

[Administrator]

The only difference, the way I open the file is that file name not starting with the '@' symbol. I even put this command

workbook.DisableMacrosStart = true;

Is there a way to ignore that initial popup message comes for enable/disable macro and still open the file?

[Yavanaarasi G]

Hi Venkatesh,

The macros are enabled by default while opening spreadsheet and it can be disabled by DisableMacrosStart property in XlsIO. Also you can remove macros using the following code snippet:

myWorkBook.Application.SkipOnSave = SkipExtRecords.Macros;

Please try this and let me know if this helps.

Regards,
G.Yavana

[Mangesh Hirave]

Hi,
I am working with macro enabled template (xltm) however, once opened at the time of saving the file I need to remove or at least disable the macros. I noticed the WordDocument has RemoveMacros() method available. Is there any similar functionality available for Excel? The follwing didn't work for me. The macros were still copied.

myWorkBook.Application.SkipOnSave = SkipExtRecords.Macros;

[Ishwarya Narayanan]

 

Hi Mangesh,

 

Sorry for the delay.

 

As you have created an incident with similar query, the response for this query will be updated in that incident. You can follow up the incident for further clarification regarding this query.

Please let us know if you have any concerns.

Regards,
Ishwarya N

[Emmett Miller]

Does XlsIO now support for manipulating/running macros at runtime? Will it support it in the future if not?

[Shamini Kiruba Sobers]

Hi Emmett, 

Currently, XlsIO cannot run macros and we have no immediate plans to support it. But we have support for creating and editing macros. Kindly refer the following UG link. 

https://help.syncfusion.com/file-formats/xlsio/working-with-macros 

Regards, 

Shamini