opening another application

M

Marco

I have a word document that I would like to create a command button that
automatically launches excel and then brings up the file dialog box.
Is there VBA code that does can do this.
I tried Set objExcel = New Excel.Application to set the application to Excel
but can't figure out how to open the file dialog box in excel.
 
J

Jonathan West

Marco said:
I have a word document that I would like to create a command button that
automatically launches excel and then brings up the file dialog box.
Is there VBA code that does can do this.
I tried Set objExcel = New Excel.Application to set the application to
Excel
but can't figure out how to open the file dialog box in excel.
Click to expand...

Hi Marco

You need the GetOpenFilename method in Excel. look it up in the Excel VBA
Help.
 

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

Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Default local file location - folder redirection slowness 0
Hyperlink fails to open on the first click 0
Word macro that can call cells out of Excel for a find and replace 0
Setting language of a selected text in Office apps. 0
inlineShape.OLEFormat.Activate() command fails for excel file 0
Apple Script in Outlook 365 Mac keystrokes blocked on M1 mac 0
File in use by another application or user 2

Top