Hi all,
Title says it all really. I'm trying to decide if it is worth the effort to chase through my company's policies to get VB Studio and learn how to write some Excel Com Add-Ins. I need to write some code that will take some time to run (information flow reports, unique formula analyser etc) and wondering how much faster such code would run if in a COM Add in rather than a regular excel add in.
I am an intermediate+ user of VBA (e.g. I have used dictionaries, class modules, userforms etc, but not so often that I am an expert) so I don't really have any concerns about being able to pick up how to do it from guides on the web.
Thanks
Gary
Title says it all really. I'm trying to decide if it is worth the effort to chase through my company's policies to get VB Studio and learn how to write some Excel Com Add-Ins. I need to write some code that will take some time to run (information flow reports, unique formula analyser etc) and wondering how much faster such code would run if in a COM Add in rather than a regular excel add in.
I am an intermediate+ user of VBA (e.g. I have used dictionaries, class modules, userforms etc, but not so often that I am an expert) so I don't really have any concerns about being able to pick up how to do it from guides on the web.
Thanks
Gary