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

"lorraine" wrote:

> 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

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.

"Lman" wrote:

> 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
>
> "lorraine" wrote:
>
> > 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

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)



On Tue, 25 Aug 2009 06:39:01 -0700, lorraine
<(E-Mail Removed)> wrote:

>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