View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Excel 2007. Trust Access to VBA Project Checked, still not tr

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