Strange error message - Permission Denied???
Well MS Outlook 2000 has come up with another strange error message that has
nothing to do with what is going on so I wanted to see if anyone else has
had this message and knows what to do.
Dim myolapp As Application
Dim sendToContact As ContactItem
Dim myItem As MailItem
Dim oaExcel As Excel.Application
Set oaExcel = Nothing
Set oaExcel = New Excel.Application
oaExcel.Workbooks.Open "f:\survey business\anyfilename.XLS"
oaExcel.Visible = True
Many times it works great and then after running several times it decides
that it wants to take a break and starts sending me the message Permission
Denied on the excel.workbooks.open line. Naturally there are NO permissions
on the file except Full Control for Administrator - me and there are NO
permissions on the folders above it at any level. I have even used task
manager (windows 2000 Profess) and KILLED dead the Excel processes and still
no change. Go away for a couple of hours and come back and the same program
runs fine. This has happened several times over the last 2 or 3 days and is
getting very annoying. No other process is accessing these files. So it is
obvious to the casual observer that Outlook is generating its error message
but has nothing to do with permissions as defined by W2K or Office 2K.
I would certainly appreciate a little help here - naturally these problems
only occur when I am trying to get something done on a schedule.
Thanks
George Mizzell
MCSE - W2K and MCSE - NT
