jmutsche
11-15-2013, 12:34 PM
question: how would I go about running a macro named sub matt () it is located in the file that I have opened in this macro shown below, but I sure can't for the life of me figure out how to get it to run. that is step one once that is answered I have one more question.
thanks in advance.
Sub Macro1()
fname = "S:\Supervisor\Productivity\" & Year(Date) & "\" & Format(Date, "mmmm") & "\" & Format(Date, "mmmm") & " " & Year(Date) & " Productivity Tracking Results_V2.0.xlsm"
Debug.Print fname 'uncomment this line and check the flename in the immediate pane.
Workbooks.Open Filename:=fname, UpdateLinks:=0
wbname = ActiveWorkbook.Name
Sheets("Sheet1").Select
ThisWorkbook.Activate
Workbooks(wbname).Activate
End Sub
thanks in advance.
Sub Macro1()
fname = "S:\Supervisor\Productivity\" & Year(Date) & "\" & Format(Date, "mmmm") & "\" & Format(Date, "mmmm") & " " & Year(Date) & " Productivity Tracking Results_V2.0.xlsm"
Debug.Print fname 'uncomment this line and check the flename in the immediate pane.
Workbooks.Open Filename:=fname, UpdateLinks:=0
wbname = ActiveWorkbook.Name
Sheets("Sheet1").Select
ThisWorkbook.Activate
Workbooks(wbname).Activate
End Sub