View Single Post
 
Old 07-10-2014, 05:56 AM
gbaker gbaker is offline Windows 7 32bit Office 2010 32bit
Competent Performer
 
Join Date: May 2012
Posts: 111
gbaker is on a distinguished road
Default Choose file name Save As macro

How can I incorporate the code into the macro I have.
Code:
Sub SAVEAS()
'
' SAVEAS Macro
'

'
    ChDir "J:\ProgramOps\Exceptions Masters & Data\Aon Hewitt"
     
    ActiveWorkbook.SAVEAS Filename:= _
        "J:\ProgramOps\Exceptions Masters & Data\Aon Hewitt\Aon Hewitt Exceptions 07-07-14.xlsx" _
        , FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
    Sheets("IMPORT-SAVE").Select
    ActiveWindow.SelectedSheets.Delete
    ActiveWorkbook.Save
    Application.Left = 58.75
    Application.Top = 41.5
    Sheets("Hewitt Delayed Retirement Plans").Select
    Range("E25").Select
    Sheets("Retirement Update").Select
    Range("G19").Select
End Sub
Reply With Quote