Macro's in Power Point

  • Thread starter Thread starter Simon Churches
  • Start date Start date
S

Simon Churches

I am having problems opening an Excel document in
Powerpoint using the macro buttons. I have placed a
CommandButton on the sheet and when I edit the code as
such:

Private Sub CommandButton1_Click()
Workbooks.Open FileName:="c:\book1.xls"
End Sub

It does not work. Does anyone know how what the code
should be to open this file?

2nd problem is, can you extract only certain data from
the file. The 1st column is a date column. Can you set it
up so that say on data with a date say May 2004 will be
loaded?

Thank you,

Simon Churches, South Africa
 
Simon,
Do you really need to open it using code? The same effect can be achieved by
assigning an action setting on the button and hyperlink it to the xls file.
2nd problem is, can you extract only certain data from
the file. The 1st column is a date column. Can you set it
up so that say on data with a date say May 2004 will be
loaded?
Click to expand...
You can certainly extract that information however where do you intend to
display it? Will it be on a text box on the slide?
 
Back
Top