+ Reply to Thread
Results 1 to 5 of 5

Macro does not close window ... all the way?

  1. #1
    Forum Contributor
    Join Date
    04-19-2016
    Location
    Michigan
    MS-Off Ver
    15.0
    Posts
    130

    Macro does not close window ... all the way?

    Good morning folks, so i have this code to save my file and export pdf in 2 different folders:

    Please Login or Register  to view this content.
    Everything works great except the last line... it won't close that specific excel window but returns with this:

    HLPRvWe.png

    Any hint on how to completely close that window and not other excel files I am working on?

    Thanks!

  2. #2
    Forum Contributor kalbasiatka's Avatar
    Join Date
    02-27-2016
    Location
    Brest, Belarus
    MS-Off Ver
    2021
    Posts
    224

    Re: Macro does not close window ... all the way?

    ActiveWindow.Close ?
    To do it for me and help me it is 2 different things!
    Sorry for my english, blame Google translator

  3. #3
    Forum Contributor
    Join Date
    04-19-2016
    Location
    Michigan
    MS-Off Ver
    15.0
    Posts
    130

    Re: Macro does not close window ... all the way?

    You are awesome!

  4. #4
    Forum Contributor
    Join Date
    04-19-2016
    Location
    Michigan
    MS-Off Ver
    15.0
    Posts
    130

    Re: Macro does not close window ... all the way?

    Hmm, something is still not right - the window will not close all the time? Does this have anything to do with the fact that the code locates in my Personal Macro Work Book as opposed to the active workbook?

    Thanks!

  5. #5
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: Macro does not close window ... all the way?

    No, you can close it. It happens to me also when i have the another file opened.

    Is something from clipboard I think. But you can close the window after the macro is running.
    Please consider:
    Be polite. Thank those who have helped you.
    Click the star icon in the lower left part of the contributor's post and add Reputation. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

+ 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. Close Folder Window
    By Rerock in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-12-2014, 09:56 AM
  2. [SOLVED] Close ms vba window - code
    By bulina2k in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-12-2014, 02:16 PM
  3. [SOLVED] Close excel window
    By cober123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-15-2013, 03:10 PM
  4. Close New Window
    By Yvettemv in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-04-2012, 10:36 AM
  5. How do you close a window with a hidden UserForm in it?
    By skysurfer in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-16-2010, 07:58 PM
  6. Close Excel mac help window
    By BillyC in Ross in forum Excel General
    Replies: 0
    Last Post: 08-05-2006, 02:30 PM
  7. [SOLVED] How do I close the page break window?
    By 2jwayne in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-18-2005, 07:06 PM

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