Need Help with this Macro-Partially Working

rsrasc · #6 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!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Deleting rows with partially redundant data	Noah14	Excel Programming	1	09-19-2014 11:46 PM
partially delete agenda items	Gerreth	Outlook	3	03-13-2012 05:06 AM
Partially Obscure Video in PowerPoint	KBsay	PowerPoint	0	10-05-2010 12:49 PM
Problems working in a partially protected document	Autumn	Excel	0	02-11-2009 03:46 PM
Drawing partially off printed page	DLRA	Visio	0	09-26-2006 10:40 AM