Permission denied to create object (VB6, Excel & Acces 97)

Topic

New Reply

I am running a VBscript in a Outllook form. When i get to this section I am having problems on this machine:
‘Call Excel
Sub cmdExcel_click()
Working
update1
update2
forward1
Set objWSHShell = CreateObject(“WScript.Shell”) ———– Getting error at this point __________________
objWSHShell.Run(“excel.exe tabsproddatabaseedgarTerminationmasterterm3.xls”)
end sub

get: Microsoft VBscript runtime error: Permission denied: ‘CreateObject’ – not sure what to do about this.

Reply | Quote

Replies

Perhaps the Scripting Host is disabled or not installed on the system. Try

Sub cmdExcel_click()
Dim xlApp
Set xlApp = CreateObject(“Excel.Application”)
With xlApp
.Workbooks.Open (“tabsproddatabaseedgarTerminationmasterterm3.xls”)
.Visible = True
End With
Set xlApp = Nothing
End Sub

Andrew C

Reply | Quote

Perhaps the Scripting Host is disabled or not installed on the system. Try

Sub cmdExcel_click()
Dim xlApp
Set xlApp = CreateObject(“Excel.Application”)
With xlApp
.Workbooks.Open (“tabsproddatabaseedgarTerminationmasterterm3.xls”)
.Visible = True
End With
Set xlApp = Nothing
End Sub

Andrew C

Reply | Quote

I believe the Windows Script Host is “not safe for scripting” within the meaning of the security model. If you have high security for Outlook messages, which of course you should, it’s possible that this code will not run until published to a trusted form library on Exchange Server. However, I don’t use Exchange, so don’t take my word for it.

Reply | Quote

I believe the Windows Script Host is “not safe for scripting” within the meaning of the security model. If you have high security for Outlook messages, which of course you should, it’s possible that this code will not run until published to a trusted form library on Exchange Server. However, I don’t use Exchange, so don’t take my word for it.

Reply | Quote