Display an Excel form from PowerPoint

[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

 

[Lman]

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

 

[Lman]

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.

 

[Chip Pearson]

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)