+ Reply to Thread
Results 1 to 3 of 3

Store UDF and use it on other machines not in network

  1. #1
    Abhijeet
    Guest

    Store UDF and use it on other machines not in network

    Hi,
    I created a module/ macro to give me a desired graph. I had stored the code
    for the macro in Personal.xls under a function called Graph, which was called
    with a key board shortcut "Ctrl+g". I want that our consultants who prepare
    data sheets for us be able to use this graph function to create the graph we
    want by using the same shortcut. Is it possible to create some executable
    code so that when the consultants get my email and open that exe file, it is
    run and copies the macro function into their excel program.
    Or if there is any other way I can give the consultants the Graph tool.
    Thanks
    --Abhijeet

  2. #2
    Bob Phillips
    Guest

    Re: Store UDF and use it on other machines not in network

    Put the code in an add-in and give them that.

    Some starters

    http://support.microsoft.com/default.aspx?kbid=211563
    How to create an add-in file in Excel 2000

    http://support.microsoft.com/default.aspx?kbid=156942
    XL97: How to Create an Add-in File in Microsoft Excel 97


    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Abhijeet" <Abhijeet@discussions.microsoft.com> wrote in message
    news:8F93DF8E-AD45-4CF0-8D4B-B58D45065492@microsoft.com...
    > Hi,
    > I created a module/ macro to give me a desired graph. I had stored the

    code
    > for the macro in Personal.xls under a function called Graph, which was

    called
    > with a key board shortcut "Ctrl+g". I want that our consultants who

    prepare
    > data sheets for us be able to use this graph function to create the graph

    we
    > want by using the same shortcut. Is it possible to create some executable
    > code so that when the consultants get my email and open that exe file, it

    is
    > run and copies the macro function into their excel program.
    > Or if there is any other way I can give the consultants the Graph tool.
    > Thanks
    > --Abhijeet




  3. #3
    Abhijeet
    Guest

    Re: Store UDF and use it on other machines not in network

    Thanx Bob

    "Bob Phillips" wrote:

    > Put the code in an add-in and give them that.
    >
    > Some starters
    >
    > http://support.microsoft.com/default.aspx?kbid=211563
    > How to create an add-in file in Excel 2000
    >
    > http://support.microsoft.com/default.aspx?kbid=156942
    > XL97: How to Create an Add-in File in Microsoft Excel 97
    >
    >
    > --
    >
    > HTH
    >
    > RP
    > (remove nothere from the email address if mailing direct)
    >
    >
    > "Abhijeet" <Abhijeet@discussions.microsoft.com> wrote in message
    > news:8F93DF8E-AD45-4CF0-8D4B-B58D45065492@microsoft.com...
    > > Hi,
    > > I created a module/ macro to give me a desired graph. I had stored the

    > code
    > > for the macro in Personal.xls under a function called Graph, which was

    > called
    > > with a key board shortcut "Ctrl+g". I want that our consultants who

    > prepare
    > > data sheets for us be able to use this graph function to create the graph

    > we
    > > want by using the same shortcut. Is it possible to create some executable
    > > code so that when the consultants get my email and open that exe file, it

    > is
    > > run and copies the macro function into their excel program.
    > > Or if there is any other way I can give the consultants the Graph tool.
    > > Thanks
    > > --Abhijeet

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1