Quick and easy question...

[CRWeaks23]

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

 

[Steve Hartman]

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.

 

[CRWeaks23]

bummer

 

[Steve Hartman]

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

 

[CRWeaks23]

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