I've just migrated to a new laptop and Excel 2007 in the last 24 hours and am
unable to run a macro that worked in 2003 on 2007 (that's a newsflash, huh?)
Anyway, I'm trying to programmatically access information about the VBA
Project and when I get to this line

Set VBProj = mySlide.Parent.VBProject

I get an error that the project is not trusted. (OK, this is PowerPoint,
but it's running out of Excel). I've changed the settings to trust this
project and I still get the error. Is there something that our admins need
to do so that I can run this? Do I need to trust this out of PowerPoint?

Thanks,
Barb Reinhardt

Why not move it into a trusted location?

--
__________________________________
HTH

Bob

"Barb Reinhardt" wrote in message
...
I've just migrated to a new laptop and Excel 2007 in the last 24 hours and
am
unable to run a macro that worked in 2003 on 2007 (that's a newsflash,
huh?)
Anyway, I'm trying to programmatically access information about the VBA
Project and when I get to this line

Set VBProj = mySlide.Parent.VBProject

I get an error that the project is not trusted. (OK, this is PowerPoint,
but it's running out of Excel). I've changed the settings to trust this
project and I still get the error. Is there something that our admins
need
to do so that I can run this? Do I need to trust this out of PowerPoint?

Thanks,
Barb Reinhardt

I just set it's current location to be a trusted location and I'm still
getting the error. What next?

Thanks for your help.

Barb

"Bob Phillips" wrote:

Why not move it into a trusted location?

--
__________________________________
HTH

Bob

"Barb Reinhardt" wrote in message
...
I've just migrated to a new laptop and Excel 2007 in the last 24 hours and
am
unable to run a macro that worked in 2003 on 2007 (that's a newsflash,
huh?)
Anyway, I'm trying to programmatically access information about the VBA
Project and when I get to this line

Set VBProj = mySlide.Parent.VBProject

I get an error that the project is not trusted. (OK, this is PowerPoint,
but it's running out of Excel). I've changed the settings to trust this
project and I still get the error. Is there something that our admins
need
to do so that I can run this? Do I need to trust this out of PowerPoint?

Thanks,
Barb Reinhardt

What exactly are you doing that needs trusted access? if you post that I can
try it here.

--
__________________________________
HTH

Bob

"Barb Reinhardt" wrote in message
...
I just set it's current location to be a trusted location and I'm still
getting the error. What next?

Thanks for your help.

Barb

"Bob Phillips" wrote:

Why not move it into a trusted location?

--
__________________________________
HTH

Bob

"Barb Reinhardt" wrote in
message
...
I've just migrated to a new laptop and Excel 2007 in the last 24 hours
and
am
unable to run a macro that worked in 2003 on 2007 (that's a newsflash,
huh?)
Anyway, I'm trying to programmatically access information about the
VBA
Project and when I get to this line

Set VBProj = mySlide.Parent.VBProject

I get an error that the project is not trusted. (OK, this is
PowerPoint,
but it's running out of Excel). I've changed the settings to trust
this
project and I still get the error. Is there something that our admins
need
to do so that I can run this? Do I need to trust this out of
PowerPoint?

Thanks,
Barb Reinhardt

The trusted location is on my Z drive. I'm getting an error in this function

Public Function VBSlideProj(mySlide As PowerPoint.Slide) As Boolean
Dim VBProj As VBIDE.VBProject
Dim VBComp As VBIDE.VBComponent

Set VBProj = mySlide.Parent.VBProject 'Error here

VBSlideProj = False
For Each VBComp In VBProj.VBComponents
If VBComp.Name = mySlide.Name Then
VBSlideProj = True
Exit Function
End If
Next VBComp

End Function


I'm actually opening some powerpoint presentations and am checking to see if
there is a VBComponent attached to each slide. If there is, I want to do
something different.

"Bob Phillips" wrote:

What exactly are you doing that needs trusted access? if you post that I can
try it here.

--
__________________________________
HTH

Bob

"Barb Reinhardt" wrote in message
...
I just set it's current location to be a trusted location and I'm still
getting the error. What next?

Thanks for your help.

Barb

"Bob Phillips" wrote:

Why not move it into a trusted location?

--
__________________________________
HTH

Bob

"Barb Reinhardt" wrote in
message
...
I've just migrated to a new laptop and Excel 2007 in the last 24 hours
and
am
unable to run a macro that worked in 2003 on 2007 (that's a newsflash,
huh?)
Anyway, I'm trying to programmatically access information about the
VBA
Project and when I get to this line

Set VBProj = mySlide.Parent.VBProject

I get an error that the project is not trusted. (OK, this is
PowerPoint,
but it's running out of Excel). I've changed the settings to trust
this
project and I still get the error. Is there something that our admins
need
to do so that I can run this? Do I need to trust this out of
PowerPoint?

Thanks,
Barb Reinhardt

I'm not clear on whether you're running the Macro from Excel or PPT.

Anyway, it's possible that the slide hasn't been opened and it's
bombing because of that.

You should check that the macro works in PPT - because it's possible
that M$ doesn't provide access to the PPT VBProject.

If it's a security thing, MS Office comes with a program for creating
digital certifcates called
Selfcert.exe. It allows you to create digital certificates.

For details see page 27 of "Microsoft Office 2007 Programming" for a
step through.

Or try Googling Selfcert.exe and see if you get lucky.

Do I need to trust this out of PowerPoint?

Yes

Regards,
Peter T

"Barb Reinhardt" wrote in message
...
I've just migrated to a new laptop and Excel 2007 in the last 24 hours and
am
unable to run a macro that worked in 2003 on 2007 (that's a newsflash,
huh?)
Anyway, I'm trying to programmatically access information about the VBA
Project and when I get to this line

Set VBProj = mySlide.Parent.VBProject

I get an error that the project is not trusted. (OK, this is PowerPoint,
but it's running out of Excel). I've changed the settings to trust this
project and I still get the error. Is there something that our admins
need
to do so that I can run this? Do I need to trust this out of PowerPoint?

Thanks,
Barb Reinhardt

OK, so how do I do that when I'm not sure which powerpoint presentation I'm
going to be using each time?

"Peter T" wrote:

Do I need to trust this out of PowerPoint?

Yes

Regards,
Peter T

"Barb Reinhardt" wrote in message
...
I've just migrated to a new laptop and Excel 2007 in the last 24 hours and
am
unable to run a macro that worked in 2003 on 2007 (that's a newsflash,
huh?)
Anyway, I'm trying to programmatically access information about the VBA
Project and when I get to this line

Set VBProj = mySlide.Parent.VBProject

I get an error that the project is not trusted. (OK, this is PowerPoint,
but it's running out of Excel). I've changed the settings to trust this
project and I still get the error. Is there something that our admins
need
to do so that I can run this? Do I need to trust this out of PowerPoint?

Thanks,
Barb Reinhardt

Exactly as you would in any Office application, including Excel. Didn't we
discuss this once before? It's a one-off application level setting, that
'ought' to be done manually by the user -

in 2007
Office button
App' Name Options
Trust Center
Trust Center settings
Trust access to the VBA project object model

In 2002/3
Tools
Macro
Security
Trusted publishers
Trust access to VB Project

In this case looks like 5 steps in all versions, somehow it seems like its
considerably more in '2007 !

Regards,
Peter T


"Barb Reinhardt" wrote in message
...
OK, so how do I do that when I'm not sure which powerpoint presentation
I'm
going to be using each time?

"Peter T" wrote:

Do I need to trust this out of PowerPoint?

Yes

Regards,
Peter T

"Barb Reinhardt" wrote in
message
...
I've just migrated to a new laptop and Excel 2007 in the last 24 hours
and
am
unable to run a macro that worked in 2003 on 2007 (that's a newsflash,
huh?)
Anyway, I'm trying to programmatically access information about the
VBA
Project and when I get to this line

Set VBProj = mySlide.Parent.VBProject

I get an error that the project is not trusted. (OK, this is
PowerPoint,
but it's running out of Excel). I've changed the settings to trust
this
project and I still get the error. Is there something that our admins
need
to do so that I can run this? Do I need to trust this out of
PowerPoint?

Thanks,
Barb Reinhardt

No, we didn't discuss in the context of 2007. Should I set up a "trusted
location" in PowerPoint as well?

"Peter T" wrote:

Exactly as you would in any Office application, including Excel. Didn't we
discuss this once before? It's a one-off application level setting, that
'ought' to be done manually by the user -

in 2007
Office button
App' Name Options
Trust Center
Trust Center settings
Trust access to the VBA project object model

In 2002/3
Tools
Macro
Security
Trusted publishers
Trust access to VB Project

In this case looks like 5 steps in all versions, somehow it seems like its
considerably more in '2007 !

Regards,
Peter T


"Barb Reinhardt" wrote in message
...
OK, so how do I do that when I'm not sure which powerpoint presentation
I'm
going to be using each time?

"Peter T" wrote:

Do I need to trust this out of PowerPoint?

Yes

Regards,
Peter T

"Barb Reinhardt" wrote in
message
...
I've just migrated to a new laptop and Excel 2007 in the last 24 hours
and
am
unable to run a macro that worked in 2003 on 2007 (that's a newsflash,
huh?)
Anyway, I'm trying to programmatically access information about the
VBA
Project and when I get to this line

Set VBProj = mySlide.Parent.VBProject

I get an error that the project is not trusted. (OK, this is
PowerPoint,
but it's running out of Excel). I've changed the settings to trust
this
project and I still get the error. Is there something that our admins
need
to do so that I can run this? Do I need to trust this out of
PowerPoint?

Thanks,
Barb Reinhardt

No, we didn't discuss in the context of 2007.

Maybe not in 2007 but it's the same issue in all versions since 2002. Only
difference is where to find the setting in the UI.

Should I set up a "trusted
location" in PowerPoint as well?

Programmatic access to a VBProject is not a "trusted location" issue.

Regards,
Peter T


"Barb Reinhardt" wrote in message
...
No, we didn't discuss in the context of 2007. Should I set up a "trusted
location" in PowerPoint as well?

"Peter T" wrote:

Exactly as you would in any Office application, including Excel. Didn't
we
discuss this once before? It's a one-off application level setting, that
'ought' to be done manually by the user -

in 2007
Office button
App' Name Options
Trust Center
Trust Center settings
Trust access to the VBA project object model

In 2002/3
Tools
Macro
Security
Trusted publishers
Trust access to VB Project

In this case looks like 5 steps in all versions, somehow it seems like
its
considerably more in '2007 !

Regards,
Peter T


"Barb Reinhardt" wrote in
message
...
OK, so how do I do that when I'm not sure which powerpoint presentation
I'm
going to be using each time?

"Peter T" wrote:

Do I need to trust this out of PowerPoint?

Yes

Regards,
Peter T

"Barb Reinhardt" wrote in
message
...
I've just migrated to a new laptop and Excel 2007 in the last 24
hours
and
am
unable to run a macro that worked in 2003 on 2007 (that's a
newsflash,
huh?)
Anyway, I'm trying to programmatically access information about the
VBA
Project and when I get to this line

Set VBProj = mySlide.Parent.VBProject

I get an error that the project is not trusted. (OK, this is
PowerPoint,
but it's running out of Excel). I've changed the settings to trust
this
project and I still get the error. Is there something that our
admins
need
to do so that I can run this? Do I need to trust this out of
PowerPoint?

Thanks,
Barb Reinhardt