Active X problem with Outlook form

Topic

New Reply

I have a form that calls up Excell. I am get the following error: “Active X compenent can’t create object “Create Object” Anybody have any suggestions?

‘-=-=-=-=-=-=-=-=-=-=-=-=-
‘Call Excel
Sub cmdExcel_click()
Set objWSHShell = CreateObject(“WScript.Shell”)
objWSHShell.Run(“excel.exe tabsproddatabaseedgarsecurityterm2001.xls “)
end sub
‘-=-=-=-=-=-=-=-=-=-=-=-=-

Reply | Quote

Replies

How about:

Dim objApp as excel.application
set objApp = CreateObject(“excel.application”)

With objApp
.Workbooks.Add (“tabsproddatabaseedgarsecurityterm2001.xls “)
End With

Reply | Quote

Getting “expect end statement” and points to “set objAdd” line.

Dim objApp as excel.application
set objApp = CreateObject(“excel.application”)
With objApp
.Workbooks.Add (“tabsproddatabaseedgarsecurityterm2001.xls “)
End With

Reply | Quote