Display an Excel form from PowerPoint

  • Thread starter Thread starter lorraine
  • Start date Start date
L

lorraine

I currently have an excel form that I would like to open up and use from
powerpoint. Does anyone know what code I can use to acually run the macro
that opens the form?

Thank you,
Lorraine
 
Think i might have answered this somewhere else but anyway if you instert the
following code into your worksheet

Private Sub Workbook_Open()
ActiveWindow.WindowState = xlMinimized
UserForm1.Show
End Sub

(where userform1 is the name of your form).

You will then be able to create a hyperlink from the powerpoint slide and
should load the form on top of your slide..at least it worked for me anyway

hope this helps
 
Prehaps i should be more clear, the hyperlink you will create is a hyperlink
to the actual excel file wherever it resides on your local or network drive.
 
In you PowerPoint code, in the VBA editor, go to the Tools menu,
choose References, and put a check next to Microsoft Excel Object
Model. Then, in your PPT code, do something like:


Sub ShowExcelForm()
Dim XLApp As Excel.Application
Dim WB As Excel.Workbook
On Error Resume Next
Set XLApp = CreateObject("Excel.Application")
XLApp.Visible = True ' optional if you want Excel to be visible
Set WB = XLApp.Workbooks.Open("C:\Path\FileName.xls")
XLApp.Run "'" & WB.Name & "'!TheMacroName"
WB.Close savechanges:=True ' optional
Set WB = Nothing
XLApp.Quit 'optional
End Sub


In the FileName.xls workbook, use a procedure like the following to
show the form.

Sub TheMacroName()
userform1.Show
End Sub

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Back
Top