Member Avatar for calebcook

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 by calebcook because: Even More Info
  • 2 Contributors
  • 1 Reply
  • 375 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by StephNicolaou
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.