Results 1 to 3 of 3

Closing current file without saving - arrgh

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-23-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    404

    Closing current file without saving - arrgh

    Hi,

    I have a workbook (.xlsm) which ultimately saves a version of itself as a CSV and closes that CSV file. I then want to close the .xlsm file without saving. I have the following code but whilst it closes it still leaves Excel open as an application. I have attached a JPEG of what I mean by this.

    This is the code that I thought would work. What am I doing wrong?

    ActiveWorkbook.Close SaveChanges:=False
    Application.Quit
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Save a copy of current .xlsm file without closing the original
    By gezza07 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-24-2013, 08:52 PM
  2. [SOLVED] Opening, refreshing data connections, saving and closing file with VBA
    By jtukes in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2013, 03:31 PM
  3. Saving file to its current location and current file name with current date and "FINAL"
    By ironwill20 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-21-2012, 03:22 AM
  4. Replies: 2
    Last Post: 03-04-2012, 11:58 AM
  5. adding current date then after saving the file current date function stops
    By gotbitey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-21-2011, 02:15 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