VB and Excel

Posted on 2005-05-08
Last Modified: 2010-04-17
I've got a VB form copying data into an Excel spreadsheet. Now all I want to do is run a function thats in one of the menus. I've tried recording a Macro but when I look at the code theres no code there.
Im not sure if this is of any relevence but the function I wish to call is a add in to Excel. (neurosolutions)
How can I perfom this task without having load Excel and clicking on it in the menu.

Question by:Bigfootuk
    1 Comment
    LVL 37

    Accepted Solution

    Hi Bigfootuk,
        AddIns("neurosolutions").Installed = True
    will install an Addin and
        AddIns("neurosolutions").Installed = False
    will remove it.

        Not sure if that is what you want..


    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
    Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
    In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now