| [reply] |
Try the following keywords for Google: Win32 OLE 1403 error. Those four words gave me over 300 hits, many of which were relevant.
For even more help, go to Google Groups (groups.google.com) and enter those same keywords. There is likely to be much information concerning this error number. Chances are very good that someone else ran into the same problem, and that there will be an answer for you.
| [reply] |
I do not know off hand. Have you tried to google it? I find lots of help for errors messages that way.
Lane
| [reply] |
I didn't get any explanation for the error in google
| [reply] |
| [reply] |
your other thread on this problem (Excel 2003 + Perl) says this fails when you run this through asp?. Is this still the case?
A quick google shows this error to be associated with not using a full file path, and permission problems. As you are using a full path, I'd suggest you print the result of -w to see if you can write to the file.
if (! -w $savename) {
print "uh oh\n";
}
---
my name's not Keith, and I'm not reasonable.
| [reply] [d/l] |
I tried printing as u said
if (! -w $savename) {
print "uh oh\n";
}
to a test.txt file. it writes. But i didn't get what u are suggesting?
| [reply] [d/l] |
-w is a file test operator. It tests to see if the running script can write to the specified file. I suggested this because I suspect your export might have failed because it can't write to your output file, and is giving you a misleading error message.
If you've run this and the print statement ran then you could have a problem with file permissions, or just have a bad path. Although thinking about it, -w can only return true if your file already exists, so may not be useful to you.
try temporarily adding
open TEST, ">>$savename" or
print LOG "Couldn't open file for appending: $!\n";
close TEST;
That's a better test to see if you've got permission problems, and any error will be logged.
---
my name's not Keith, and I'm not reasonable.
| [reply] [d/l] |