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:
- Retrieve text from a remote text file
- Get content from a webpage
- 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':
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.
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?