Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    May 2004
    Toronto, Ontario, Canada
    Thanked 0 Times in 0 Posts

    Export-import module (Excel 2003)

    Hi all,

    this is a general question regarding importing and exporting modules, I know it is easy enough to export a module to folder, is there a way to import a module or access a module outside the VBA project? so if I wanted to use a function located in a folder within a module on my C: drive how would I go about doing it, in code.

    Thanks Darryl.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Export-import module (Excel 2003)

    An exported module is just a text file. VBA cannot run code directly from such a text file, You'll have to import it into the Visual Basic Editor (File | Import File) to be able to use the code in the module.

    I wouldn't recommend going about importing modules using code, it is tricky and requires being very familiar with the more abstruse aspects of VBA.

Posting Permissions

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