Quick and easy question...
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Quick and easy question...

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I was just wondering, If I have references set up in my VBA project, will these settings work on another computer who has different default settings for references in excel?

    For example, I include Microsoft Outlook 9.0 object library to do some email coding with Outlook. If I run the excel file on another computer that usually DOESNT have MS Outlook 9.0 refrenced, will the code still work?

    Thanks,
    Chris

  2. #2
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    probably not. I had the same problem when going from 97 to 2000. Our default installation of 2000 put some references in the workbook that then crashed when I tried to run it on 97.

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    bummer

  4. #4
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yeah bummer, HOWEVER, if you are just attaching the reference and not actually using it, the user on the 97 machine can open the VBA editor, click the references menu,and find the reference that is lisated as missing. Unchecking the box for that reference will get it to working, but again only if you haven't actually used the reference in that workbook

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Yea thats the problem, I WANT to use it...I guess this program can do without automated email... :-/

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com