![]() |
Excel 95 Dialog - Excel 2000 Userform
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. |
Excel 95 Dialog - Excel 2000 Userform
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. |
Excel 95 Dialog - Excel 2000 Userform
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. |
Excel 95 Dialog - Excel 2000 Userform - Thank you!
Ralf Pfeifer wrote:
Thank you all, the Dialog Converter from www.appspro.com works perfect. Thanks again, Ralf. |
All times are GMT +1. The time now is 05:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com