VB script in Excel object in Powerpoint (Urgent)

E

epak

I have a script in an excel table that I have put in powerpoint which
would like to run in a powerpoint slideshow - using the mouseclic
action.

Is there anyway to do this?

If that isn't possible, is it possible to make a macro in powerpoin
that manipulates cells in an excel object?

What would the address be? I thought something like the following woul
work, but it doesn't:
ActiveWindow.Selection.SlideRange.Shapes("Objec
11568").Workbook(1).Worksheets(1).Range("A1:B5") = "AB"

I also thought of making a button in the excel file and then embedin
it in the powerpoint file. Unfortunately, the button does not wor
either. How would I get the button to work.. or at least how would
get the script that is linked to that button to work from inside
powerpoint slide show (using the mouseover or mouseclick action)?

Here is 'the sample file' (http://ep.pe.kr/sample2.ppt), could anyon
take a look?

This is quite urgent, so I would be really appreciative for any help
 
E

epak

I also tried doing this..



Code:
--------------------

Sub bye()

With ActivePresentation.Slides(1).Shapes(1).OLEFormat.Object.Application
.Workbooks(1).Worksheets(1).Range("B2:C6").Value = "AB"
End With
With ActivePresentation.Slides(1).Shapes("Object 11568").OLEFormat.Object.Application
.Workbooks(1).Worksheets(1).Range("B2:C6").Value = "AB"
End With
Print ActivePresentation.Slides(1).Shapes(1).Name

End Sub

--------------------




but it doesn't seem to work..

and why is it that i'm not able to run this macro in design mode? (in
the run macro window, the "run" button is greyed out. only the cancel,
edit, and delete buttons are active.. why is this?)

anybody? :(
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top