Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jul 2003
    Location
    Brisbane, California, USA
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have written some UDFs and want to be able to use them without referencing the full "filename.ext!function".

    I got out my trusty J. Walkenbach Excel 2007 Bible and, sure enough, he tells me how to do it. Unfortunately, Excel won't let me.

    I go to Tools, References and in the dialogue box I see the list of choices, my file isn't there, so I browse and find it, select it and in the choices list is, not my file name, but "vbaproject." Of course, my module, in the VBE is called"VBAProject(PERSONAL.XLS).

    When I select "vbaproject" in the References dialogue box I get an error saying "Name conflicts with existing module, project or library" Also, there are two instances of "vbaproject" in the list of choices and no way I can find to remove one or both.

    Can someone help, please?

    Thanks,

    Cellmate

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You should give the VBA project in your Personal.xls a unique name:
    - Activate the Visual Basic Editor.
    - In the Project Explorer on the left hand side, click on VBAProject (Personal.xls).
    - In the Properties pane, you'll see that the (Name) property is set to VBAProject.
    - Click in this property and enter a new, unique name, for example MyPersonal
    - In the Project Explorer, click on the workbook where you want to use the user-defined functions.
    - Select Tools | References...
    - You should now see the name MyPersonal or whatever you specified. Since it's unique, you can tick its check box.

  3. #3
    Lounger
    Join Date
    Jul 2003
    Location
    Brisbane, California, USA
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hans, PERFECT!!! Exactly what I needed.

    thanks, so much!

    Cellmate

Posting Permissions

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