Posted to microsoft.public.excel.programming

frice

external usenet poster

Posts: 6

xlDialogOpen arguments

I am trying to display the file Open dialog such that when the user selects
the particular file, it is automatically opened as Read-Only. I'm using:

Application.Dialogs.Item(xlDialogOpen).Show Arg1:="Book1.xlsm", Arg3:=True

Arg1 works so that only Book1.xlsm is shown but when I open the file, it is
not opened as read-only. Any ideas of what I'm doing wrong?

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
xlDialogOpen	jamie	Excel Programming	0	August 9th 07 08:18 PM
Using cmdlg xlDialogOpen	PO	Excel Programming	2	April 25th 07 05:44 PM
xlDialogOpen get it to return Path	DMc2005	Excel Discussion (Misc queries)	1	October 2nd 05 03:47 PM
xlDialogOpen get it to return Path	DMc2005	Excel Programming	1	October 2nd 05 03:47 PM
xlDialogOpen.Show or Activeworkbook.Path?	Mike Echo	Excel Worksheet Functions	2	January 29th 05 09:51 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us