none
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