FileDialog - Not available in 2k?

Set fd = Application.FileDialog(msoFileDialogFilePicker)

Works well in '03 but get a "User-defined type not defined" error in 2k on the "fd".

I'm assuming this is something new (after 9.0)?

--
Regards;
Rob
------------------------------------------------------------------------

It was added in xl2002.

RWN wrote:
>
> Set fd = Application.FileDialog(msoFileDialogFilePicker)
>
> Works well in '03 but get a "User-defined type not defined" error in 2k on the "fd".
>
> I'm assuming this is something new (after 9.0)?
>
> --
> Regards;
> Rob
> ------------------------------------------------------------------------

--

Dave Peterson

ps.

Jim Rech has a BrowseForFolder routine at:
http://www.oaltd.co.uk/MVP/Default.htm
(look for BrowseForFolder)

John Walkenbach has one at:
http://j-walk.com/ss/excel/tips/tip29.htm

RWN wrote:
>
> Set fd = Application.FileDialog(msoFileDialogFilePicker)
>
> Works well in '03 but get a "User-defined type not defined" error in 2k on the "fd".
>
> I'm assuming this is something new (after 9.0)?
>
> --
> Regards;
> Rob
> ------------------------------------------------------------------------

--

Dave Peterson

Dave;
Thanks for the confirmation, and the links.
Guess it's time to upgrade - getting out of sync between home and work!

--
Regards;
Rob
------------------------------------------------------------------------
"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> ps.
>
> Jim Rech has a BrowseForFolder routine at:
> http://www.oaltd.co.uk/MVP/Default.htm
> (look for BrowseForFolder)
>
> John Walkenbach has one at:
> http://j-walk.com/ss/excel/tips/tip29.htm
>
> RWN wrote:
> >
> > Set fd = Application.FileDialog(msoFileDialogFilePicker)
> >
> > Works well in '03 but get a "User-defined type not defined" error in 2k on the "fd".
> >
> > I'm assuming this is something new (after 9.0)?
> >
> > --
> > Regards;
> > Rob
> > ------------------------------------------------------------------------
>
> --
>
> Dave Peterson