Results 1 to 3 of 3

Thread: Excel opening workbook in another instance
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jan 2012
    Posts
    147
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Excel opening workbook in another instance

    Hi all,

    I have some multiple workbooks that I have saved on a sharepoint site that have macros to open other workbooks on that site and pull data out of them

    This all works fine, except sometimes when I open the other workbooks from the sharepoint site. excel seems to open the workbook in another instance of excel.

    This results in me not being able to re-open the workbook when my macro calls for it - but also stops my code from working as it can't see that the other workbook is open.


    Any help would be appreciated.

  2. #2
    Board Regular
    Join Date
    Nov 2008
    Location
    Netherlands
    Posts
    3,463
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Excel opening workbook in another instance

    Mmm haven't seen that before. Is it really another instance, or is it perhaps that Excel opened the file in 'protected' mode, waiting for you to press the edit button?
    Short Guide to Better VBA - Link: https://www.mrexcel.com/forum/showthread.php?t=712119

    Please use code tags around your code:
    [Code] Your code here... [/Code]




    Engelse lessen, persoonlijk en doelgericht. Dutch tuition tailor-made for you. https://Ennef.nl

    Wearable for people with panic attacks: sidjup https://sidjup.com

  3. #3
    Board Regular
    Join Date
    Jan 2012
    Posts
    147
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel opening workbook in another instance

    Yeah it's another instance.

    It seems to only do it when I store it on microsoft teams... and not when using sharepoint proper - so I guess it's a glitch in MS teams

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •