Re: VB6 Common Code for Access, Excel and VB Projects

From: Howard Kaikow (kaikow_at_standards.com)
Date: 09/28/04 

Date: Tue, 28 Sep 2004 13:38:08 -0400

Compile the code to an ActiveX DLL and add a reference to each VBA/VB
project that requires use of the DLL. 

-- 
http://www.standards.com/; See Howard Kaikow's web site.
"Tim ffitch" <fia@ifs.inchcape.co.uk> wrote in message
news:131ac1c1.0409280651.1fa6e3c8@posting.google.com...
> Hi
>
> It has been sometime since I have done any pure VB programming. I need
> to set up in Visual Basic 6 something like a dll that has common
> functions I can use in Microsoft Access, Excel and VB Projects. I am
> am sure I did something similar years ago in VB 5.
>
> I have created a class which stores all the code for the function
> procedures but from my projects I have to reference the instance of
> the class instead of just calling the function.
>
> I am sure I did this last time without having to set up a class. I
> have tried a Standard Exe project but it wont allow me to connect to
> it.
>
> Any ideas please?
>
> Kind regards
> Tim ffitch

Relevant Pages

  • VB FAQs (Interview Questions) lot lot
    ... Consider two objects, A and B. A holds a reference to B, ... Why do so many example programs not use the DLL name ... Private Declare Function SendMessage Lib "user32" ... Private Const BUFFER_LENGTH As Long = 255 ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Sharing Code
    ... What I found would happen is that when the device dll was built visual ... In the desktop project when you add a reference to the dll, ... > projects, one smart device and one desktop, but they're in the same ... > The 2 form projects have references to this class library projects. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Namespaces - broad question
    ... Reference the Class Library in your Page, ... > aspx pages that I know I want utilize a specific function within, ... > have the same codebehind page), how can I reference this function. ... >> A .Net assembly is a compiled DLL. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Namespace Question
    ... >>i saw that when i changed it to true my dll was copied to the bin folder ... >>the reference by looking in the following locations, ... Look for assemblies in directories specified with the Reference Path ... >> tried to use the GAC but the process to convert dll to be strong name ...
    (microsoft.public.dotnet.languages.vb)
  • Re: calling from one workbook the classes and functions in another
    ... having discovered the vb trick recently I'm suddenly a big fan ... > reference to the instantiated class. ... you can't instantiate the class. ... >> Copy your cls into a VB Project for an activex dll. ...
    (microsoft.public.excel.programming)