+ Reply to Thread
Results 1 to 3 of 3

getting files name false.xlsm and true.xlsm when I click cancel on the save as window

  1. #1
    Registered User
    Join Date
    08-14-2013
    Location
    Arizona
    MS-Off Ver
    Excel 2007
    Posts
    71

    getting files name false.xlsm and true.xlsm when I click cancel on the save as window

    I have a command button that clears text boxes and resets values. That part works fine. I then have it ask if you want to save as a new file so not to overwrite data on the previous file. Problem that I am having is that when I say yes I want to save as a new file and when the save as window appears, for testing purposes I changed my mind, I really don't want to save as and click cancel. It still saves a file as false.xlsm. How do I avoid this? I've tried Filename:= and Filename =, and without : I get a file named true.xlsm. For simplicity I reduced the code to just the save as functions without all the clear/rest cell code.

    Thank you!!

    Please Login or Register  to view this content.
    Last edited by jwlamb; 10-04-2013 at 09:52 AM. Reason: newbie didn't know about code tags

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: getting files name false.xlsm and true.xlsm when I click cancel on the save as window

    You may use another variable:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-14-2013
    Location
    Arizona
    MS-Off Ver
    Excel 2007
    Posts
    71

    Re: getting files name false.xlsm and true.xlsm when I click cancel on the save as window

    Thank you for the reply. I'm also trying to get the user to choose a directory with an inputbox making up the filename. I have another post going in order to do that. I will use whichever one works best. Thank you again.

    Quote Originally Posted by Izandol View Post
    You may use another variable:
    Please Login or Register  to view this content.

+ 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. [SOLVED] Open > Click Ok on Error > Save as .xlsm
    By Sweepin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-30-2013, 06:49 PM
  2. Open XLSM's in seperate window
    By ipausa in forum Excel General
    Replies: 0
    Last Post: 09-09-2013, 02:14 PM
  3. [SOLVED] Copy/Save As xlsm workbook to new xlsm workbook is not copying the code with it
    By Grinchy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-02-2013, 09:30 AM
  4. Save file xls file as xlsm - macro won't run in xlsm workbook
    By captbluefin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-07-2012, 11:39 AM
  5. Replies: 2
    Last Post: 08-13-2012, 05:20 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