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 hashemi-te@esfahansteel.com
or
hashemi.teimoor@gmail.com

best regard
hashemi

Attached Files

save_dbf.xls (29.0 KB, 2 views)

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.

__________________
Hope that helps.

RoyUK
--------
If you are pleased with a member's answer then use the Scales icon to rate it

For Excel consulting, free examples and tutorials visit my site
Check out the free Excel Toolbar

New members please read & follow the Forum Rules

Remember to mark your questions Solved and rate the answer(s)

Where to copy the code to

Code Tags: Make your code easier for us to read

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.

__________________
Cheers
Andy
www.andypope.info