I have 6 files that i wish to open and run a macro on. I have set up another
file that contains a macro that is intended to runs all six. However it runs
through the macro in the first file and then finishes without starting the
second file.

I'm quite new to macros and obviously missing something here. Help !

Sub Update_PFT_Reports()
'
' Update_PFT_Reports Macro
' Macro recorded 01/06/2006 by Peter Hine
' ChDir "\\Havuksfp01\havantreporting\Daily_reporting\Curr ent"
' Keyboard Shortcut: Ctrl+Shift+U
'
Workbooks.Open Filename:= _
"\\Havuksfp01\havantreporting\Daily_reporting\Curr ent\Consolidated
PFT Daily report back up data.xls"
Application.Run _
"'Consolidated PFT Daily report back up data.xls'!Update_and_save"
Workbooks.Open Filename:= _
"\\Havuksfp01\havantreporting\Daily_reporting\Curr ent\Blocks &
Ultronics Daily report back up data.xls"
Application.Run _
"'Blocks & Ultronics Daily report back up data.xls'!Update_and_save"
Workbooks.Open Filename:= _
"\\Havuksfp01\havantreporting\Daily_reporting\Curr ent\4V3 & 4V5
Daily report back up data.xls"
Application.Run _
"'4V3 & 4V5 Daily report back up data.xls'!Update_and_save"
Workbooks.Open Filename:= _
"\\Havuksfp01\havantreporting\Daily_reporting\Curr ent\Batch & Props
Daily report back up data.xls"
Application.Run _
"'Batch & Props Daily report back up data.xls'!Update_and_save"
Workbooks.Open Filename:= _
"\\Havuksfp01\havantreporting\Daily_reporting\Curr ent\Hose Daily
report back up data.xls"
Application.Run _
"'Hose Daily report back up data.xls'!Update_and_save"
Workbooks.Open Filename:= _
"\\Havuksfp01\havantreporting\Daily_reporting\Curr ent\MMVP Daily
report back up data.xls"
Application.Run _
"'MMVP Daily report back up data.xls'!Update_and_save"
End Sub