+ Reply to Thread
Results 1 to 3 of 3

Error Handler in case file is currupt and wont open.

  1. #1
    Forum Contributor
    Join Date
    03-08-2018
    Location
    Denmark
    MS-Off Ver
    2016 for Windows
    Posts
    413

    Error Handler in case file is currupt and wont open.

    I have a code to loop through folders and update a date in a sheet.

    I can not get a error handler to work.

    Any help will make me happy :-)

    Place marked in code.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Error Handler in case file is currupt and wont open.

    .
    Paste this line where you have indicated the need for an error handler :

    Please Login or Register  to view this content.

    Paste this at the bottom of your macro :


    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    03-08-2018
    Location
    Denmark
    MS-Off Ver
    2016 for Windows
    Posts
    413

    Re: Error Handler in case file is currupt and wont open.

    Thanks Logit,
    I will try thia tomorrow when i am back at work

+ 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. Excel file wont close if more than 1 file open
    By Undo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-10-2019, 10:05 AM
  2. [SOLVED] Error Handler with workbook open
    By TimlmiT in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-23-2018, 06:04 PM
  3. Currupt file help please
    By Afix in forum Excel General
    Replies: 4
    Last Post: 09-30-2013, 02:58 AM
  4. Excel File wont open
    By Andy-SRIXP in forum Excel General
    Replies: 3
    Last Post: 04-24-2009, 08:11 AM
  5. Select Case Error Handler?
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-17-2008, 03:29 PM
  6. File does not exist - error handler
    By MichaelS_ in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-19-2007, 05:02 PM
  7. [SOLVED] Read txt file for input error handler
    By Chirs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-30-2005, 08:05 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