×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

User form in PowerPoint to feed Excel spreadsheet

User form in PowerPoint to feed Excel spreadsheet

User form in PowerPoint to feed Excel spreadsheet

(OP)
I'd created a presentation/tutorial in MS PowerPoint, run it in a terminal mode, where users navigate through vba coded buttons. Now, I'm figuring a way to capture who views the PowerPoint (also, trying to capture their feedback). Could anyone please help with a vba code that could be tied to a userform in the beginning or the end of the presentation that would allow users to fill and submit the feedback/registrations? Could an embedded Excel w/VBA help with this?

Additional background info... as an admin, I upload 1 PP slide and it propagates to our public desktops in our classroom. Desktops are locked by the IT and there is no email client installed.

RE: User form in PowerPoint to feed Excel spreadsheet

Quote (PCOwner )

vba code that could be tied to a userform in the beginning or the end of the presentation

Is this the userform in PowerPoint presentation?
If so, you may try this.

btnSubmit is a command button on your PP UserForm,

CODE

Option Explicit

Private Sub btnSubmit_Click()
Dim objExcel As Object

Me.MousePointer = vbHourglass

Set objExcel = CreateObject("Excel.Application")

With objExcel
    '.Visible = True
    .Workbooks.Open FileName:="C:\TEMP\Test.xlsx"
    .Cells(1, 1).Value = "This is some text from PowerPoint presentation"
    .ActiveWorkbook.Save
    .Quit
End With
Set objExcel = Nothing

Me.MousePointer = vbDefault

End Sub 

---- Andy

There is a great need for a sarcasm font.

RE: User form in PowerPoint to feed Excel spreadsheet

Alt+F11 opens the VBA Editor in Microsoft Office applications.

Ctrl+R opens the Project Explorer in the VBE.

RIGHT-click on the application object in the PE and you can choose to insert a Userform, Module or Class Module to house your code.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

RE: User form in PowerPoint to feed Excel spreadsheet

What are the possibilities to transfer feedback info? Is there a mapped network drive, with common letter? If so, you may use network file, excel or even text file, to collect data.

combo

RE: User form in PowerPoint to feed Excel spreadsheet

(OP)
Greetings guys,

Thank you for reaching out. Thank you, Andrzejek for the code. Yes userform is in PowerPoint. I used your code to a newly created form w/ 2 text boxes and 1 button, but when I run the code nothing happens. The user for pops up in the beginning (1st slide), but when I press a button to submit, nothing happens. Default location is C:\Users\Careers\Desktop
I do like the code, very close to getting us there.

Thank you, SkipVought for the shortcuts.

combo, no idea if there a way for the transfer on the shared drive. The public computers do not show any mapped drives and all the folders are locked out, but the Desktop. Users can save files on the Desktop. From my staff computer, I'm able to access one folder on the shared drive. That folder we use to push a file and it shows up on all the public PCs. These PC use Win 8.

RE: User form in PowerPoint to feed Excel spreadsheet

What is the code you used?

What ends up in the Excel workbook?

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

RE: User form in PowerPoint to feed Excel spreadsheet

(OP)
Hello Skip,

I used the code by Andrzejek and a blank Excel spreadsheet.

RE: User form in PowerPoint to feed Excel spreadsheet

So you're saying that NOTHING ends up in C:\TEMP\Test.xlsx after you run the procedure?

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

RE: User form in PowerPoint to feed Excel spreadsheet

In addition to Skip's question,
did you put any break points in your (my?) VBA code to make sure that you actually execute that code when you click "Submit" button?


---- Andy

There is a great need for a sarcasm font.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close