Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using VB.NET to open and read info from Excel spreadsheets using code
similar to this: Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Dim xlBooks As Excel.Workbooks Dim xlSheets As Excel.Sheets Dim xlSheet As Excel.Worksheet xlApp = New Excel.Application xlBook = xlBooks.Open(strPath & "SheetList.xls", True) xlBooks = xlApp.Workbooks etc. This used to work just fine, until I was trying to get similar code running through ASP.NET, and was fiddling with permissions trying to get that to work. Having given up on that, I now find that the VB.NET app, which runs locally, is failing with an "access denied" error, which happens when it tries to create the Excel object (xlApp = New Excel.Application). So clearly I have screwed up access permissions. I could use some help un-screwing this. I have already tried uninstalling and reinstalling the app and the whole Office suite, I have tried clearing out anything in the registry that might apply, and I have re-set Windows permissions in the folders this stuff is in. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"access denied" message when open Excel, MS 2007 | Excel Discussion (Misc queries) | |||
How do I recover from "Access Denied" in Excel? | Excel Discussion (Misc queries) | |||
Excell files showing "Read Only" access denied | Excel Programming | |||
CreateObject("Excel.Application") - Access denied | Excel Programming | |||
"Programmatic Access to be Denied" displays when running macro on excel in XP | Excel Programming |