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
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.
Last edited by royUK; 06-02-2008 at 08:20 AM.
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel consulting, free examples and tutorials visit Excel Consulting-Excel VBA
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)
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks