Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: User form in PowerPoint to feed Excel database

  1. #11
    New Member
    Join Date
    Aug 2019
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: User form in PowerPoint to feed Excel database

    Thank you. I looked at it, very impressive. I see some code is marked with ' as a text to not execute. Let say an excel sign-in template is named as: "Template," located on the desktop, how do I invoke the form?

    Also, would it be possible to integrate the form to a google form, so the data collection is centralized?
    Last edited by pcowner; Aug 19th, 2019 at 02:04 PM.

  2. #12
    Board Regular Worf's Avatar
    Join Date
    Oct 2011
    Location
    Rio, Brazil
    Posts
    3,727
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    2 Thread(s)

    Default Re: User form in PowerPoint to feed Excel database

    The example below loads a Google form, is this what you want?

    Code:
    ' slide module
    Private Sub CommandButton1_Click()
    ActivePresentation.FollowHyperlink _
    Address:="https://docs.google.com/forms/d/e/1FAIpQLSfzwTPVnBjXjnuPmRSRdlZbwO4afQaJEveg2TYEra3S_cv1JA/viewform", _
        NewWindow:=True, AddHistory:=True
    End Sub
    Last edited by Worf; Aug 21st, 2019 at 02:44 PM.
    Excel 2013 / Windows 8.1 (home)
    Excel 2013 / windows 7 (work)


Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •