Open Excel file, Run Macro, Save File, Close File

[Kendall66]

I need sample code relating to Opening an Excel File, Running a Macro within the file(workbook, then saving the file, then closing the file down. All with one click of the button.

The File will be on a local drive. The Macro will be a basic print macro.


Does anybody have example code relating to this? Would be very helpfull.


Thankyou

 

[SkipVought]

Hi,
Here is a sample...

Sub DoItAll()
    Workbooks.Open "H:\PROJECT\BOM_UploadProcessing\vbatemplates.xls"
    With ActiveWorkbook
        .ActiveSheet.PrintOut
        .Save
        .Close
    End With
End Sub

Skip,
metzgsk@voughtaircraft.com

 

[Guest_imported]

If you add the following sub, your code will be executed automatically when you open the excel file:
Sub Autpen()
ActiveWorkbook.Worksheets("Sheet1&quot.PrintOut
ActiveWorkbook.Save
ActiveWorkbook.Close
End Sub