I am trying to come up with code that will run a macro in a workbook where
the path and name of the workbook are in a cell reference. I have tried the
following with no luck. The path to the file is located in cell F36 of
worksheet, "Customize" and the name of the file is located in cell F42. The
name of the macro is "ClearTotalSavings". Any help from one of you gurus
would sure be appreciated.

Application.Run "'" & Workbooks(Sheets("Customize").Range("F36").Value) &
"\" & Sheets("Customize").Range("F42").Value & "'!" & "ClearTotalSavings"

I use the following code to open a particular workbook using entries in the
same cells and it works just fine, so I know I am close. Thanks in advance.

Workbooks.Open Filename:="" & Sheets("Customize").Range("F36").Value & "\" &
Sheets("Customize").Range("F42").Value & "", _