Results 1 to 1 of 1

Error 400 displayed after opening a workbook

Threaded View

  1. #1
    Registered User
    Join Date
    10-19-2012
    Location
    Belgium
    MS-Off Ver
    Excel 2010
    Posts
    1

    Angry Error 400 displayed after opening a workbook

    Hello,

    When trying to open a workbook the 400 error is beïng displayed.
    I have tried to catch the error with the On Error possibilities, but to no effect.

    The xlsm file is macro enabeled and password protected


    Public Function Process_Files(Array_ID As Integer) As Boolean
    
        Dim WB As Workbook
        
        Application.DisplayAlerts = False
        Application.EnableEvents = False
        Application.EnableCancelKey = xlDisabled
           
        ' Openen van het inputbestand
        On Error Resume Next
          Set WB = Application.Workbooks.Open(Input_Folder & "\" & FileArray(Array_ID), True, False, , "***", "***", , , , True)
    
        If Err.Number <> 0 Then
          Process_Files = False
          Exit Function
        End If
    
    ...
    
    End Function
    Moderator Edit: In future when you use code, select your code and click on the # button above to insert the code tags. Alternatively, type [code] before your code and [/code] after your code.
    Last edited by arlu1201; 10-19-2012 at 09:39 AM. Reason: Use code tags in future.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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