Not quite as bad as you make out

expression.Open(FileName, UpdateLinks, ReadOnly, Format, Password,
WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter,
Editable, Notify, Converter, AddToMRU)

You need to set AddToMRU to true. You could go through and re-enter
all the defaults for the other arguments like

or just
Workbooks.Open("file.xls",,,,,,,,,,,,true)

but using named arguments still saves some typing in many cases.

--
Regards,
Tom Ogilvy

"TommySzalapski"
<TommySzalapski.1t546n_1122991574.8252@excelforu m-nospam.com wrote in
message news:TommySzalapski.1t546n_1122991574.8252@excelfo rum-nospam.com...

It's mostly to make things easier with argument lists
Example:
You want to open a workbook from a macro and have it go in the recently
used file list. The syntax for the open method is:

expression.Open(FileName, UpdateLinks, ReadOnly, Format, Password,
WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter,
Editable, Notify, Converter, AddToMRU)

You need to set AddToMRU to true. You could go through and re-enter
all the defaults for the other arguments like
Workbooks.Open("file.xls", false, false,....., true) and you have to go
figure out what all needs to go there or you could type:

Workbooks.Open "file.xls", AddToMRU := true

Saves a lot of typing.


--
TommySzalapski
------------------------------------------------------------------------
TommySzalapski's Profile:
http://www.excelforum.com/member.php...o&userid=25561
View this thread: http://www.excelforum.com/showthread...hreadid=392118