Excel 2007 : DialogSheet in Excel 2007

[hashem_te]

where is "DialogSheet" Data Type in Excel 2007
i had a VBA Code in an Excel File that Work in Excel 2003 properly
but opening this file in Excel 2007 occured error on this line of Code
Set DlgFormSheet = ThisWorkbook.DialogSheets("Form")

that
Dim DlgFormSheet As DialogSheet

I used this Excel File to save other Excel file as DBF file for foxpro
can you help me to use this Converter in Excel 2007

file is Attached "save_dbf.xls"
Contact me at [email protected]
or
[email protected]

best regard
hashemi

[royUK]

Welcome to the forum. I would suggest that you don't put your email address in your posts un less you don't mind receiving spam emails. Contact should be via the Forum.

DialogSheets were replaced by UserForms several versions back but were maintained for backwards compatability. Maybe this has finished with 2007.

[Andy Pope]

It's is still there, as Roy says, for backward compatibility.

But now the object is Hidden so does not appear via intellisense.
If you go to the Object Browser (F2) you can right click and view Hidden members.