Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display an Excel form from PowerPoint
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display an Excel form from PowerPoint
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display an Excel form from PowerPoint
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display an Excel form from PowerPoint
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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I display an Excel Report with animation like PowerPoint | Excel Discussion (Misc queries) | |||
Inserting Interactive Excel Form into PowerPoint | Excel Discussion (Misc queries) | |||
Exporting excel charts with form controls (spinner) to Powerpoint | Charts and Charting in Excel | |||
Heartbroken: custom chart markers don't display properly in PowerPoint | Charts and Charting in Excel | |||
Display Pivot Table Chart in Powerpoint | Excel Discussion (Misc queries) |