Microsoft Office Forums - View Single Post - Need Help with this Macro-Partially Working

rsrasc · 09-10-2020, 03:59 AM

Hi all,

Here are the files as suggested.

The below code is part of the path that I'm using to open up the files. Please update it if necessary so you can open it.

Code:

Sub OpenUpFiles()
Workbooks.Open ("Z:\FY21 Budget\SSX Expenses\025 FY 2021 Expenses-SSX-Budget.xlsx"), UpdateLinks:=0
Workbooks.Open ("Z:\FY21 Budget\SSX Expenses\102 FY 2021 Expenses-SSX-Budget.xlsx"), UpdateLinks:=0


Application.DisplayAlerts = False

With ActiveSheet
        .Cells.Font.Name = "Calibri"
        .Cells.Font.Size = "10"
        
    End With

End Sub

Again, thank you for your support!

Regards!