VB6 Add-Ins
Results 1 to 5 of 5

Thread: VB6 Add-Ins

  1. #1
    Member
    Join Date
    Sep 2003
    Posts
    76

    VB6 Add-Ins

    I was wondering if someone can explain to me how to install and add-in for VB6. The situation is I needed to use the error function (ERF()) in a program and fortunately it exists already in the MSDN libraries as I found out in microsoft.com. Problems are 1) I dont know where to find the infamous ToolPak they tell me to install and 2)Where I guess if I can find it I could figure out how to install it but anyways thats problem number 2, installing it jeje. Point is Im kinda lost here any help would be appreciated very very much.
    I Speak in frequencies even dogs have trouble hearing


  2. #2
    Senior Member
    Join Date
    Jan 2003
    Posts
    3,914
    Hey Hey,

    As far as I can tell from reading that page.. ERF is a function for VBA programming in office, it makes no mention of it's usage in actual VB6, however I didn't look all that much.

    I'm refering to this page http://msdn.microsoft.com/library/de...html/SEB98.asp

    For information on making the ERF function available by adding in the ATP (Analysis Tool Pak) visit this page - http://www.cpearson.com/excel/ATP.htm

    It tells how to make use of it in Excel and also using VBA.


    Peace,
    HT
    IT Blog: .:Computer Defense:.
    PnCHd (Pronounced Pinched): Acronym - Point 'n Click Hacked. As in: "That website was pinched" or "The skiddie pinched my computer because I forgot to patch".

  3. #3
    Senior Member nihil's Avatar
    Join Date
    Jul 2003
    Location
    United Kingdom: Bridlington
    Posts
    17,191
    Hi Q,

    Two questions:

    1. What operating system?
    2. What application is the program in?

    I am guessing that what you are looking for might be on one of your CDs, but it won't be obvious..........Bill likes to set us these little problems

    Cheers

  4. #4
    Member
    Join Date
    Sep 2003
    Posts
    76
    Thanks for the link, problem is when i look in the VBA project references the only type of files i can refer to are .olb, .tlb, .dll., .exe, .ocx but nowhere to be found is a .xls.
    I Speak in frequencies even dogs have trouble hearing


  5. #5
    Member
    Join Date
    Sep 2003
    Posts
    76
    Okay after some research and a lot of stupidity by myself Ive reached this question, is there a way to use a function that is defined for microsoft excel(ie its in its libray, specifically the analysis toolpack ) and which I can use in the VB editor for Excel to interact with a project im coding in VB6?? If I can how??

Posting Permissions

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