By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,310 Members | 1,466 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,310 IT Pros & Developers. It's quick & easy.

Excel object "Access denied" error

P: n/a
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.

Aug 27 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.