+ Reply to Thread
Results 1 to 2 of 2

Remote instance of Excel crashes on .Close

  1. #1
    Registered User
    Join Date
    04-01-2015
    Location
    Desktop
    MS-Off Ver
    07,10,13
    Posts
    38

    Remote instance of Excel crashes on .Close

    Hey-now
    I have a macro that I do some stuff to a file that the macro opens. Then I do save as. Then close the workbook that I just manipulated and saved. Then it goes and does stuff to other files.
    That works when I run it all from the same instance of excel.
    Please Login or Register  to view this content.
    But I need to run the file remotely so I can do the work then close the file and reopen it.
    I got that part worked out too. The problem is that when running the macro remotely it runs fine till it saves the file and then has to close it. My remote instance of Excel crashes.
    If I comment out the close line everything works well.
    My question is how should I be closing the files so I dont crash my remote instance of excel?
    Below is the Code: I am starting Excel with, opening the workbook with the macro that I want to run.
    Please Login or Register  to view this content.
    Any help is appreciated

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,646

    Re: Remote instance of Excel crashes on .Close

    Don't use ActiveWorkbook, try using wbk.
    If posting code please use code tags, see here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 05-15-2012, 01:09 AM
  2. Can't get instance of Excel to close
    By murfeezlaw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-03-2012, 02:09 AM
  3. Close workbook in other instance(?) of excel
    By incjourn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2011, 08:10 PM
  4. Excel crashes when macro gets workbook to close
    By Julesdude in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-24-2011, 09:50 AM
  5. ThisWorkbook.Close crashes excel
    By Yappa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-12-2008, 01:59 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1