Multiple instances of excel when running macros between sheets
Results 1 to 2 of 2

Thread: Multiple instances of excel when running macros between sheets
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 Multiple instances of excel when running macros between sheets

    Hi all,

    I have some code that runs and opens another sheet to pull data from it. (the code checks if the sheet is open first and opens it if not).

    The issue that I'm having is that occasionally when I open the second sheet it opens a new instance of excel and then it can't see it.


    Is there any way around this?


    Thanks
    Tom

  2. #2
    Board Regular MUKESHY12390's Avatar
    Join Date
    Sep 2012
    Location
    India
    Posts
    846
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Multiple instances of excel when running macros between sheets

    you need check to "Is there object declare for Excel application". if then remove it.

    or simply you can post sample code here we could suggest something.
    MS Office 2010/ Windows 7/8.1
    ---------------------------------------------------------------------------------------------------------
    Concern yourself not with what you tried and failed in, but with what it is still possible for you to do..


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
  •