+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : DialogSheet in Excel 2007

  1. 06-02-2008, 02:52 AM #1
    hashem_te
    hashem_te is offline
    Registered User
    Join Date
    06-02-2008
    Posts
    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
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-02-2008, 03:34 AM #2
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    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 07:20 AM.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example
    Reply With QuoteRegister To Reply
  3. 06-02-2008, 04:56 AM #3
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481
    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
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1