LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to delete the "Insert Function Dialog Box" (dialog box only)? TBI''d biker Excel Worksheet Functions 2 April 7th 07 09:18 PM
How to permanently change Dialog Caption while in the Dialog MikeZz Excel Programming 2 July 11th 06 04:53 PM
How to permanently change Dialog Caption while in the Dialog MikeZz Excel Programming 0 July 11th 06 04:14 PM
control of dialog macro dialog box. on open Gerry Abbott Excel Programming 0 July 22nd 04 05:41 PM
Pop up dialog box Lloyd Gordon Excel Programming 0 September 19th 03 07:43 PM


All times are GMT +1. The time now is 06:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"