Correction: The xlDialogOpen example showing arg3:=True appears in Excel
That is a riot. It's good to see that, just like the designers and
developers, the help writers do not actually use Excel.
--
Jim
| Correction: The xlDialogOpen example showing arg3:=True appears in Excel
2007
| help at:
http://msdn2.microsoft.com/en-us/library/bb236937.aspx
|
| "Jim Rech" wrote:
|
| > >>so I'm assuming the Arg3:=True should automatically open the file as
| > >>read-only
| >
| > The Args are used to preset dialog options, where they exist. The 'read
| > only' option check box has not existed since Excel 95.
| >
| > You're going to have to switch to this to do what you want:
| >
| > Dim FName As Variant
| > FName = Application.GetOpenFilename("Excel Files (*.xl*),*.xl*")
| > If FName <> False Then
| > Workbooks.Open Filename:=FName, ReadOnly:=True
| > End If
| >
| > --
| > Jim
| > | > | Thanks for the reponse Sebastien. In my app, I need to use xlDialogs.
The
| > | list of arguments shows the third argument as "read_only" so I'm
assuming
| > the
| > | Arg3:=True should automatically open the file as read-only but setting
the
| > | argument to true has no effect. Any other ideas? Thanks
| > |
| > | "sebastienm" wrote:
| > |
| > | >
| > | > xlDialogOpen
| > | > ---------------
| > | > file_text, update_links, read_only, format, prot_pwd,
write_res_pwd,
| > | > ignore_rorec, file_origin, custom_delimit, add_logical, editable,
| > | > file_access, notify_logical, converter
| > | >
| > | > More generally: for all dialogs
| > | > -----------------------------------
| > | > type Application.Dialogs, then select 'Dialogs' and press F1 to get
the
| > | > Help. There, click the 'Dialogs' link and finally on that page you
have
| > a
| > | > "see Built-in Dialog Box Argument Lists." link for all Dialogs.
| > | >
| > | > Option.
| > | > ---------
| > | > You can use the other dialog to open files. I personally prefer it:
| > | > Application.FileDialog(msoFileDialogOpen)
| > | > Check the help for more details.
| > | >
| > | > --
| > | > Regards,
| > | > Sébastien
| > | > <
http://www.ondemandanalysis.com>
| > | >
| > | >
| > | > "frice" wrote:
| > | >
| > | > > 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
| >
| >
| >
