+ Reply to Thread
Results 1 to 2 of 2

VB Script handling Excel Error Message

  1. #1
    Registered User
    Join Date
    01-14-2004
    Location
    Va Beach, VA
    Posts
    71

    VB Script handling Excel Error Message

    Hi, I've got a VB Script running from 3270 emulator, that writes to an excel worksheet.
    The script saves the file to maker sure it's not read only / the user doesn't have it open.
    And excel pops up the message that the file already exists do I want to save over it.
    I want the script to answer No, but I'm unable to focus on the excel Information Message Box.
    Any responses would be welcome below is part of my code.

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    07-29-2014
    Location
    Oz
    MS-Off Ver
    2010
    Posts
    142

    Re: VB Script handling Excel Error Message

    Try:
    Please Login or Register  to view this content.
    Dan
    Don't forget to ☆ me if I helped you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Error Handling in Excel VBA
    By dluhut in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-06-2014, 12:35 PM
  2. Need Help with Complex Macro/VBA Script for Handling Several Import Files
    By NPoorbaugh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-06-2013, 11:38 AM
  3. [SOLVED] How to do Error handling for an Excel vba code?
    By ravikumar00008 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-25-2012, 12:28 PM
  4. error handling in excel
    By arnab0711 in forum Excel General
    Replies: 1
    Last Post: 02-24-2012, 11:19 PM
  5. Error handling with a handling routine
    By ben in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-15-2005, 11:06 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1