Dear all,

surely there are some of you, who remember, that in Excel 95 the
forms were stored in their own sheet type, together with worksheets,
charts and modules.

Now I have to convert such a file with 12 really complete dialogs
to Excel 2000 user forms. Regarding this, I would appreciate your
help with two questions:

1. Is there a way, to convert the old XL95 dialogs automatically in
XL-2000 user forms? I know, I have to change the code too, but
each dialog includes a lot of pre-settings and they are in proper
shape.
I have already tried the clipboard and dragging with the mouse.

2. The dialog sheets from XL 95 (is it the forms library 2.0?) are
supported by Office 2000. What's about Office XP, Office 2003?
Is there a roadmap by Microsoft for the end of support of the
old dialogs?

Thanks in advance, Ralf.

Ralf,

Go to www.appspro.com , then the Free Utilities section, and
download the Dialog Converter.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Ralf Pfeifer" wrote in message
...
Dear all,

surely there are some of you, who remember, that in Excel 95
the
forms were stored in their own sheet type, together with
worksheets,
charts and modules.

Now I have to convert such a file with 12 really complete
dialogs
to Excel 2000 user forms. Regarding this, I would appreciate
your
help with two questions:

1. Is there a way, to convert the old XL95 dialogs
automatically in
XL-2000 user forms? I know, I have to change the code too,
but
each dialog includes a lot of pre-settings and they are in
proper
shape.
I have already tried the clipboard and dragging with the
mouse.

2. The dialog sheets from XL 95 (is it the forms library 2.0?)
are
supported by Office 2000. What's about Office XP, Office
2003?
Is there a roadmap by Microsoft for the end of support of
the
old dialogs?

Thanks in advance, Ralf.

Ralf

You can try Rob Bovey's Dialog Converter Add-in.

http://www.appspro.com/

Find under "Free Utilities"

Gord Dibben Excel MVP

On Wed, 24 Dec 2003 00:45:36 +0100, Ralf Pfeifer
wrote:

Dear all,

surely there are some of you, who remember, that in Excel 95 the
forms were stored in their own sheet type, together with worksheets,
charts and modules.

Now I have to convert such a file with 12 really complete dialogs
to Excel 2000 user forms. Regarding this, I would appreciate your
help with two questions:

1. Is there a way, to convert the old XL95 dialogs automatically in
XL-2000 user forms? I know, I have to change the code too, but
each dialog includes a lot of pre-settings and they are in proper
shape.
I have already tried the clipboard and dragging with the mouse.

2. The dialog sheets from XL 95 (is it the forms library 2.0?) are
supported by Office 2000. What's about Office XP, Office 2003?
Is there a roadmap by Microsoft for the end of support of the
old dialogs?

Thanks in advance, Ralf.

Ralf Pfeifer wrote:


Thank you all, the Dialog Converter from www.appspro.com
works perfect.

Thanks again, Ralf.