Gary,
Try
oExcel.Application.Run("Chart_macros.xlm!DisplayChartForm")

I know it works from an open workbook.
J.D.

>I am trying to execute an Excel macro by using the following line of code >(based upon Visual Basic's help on the
> Run command):

> oDatExlMacro = oExcel.Run("Chart_Macros.xlm!DisplayChartForm")

> I get the following error when this line of code is executed:

OLE lDispatch exception code 0 from Microsoft Excel: ?...