|
|||||||||||||||||||||
|
#1
|
|||
|
|||
|
DialogSheet in Excel 2007
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 |
|
#2
|
||||
|
||||
|
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 Last edited by royUK; 06-02-2008 at 08:20 AM.. |
|
#3
|
||||
|
||||
|
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. |
![]() |
| Bookmarks |
New topics in Excel 2007 Help
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|