Incorporate Excel features in Word

[mtchagoue]

Hi All,

I am trying to incorporate Excel features in Word. I found this program on the net but itis not working when iam trying to run it:
i have the Run-time error '-2147221231 (8004011)':
Automation error
ClassFactory cannot supply requested class from the program:

Private Sub cmdUpdtTime_Click()
HideListBoxes
Set myWB = GetObject("C:\Documents and Settings\archanget\My Documents\Downloads\WordExcelDocs.zip\ExcelCalculation.xlsm")
Selection.GoTo What:=wdGoToBookmark, Name:="DaysOverdue"
Selection.TypeText (myWB.Sheets("PayHist").Range("Payment_Overdue"))
Set myWB = Nothing
End Sub


seems like the error is in the bulk area where i included my own (path)

Thanks for your help

 

[ScottR]

Your path looks like it points to a zip archive rather than a normal, uncompressed folder. Have you tried moving files to a standard folder to see if it resolves the error?

Seems like the obvious place to start.

 

[mtchagoue]

tks it is working now.. i just unzipped it
Tks