Workbook_open

[vmjan02]

I have this code and is all perfect, only need a modification so that at a time of saving the files on respective path, it should ignore or disable the workbook_open module at the time of saving

ThisWorkbook.SaveCopyAs in this part it should not save (ref screen shot)

Sub SavefinalOutput1()
    Dim SavePath As String
    Dim SavePath1 As String
    Dim fileName As String
    Dim NewWorkbook As Workbook

    SavePath = ActiveWorkbook.Path & "\" & "AEmailToDOFiles" & "\"
    SavePath1 = ActiveWorkbook.Path & "\" & "JIRA_Final_Report" & "\"
    
    
    fileName = "Jira Daily Report-" & Sheets("Report").Range("c11").Value & ".xlsm"
    ThisWorkbook.SaveCopyAs SavePath & fileName
    ThisWorkbook.SaveCopyAs SavePath1 & fileName
    
End Sub

screen shot :- this part should not be saved in part of ThisWorkbook.SaveCopyAs

 

[rlv01]

You are talking about writing code to manipulate the VBA code modules in your project, an advanced topic. Here is some reading to get you started.

Programming In The VBA Editor

www.cpearson.com

 

[vmjan02]

perfect thanks for the help it great,