Dialogs(wdDialogFileOpen) --> can't multi-select

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RJ Lohan - 20 Dec 2004 05:25 GMT

There is a knowledge base article;
http://support.microsoft.com/default.aspx?scid=kb;en-
us;146922

Which outlines an issue with VBA in Word where using
Dialogs(wdDialogFileOpen) caused runtime error when
selecting multiple files. However, this article only
refers to Word 97, and I'm sure this is still an issue in
Word 2000/XP/2003

Can anyone point me to a reference to this effect?

(I know I can use Application.FileDialog for XP/2003, but
as this isn't available in Word 2000, I need to find a
reference to this issue for customer explanation)
.

Reply to this Message

Jonathan West - 20 Dec 2004 08:37 GMT

Take a look here

Can't open multiple files using FileOpen
http://word.mvps.org/FAQs/MacrosVBA/OpenMultipleFiles.htm

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

> There is a knowledge base article;
> http://support.microsoft.com/default.aspx?scid=kb;en-
[quoted text clipped - 12 lines]
> reference to this issue for customer explanation)
> .

Reply to this Message

RJ Lohan - 20 Dec 2004 22:37 GMT

Ah, nice one. Thanks for that.

Cheers,
Ryan

> Take a look here
>
[quoted text clipped - 17 lines]
> > reference to this issue for customer explanation)
> > .

Reply to this Message

RJ Lohan - 22 Dec 2004 05:57 GMT

Ah, I've just discovered that that resolution probably won't do -> reason
being that I modify the action of the 'Open' button (and menu items). Which
is why I need to duplicate the open dialog in the first place...

Any other suggestions or KB links?

> Take a look here
>
[quoted text clipped - 17 lines]
> > reference to this issue for customer explanation)
> > .

Reply to this Message

Jonathan West - 22 Dec 2004 10:09 GMT

> Ah, I've just discovered that that resolution probably won't do -> reason
> being that I modify the action of the 'Open' button (and menu items).
> Which
> is why I need to duplicate the open dialog in the first place...
>
> Any other suggestions or KB links?

The following article has some VB code for using the Windows common dialog
for file open.

http://vbnet.mvps.org/code/comdlg/fileopendlg.htm

The code is in VB6 rather than VBA, and so you will need to adapt it a bit,
but the Windows common dialog does allow you to do multisepect.

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

Reply to this Message

RJ Lohan - 22 Dec 2004 23:53 GMT

That's probably a bit heavy for what I want - and adds a dependancy to
distribute doesn't it?

Anyway, bit of lateral thinking and I've resolved this one - I now add an
'Open' button to the toolbar and execute that one, which hasn't been hooked
by my other code. Then I delete it, and the user is none the wiser.

Thanks for the help.

Cheers,
Ryan

> > Ah, I've just discovered that that resolution probably won't do -> reason
> > being that I modify the action of the 'Open' button (and menu items).
[quoted text clipped - 10 lines]
> The code is in VB6 rather than VBA, and so you will need to adapt it a bit,
> but the Windows common dialog does allow you to do multisepect.

Reply to this Message

Jonathan West - 23 Dec 2004 11:59 GMT

> That's probably a bit heavy for what I want - and adds a dependancy to
> distribute doesn't it?

The coding it a bit inticate, but it adds no dependencies and nohing
dditional that you need distribute.

> Anyway, bit of lateral thinking and I've resolved this one - I now add an
> 'Open' button to the toolbar and execute that one, which hasn't been
> hooked
> by my other code. Then I delete it, and the user is none the wiser.
>
> Thanks for the help.

You're welcome!

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

Reply to this Message