Results 1 to 4 of 4

Save workbook keep original open

Threaded View

mspeck Save workbook keep original... 10-09-2012, 07:19 AM
TMS Re: Save workbook keep... 10-09-2012, 07:33 AM
mspeck Re: Save workbook keep... 10-09-2012, 07:43 AM
TMS Re: Save workbook keep... 10-09-2012, 08:00 AM
  1. #1
    Registered User
    Join Date
    02-20-2012
    Location
    Fletcher, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    11

    Save workbook keep original open

    Hello all,
    I'm looking to save my excel workbook with a date/time stamp whenever cell B1 equals a 1, which I have working just fine. However I want the original workbook to stay open, not what I had just saved.
    Attached is my formula, could someone look at it for me?

    Mike

    'Private Sub Worksheet_Calculate()
    'If [B1] = 1 Then
    'Application.Run "sheet1.Save_File"
    'End If
    'End Sub




    'Sub Save_File()
    'Dim Today As Date
    'Today = Date
    'Dim Time As Date
    'Time = Now
    
    
    'If Dir("C:\Documents and Settings\ACO Equipment\Desktop\mike\" & Format(Today, "MM_DD_YYYY_") & Format(Time, "HH_MM_SS") & ".xls") = "" Then
    'ActiveWorkbook.SaveAs Filename:="C:\Documents and Settings\mike\Desktop\Age Oven Data\" & Format(Today, "MM_DD_YYYY_") & Format(Time, "HH_MM_SS") & ".xls"
    
    'End If
    
    'End Sub
    Last edited by arlu1201; 10-09-2012 at 07:32 AM. Reason: Add code tags in future.

Thread Information

Users Browsing this Thread

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

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