Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default permissions needed for excel programming on asp web page

We have a W2K3 server running IIS 6.0 and an intraweb ASP web
application that creates and downloads an Excel 2000 spreadsheet.
Security is set to "windows authentication" and a group of users
(WEBDW) are authorized. Excel 2000 is the only MS Office application
installed on this machine.

The following two extra permissions were made.

Component Services
DCOM Config
Microsoft Excel Application
Launch Permissions (add WEBDW)

c:\program files\microsoft office\office (permissions read/execute for
WEBDW)

This has been working fine for a long time.

There is a need to enhance this application. I'd like to add a macro
and a button. I did so with the following vbscript code.

================================================== ===================
Const xlCellTypeLastCell = 11
Const vbext_ct_StdModule = 1
Dim rng,btn,vbmodule
set rng=ws(1).UsedRange.SpecialCells(xlCellTypeLastCel l).Offset(0, 1)
set btn=ws(1).OLEObjects.Add("Forms.CommandButton.1",, _
False,False,,,,rng.Left,10,75,20)
btn.Object.Name="BtnSaveMark"
btn.Object.Caption="SAVE Mark"
With
xl.ActiveWorkbook.VBProject.VBComponents(WS(1).Cod eName).CodeModule
.InsertLines .CreateEventProc("Click", Btn.Name) + 1, _
"call SaveMark"
End With
set vbmodule=xl.VBE.VBProjects(1).VBComponents.Add(vbe xt_ct_StdModule)
vbmodule.CodeModule.AddFromFile(homedir & "PartsLiability_Macro.txt")
================================================== ===================

This works fine if you login to the web application as an administrator
for the web server. But it does not work for the WEBDW group.

The ASP error is "800a03ec, Cannot insert object". Event Log listed
actual errors of

Access denied attempting to launch a DCOM Server. The server is:
{D45FD2FC-5C6E-11D1-9EC1-00C04FD7081F}

and

Access denied attempting to launch a DCOM Server. The server is:
{000C101C-0000-0000-C000-000000000046}

I changed permissions in DCOM Config for

Component Services
DCOM Config
Microsoft Agent Server 2.0
Launch Permissions (add WEBDW)
000C101C-0000-0000-C000-000000000046
Launch Permissions (add WEBDW)

but now I got Event Log entries of

The Windows Installer Service was successfully sent a start control.

and

The Windows Installer Service entered the running state.

Further, Excel 2000 is messed up. When I do a Start Programs - Excel, I
get

There was a problem starting the Office Assistant. Would you like to
try reinstalling it?

I would not think I need any other Office components installed as
everything works when run by an administrator. It looks like a
permissions issue, but I am not sure what permission. Does anyone know
what permissions are required to run the above code from a web page?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Testers needed for code page : create and mail PDF files in Excel 2007 with the MS PDF add-in Ron de Bruin Excel Discussion (Misc queries) 2 February 28th 09 01:37 PM
Excel Permissions Daniel Smart Excel Discussion (Misc queries) 1 September 19th 08 09:08 PM
Excel Permissions James A Excel Discussion (Misc queries) 1 September 23rd 06 01:49 AM
VBA programming guru needed - HELP! Fredy Excel Programming 0 January 16th 04 08:26 PM
insight about excel programming needed bala Excel Programming 2 September 23rd 03 02:45 PM


All times are GMT +1. The time now is 06:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"