1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel 2013 vba - problem with DAO read-only file

Discussion in 'Business Applications' started by CMIreland, Feb 4, 2015.

Thread Status:
Not open for further replies.
  1. CMIreland

    CMIreland Thread Starter

    Joined:
    Feb 4, 2015
    Messages:
    9
    Hi

    I converted a large addin from excel 2003 using DAO to access several workbooks.

    Now using excel 2013.

    The addin works in both Update and read-only modes. A 2nd user logging on will open the workbooks in read only mode automatically.

    The conversion to 2013 went well but DAO will not work when the workbooks are opened in read-only mode. I get the error "external table is not in the expected format".

    The exact same code works fine when the workbooks are opened in update mode.

    Very puzzling - can anybody help?

    I am really frustrated as I have a lot of users depending on the outcome. They have to continue using 2003 for the moment.

    The line in the code that fails is ...

    Set db = OpenDatabase(myfile, False, False, "Excel 8.0")

    myfile is an .xlsx file

    help very much appreciated
     
  2. draceplace

    draceplace

    Joined:
    Jun 8, 2001
    Messages:
    2,583
    Welcome to TSG!
    Just started using 2013 my self and was experiencing similar problem. While research mine I found this on StackOverflow concerning switching from ace.oledb to jet.oledb. You may need Jet runtime on your box.

    My issue is different in that I wasn't swapping from Jet to ACE. I'm doing 2010 vs 2013. Still researching\testing mine as it seemed to work then quit working. Please post your findings.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1142457

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice