Hiding Excel UI

[rimfire44]

I am using the Report Generation Toolkit to process a lot of Excel files, up to 15,000 at a time. I'd like to make it so that the Excel UI doesn't show up. I think it will increase speed dramatically. I figure it is an ActiveX method or property but can't locate the proper one. Has anyone got a tip?

[CertifiNATEtion]

Hi Rimfire44, 

As the report generation toolkit calls into Excel to do all the processing, Excel has to be open and running to accept these calls. There may be an ActiveX method or call to disable the UI in Excel. However, it would be documented by Microsoft, not National Instruments. 

Please refer to this KB article on how to find ActiveX Objects and Methods documentation for Microsoft Office. 

http://digital.ni.com/public.nsf/allkb/29CDE4332C4E6A27862570AE006ECBF4?OpenDocument

-N

[GerdW · Accepted solution]

Hi rimfire,

you need to call Excel with some ActiveX magic:

[rimfire44]

This worked perfectly. Thanks for the help.