Quick and easy question...

CRWeaks23 · Mar 11th, 2002, 02:30 PM

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 · Mar 11th, 2002, 02:40 PM

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 · Mar 11th, 2002, 02:42 PM

bummer

Steve Hartman · Mar 11th, 2002, 02:45 PM

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 · Mar 11th, 2002, 02:50 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 11th, 2002, 02:30 PM	#1
CRWeaks23 New Member Join Date: Mar 2002 Posts: 48	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

Mar 11th, 2002, 02:40 PM	#2
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	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.

Mar 11th, 2002, 02:42 PM	#3
CRWeaks23 New Member Join Date: Mar 2002 Posts: 48	bummer

Mar 11th, 2002, 02:45 PM	#4
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	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

Mar 11th, 2002, 02:50 PM	#5
CRWeaks23 New Member Join Date: Mar 2002 Posts: 48	Yea thats the problem, I WANT to use it...I guess this program can do without automated email... :-/