Jet.OLEDB.4.0 VBS Connection creates READ-ONLY COPY of referenced EXCEL file RRS feed

  • Question

  • Running VB Script in Excel 16.0 (Part of Office 365 ProPlus 32 bit), when connection is created, a READ ONLY copy of the referenced file running the code is created straight after connection opened. I.e immediately after this line of code:

    cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
        "Data Source=" + Filename + ";" & _
        "Extended Properties=Excel 8.0"

    This has only occurred after a recent Office update, we are reasonably sure of? Anyone else experienced this? Need urgent help to stop this.

    Monday, December 2, 2019 8:11 AM

All replies

  • Sorry but this is not a VBA forum. Post VBA issues in the Excel VBA forum for assistance with Excel. This forum is for Administrative scripting only and Excel does not use VBScript. It is VBA.


    Monday, December 2, 2019 8:25 AM
  • Will do. Thanks. 
    Monday, December 2, 2019 9:17 AM