Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Permission denied in CreateObject(Excel.Application")
I am using CreateObject from MS Access to open up an excel workbook. There
were some changes made on my machine but not sure what and now this error appears. Before that it worked fine. Does anyone know what do I need to give permission to to get this command to work? Thanks Leo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Permission denied in CreateObject(Excel.Application")
Show us your code Leo
Is it working if you use this CreateObject(Excel.Application.10") 9 is for 2000 10 = 2002 11 =2003 This small test is working OK for me Dim xl As Object On Error Resume Next Set xl = GetObject(, "Excel.Application") If xl Is Nothing Then Set xl = GetObject("", "Excel.Application") xl.UserControl = True xl.Visible = True End If AppActivate "Microsoft Excel" -- Regards Ron de Bruin http://www.rondebruin.nl "Leo" wrote in message ... I am using CreateObject from MS Access to open up an excel workbook. There were some changes made on my machine but not sure what and now this error appears. Before that it worked fine. Does anyone know what do I need to give permission to to get this command to work? Thanks Leo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ASP: CreateObject("Excel.Application") IIS 6.0 Win2003 | Excel Programming | |||
Movefile "Permission Denied" | Excel Programming | |||
Run-Time error "70" Permission Denied | Excel Programming | |||
Error "Permission denied" when printing Web Browser control from button on userform, | Excel Programming | |||
CreateObject("Excel.Application") - Access denied | Excel Programming |