Running macro in workbooks before copying ranges to Master Workbook

I have been using this guide to merge a range from all workbooks in a folder: http://msdn.microsoft.com/en-us/libr...ffice.12).aspx
(more specifically, the following code

Please Login or Register  to view this content.

I would like to add some VBA so that the macro "CopyRangeFromMultiWorksheets" runs in the workbook before the range is copied.

I think it should be something like

Please Login or Register  to view this content.

but that isn't working.

I would really appreciate any help!

I was looking for the first code - just missing the ".name" - thank you so much!!