Hi. I need to make a system where I can accept input from the audience, and it'll show live on a PowerPoint Slide. I can create the user input system, but I don't know how to make a PowerPoint macro that when run will either:

  1. Retrieve text from a remote text file
  2. Get content from a webpage
  3. Or get data from a MySQL database (preferred)

I've found a code that should read a text file, but when I run the macro, I get
Run-time error '424':

Object Required

My code is:

Sub readFile()
        Dim address As String
        address = "http://www.mysite.com/file.txt"
        Dim returnValue As String

        returnValue = WebClient.DownloadString(address)
        ActivePresentation.Slides(1).Shapes("nameOfShape").TextFrame.TextRange.Text = returnValue
End Sub

Any help with any of the options is greatly appreciated.

Thanks.

Or, if anyone can tell me how to embed a web page on a PPT slide on a mac (so that it'll update on slide enter), that will work too.

Another option would be to pull an image from a server on slide enter. Is that possible?

Edited 4 Years Ago by calebcook: Even More Info

This article has been dead for over six months. Start a new discussion instead.