Thread: Dialog Box
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pcb_svp@telenet.be is offline
external usenet poster
 
Posts: 2
Default Dialog Box

Hello

I have a question on the open file dialog box:
the code is the following:

Sub test()

OpenBoolean = Application.Dialogs(xlDialogOpen).Show

Set x = CreateObject("Excel.Application")
OpenBoolean = x.Application.Dialogs(xlDialogOpen).Show

End Sub

The first line works fine however there is a problem with the third
line: I get the error "object not definied"

Can anyone help me?

Many thanks