General information
Category:
Object Oriented Programming
>Using Office2000 SR1
>The error 1426, says "ole error code 0x80030005:access denied" for the command: "copy to cFile type xl5"
>
>gsUserPath = '\\appserver\folder\folder\'
>cFile = (gsUserPath+'ExcelTrkr'+lcYearNum+lcMonthNum)
Generally, "access denied" means that the file is in use somewhere. Couple of things to check...is it already open in Excel while trying to write to the XLS file? If it doesn't seem like it, close down all the occurrences of Excel anyway. Then check your task manager, and see if there are any Excel processes (go ahead and delete the processes if there are any). Try again. Excel is really prone to staying open and orphaned, and that may hang on to that file. This will be more prevalent during development.
- della
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only