Dialog Box

F

FGM

I am using excel to send charts to powerpoint. I can send it to a new
powerpoint with:
Set xlapp = Excel.Application
Set xlwb = xlapp.ActiveWorkbook
Set pptapp = New PowerPoint.Application
pptapp.Visible = True
Set pptpres = pptapp.Presentations.Add

However, I want to open an existing power point and wonder if it has a
dialog method as excel does:
Set xlapp = Excel.Application
sFilename = xlapp.GetOpenFilename("xls (*.xls),*.xls")
Set xlwb = xlapp.Workbooks.Open(sFilename)

Thanks for any help you can give me.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working outlook via vba code with xlsx - error 0
Dialog Boxes 2
How to pass parameters to excel from wscript (Windows script) 5
Create new spreadsheet based on template from macro in Word 1
Save as (filename,fileformat) from Word VBA will not work 1
two same workbooks opened -- don't want this 1
Rename Excel file via VBA 2
Open Excel workbook from Access 4

Top