Results 1 to 4 of 4

VBA does not execute save

Threaded View

  1. 09-01-2019, 03:57 AM #2
    mohadin
    mohadin is offline
    Valued Forum Contributor
    Join Date
    06-27-2010
    Location
    sYRIA
    MS-Off Ver
    Excel 2013
    Posts
    669

    Re: VBA does not execute save

    Hi
    Add this line to your code
     If varResult <> False Then
        ActiveWorkbook.SaveAs filename:=varResult, FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
    Last edited by mohadin; 09-01-2019 at 03:15 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA: Open Save Prompt & execute macros based on user decision (save or cancel the save pro
    By chrisignm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-29-2016, 11:55 AM
  2. Execute a macro in a closed workbook, or open and execute without the user noticing
    By cearaujo123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-09-2015, 06:44 PM
  3. code to execute a keyboard shortcut or to execute a toolbar button
    By Gti182 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-09-2015, 12:16 PM
  4. Loop to execute SAVE code as defined number of times
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-10-2013, 08:15 AM
  5. Command line for open excel, insert a sheet, execute a macro, save file exit?
    By uschxc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-26-2012, 12:28 PM
  6. execute macro; save it and close using Application.OnTime
    By ina in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-12-2006, 12:25 PM
  7. [SOLVED] getting vba shell command to execute batch and save output to a file
    By Mad Scientist Jr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-28-2006, 10:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1