Activeworkbook.vbproject.name in excelxp

Luke van der Steen · May 24th, 2002, 04:35 PM

Re-post
In my vb script in a excel97 workbook, I use something like
xxx = activeworkbook.vbproject.name
to verify a version of the program.
It always worked fine till I just tried the program in excel xp and I got an error message "programmatic access to a visual basic project is not trusted" How can I get around this. The help file in excel xp uses the above statement as an example

Do I have to change some setting in xp or something?
Help, anybody

Luke

Luke van der Steen · May 24th, 2002, 05:12 PM

Found it

So here I am, child in the woods of the new XP forest. Installed is a trusted zone within security. Just select the access part and oof you go.

Luke

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

May 24th, 2002, 04:35 PM	#1
Luke van der Steen New Member Join Date: May 2002 Location: Netherlands Posts: 6	Re-post In my vb script in a excel97 workbook, I use something like xxx = activeworkbook.vbproject.name to verify a version of the program. It always worked fine till I just tried the program in excel xp and I got an error message "programmatic access to a visual basic project is not trusted" How can I get around this. The help file in excel xp uses the above statement as an example Do I have to change some setting in xp or something? Help, anybody Luke

May 24th, 2002, 05:12 PM	#2
Luke van der Steen New Member Join Date: May 2002 Location: Netherlands Posts: 6	Found it So here I am, child in the woods of the new XP forest. Installed is a trusted zone within security. Just select the access part and oof you go. Luke