JMURRAY
02-07-2011, 01:09 PM
I am having a problem returning control to a workbook macro after it calls another macro in a different workbook using the application.run function. The code in the originating workbook is:
Sub CombineFiles()
'call the workbook to pick up and combine all good and fixed files and move them to the integration point.
Sub CombineFiles()
'call the workbook to pick up and combine all good and fixed files and move them to the integration point.
'opening workbook
MsgBox " Going to Combine workbook"
Workbooks.Open FileName:="V:\2011 supply issued\Upload Processor\COMBINE_FILES.xlsm"
Application.Run "COMBINE_FILES.xlsm!GetCleanedFiles"
Application.Run "COMBINE_FILES.xlsm!SummurizeSheets"
MsgBox "Back from combine workbook"
End Sub
It runs both macros fine but does not show the Message from the MsgBox line.
Sub CombineFiles()
'call the workbook to pick up and combine all good and fixed files and move them to the integration point.
Sub CombineFiles()
'call the workbook to pick up and combine all good and fixed files and move them to the integration point.
'opening workbook
MsgBox " Going to Combine workbook"
Workbooks.Open FileName:="V:\2011 supply issued\Upload Processor\COMBINE_FILES.xlsm"
Application.Run "COMBINE_FILES.xlsm!GetCleanedFiles"
Application.Run "COMBINE_FILES.xlsm!SummurizeSheets"
MsgBox "Back from combine workbook"
End Sub
It runs both macros fine but does not show the Message from the MsgBox line.