+ Reply to Thread
Results 1 to 2 of 2

Run Subform Error

  1. 11-18-2010, 05:38 AM #1
    Mooseman60
    Mooseman60 is offline
    Forum Contributor
    Join Date
    09-26-2010
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    182

    Question Run Subform Error

    When i run my userform it comes up with

    Defined Name Lists.xls is already open. Reopening will cause any changes you made to be discarded. Do you want to reopen the Defined Name Lists.xls

    If I click yes it comes up with the following error Run-time error.13 Type mismatch

    If I click no it comes up with the following error Method open of Object Workbooks failed

    Please Login or Register  to view this content.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 11-18-2010, 06:45 AM #2
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,056

    Re: Run Subform Error

    You need to test to see if the workbook is already open before you try and open it.
    Which line does the Type Mismatch occur on?
    Everyone who confuses correlation and causation ends up dead.
    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