Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dialog Box
hi,
define it with a dim sub test() dim x as application Regards FSt1 " wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dialog Box
I'm sorry I forgot to mention the code is written in Access
If I define x as an apllication I get the error that there is a type mismatch on the code set x=createObject("Excel.Application") Any other hints? many thanks FSt1 schreef: hi, define it with a dim sub test() dim x as application Regards FSt1 " wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to delete the "Insert Function Dialog Box" (dialog box only)? | Excel Worksheet Functions | |||
How to permanently change Dialog Caption while in the Dialog | Excel Programming | |||
How to permanently change Dialog Caption while in the Dialog | Excel Programming | |||
control of dialog macro dialog box. on open | Excel Programming | |||
Pop up dialog box | Excel Programming |