Save,close and open workbook

[cagataybaser]

Hello everyone,
I have an excel sheet which has custom UI ribbon inside and I need to save,close and reopen it for refreshing ribbon.
Thank you

 

[Andrew Poulsom]

Try this (in another workbook of course):

Sub Test()
    Dim wbName As String
    With ActiveWorkbook
        wbName = .FullName
        .Close SaveChanges:=True
    End With
    Workbooks.Open wbName
End Sub

 

[cagataybaser]

Thank you for the quick reply ! There is a problem,When I run this macro it closes but it doesnt open again and it doesnt save I dont know why and Is there anyway to reopen itself?

 

[Andrew Poulsom]

Where have you put the code I posted?

 

[cagataybaser]

ADVERTISEMENT

I put inside of macro the same workbook which I need to reopen because I dont want to use another workbook to do that.

 

[Andrew Poulsom]

Does this work for you?

Sub Test()
    Dim wbName As String
    With ThisWorkbook
        wbName = .FullName
        .Save
    End With
    Workbooks.Open wbName
End Sub

 

[cagataybaser]

It worked ! thank you very much