eddiev1972
New Member
- Joined
- Mar 22, 2010
- Messages
- 38
This may be more of a windows network account issue, but I wanted to start here as the user-base is knowledable and friendly!
I have some VBA Apps that work fine under almost every circumstance.
However, if the user has a Windows network account that has some sort of MicroSoft Outlook Email Archiving feature turned "on" (I don't have all the details from our network administrator) they will recieve a run-time error 9 as soon as the VBA app attempts to open an excel workbook on a network drive. (I don't know what would happen if the workbook was on a local drive)
There is nothing unusual in the procedure that is causing the runtime error. It is occuring on workbook.open method. It also works perfectly for those uses that don't have this archiving feature.
Is there any known conflict?
The user is has Windows XP, the network runs Windows Server 2003 for small business and we are using MicroSofte Excel 2003
Thank you for any guidance or assistance.
I have some VBA Apps that work fine under almost every circumstance.
However, if the user has a Windows network account that has some sort of MicroSoft Outlook Email Archiving feature turned "on" (I don't have all the details from our network administrator) they will recieve a run-time error 9 as soon as the VBA app attempts to open an excel workbook on a network drive. (I don't know what would happen if the workbook was on a local drive)
There is nothing unusual in the procedure that is causing the runtime error. It is occuring on workbook.open method. It also works perfectly for those uses that don't have this archiving feature.
Is there any known conflict?
The user is has Windows XP, the network runs Windows Server 2003 for small business and we are using MicroSofte Excel 2003
Thank you for any guidance or assistance.
