will_scarlet7
asked on
"System Error &H8000FFFF ( -2147418113)" when running VBA
Hi VB Experts,
I'm trying to help someone out with a VBA solution to import Data from custom forms in Outlook to an Excel worksheet. When changing a variable's source from an Object's properties he said he get's the following error:
-> I'm now getting the error message - System Error &H8000FFFF ( -2147418113)
-> and when I press the HELP button on the error mesage I get the following.
-> Visual Basic encountered an error that was generated by the system or an external component.
-> So I guess I might have other problems here. What should I do about that?
Since the help indicates a visual basic problem I thought I'd ask here and see if any of you have an idea what could cause this error.
The link to the question is here in case you have the answer and want his points as well as mine:
https://www.experts-exchange.com/questions/21067402/Debugging-Modifying-VB-Code-for-Macro-in-Excel.html
ThanX!
Sam
I'm trying to help someone out with a VBA solution to import Data from custom forms in Outlook to an Excel worksheet. When changing a variable's source from an Object's properties he said he get's the following error:
-> I'm now getting the error message - System Error &H8000FFFF ( -2147418113)
-> and when I press the HELP button on the error mesage I get the following.
-> Visual Basic encountered an error that was generated by the system or an external component.
-> So I guess I might have other problems here. What should I do about that?
Since the help indicates a visual basic problem I thought I'd ask here and see if any of you have an idea what could cause this error.
The link to the question is here in case you have the answer and want his points as well as mine:
https://www.experts-exchange.com/questions/21067402/Debugging-Modifying-VB-Code-for-Macro-in-Excel.html
ThanX!
Sam
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It will be same for all Automation objects. Be it Outlook or Word or Excel or Access.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ThanX alot for your input! aelatik, I gave you 100 points for confirming and expounding on what Sethi said earlier.
Sure appreciate it!
Sam
Sure appreciate it!
Sam
Thanks for the points friend :-)
ASKER
Hey Sethi, I noticed you also dabble in the Access section. If you have a chance, would you want to take a stab at this one for another 500 points?
https://www.experts-exchange.com/questions/21067967/Database-crashes-when-signed.html
If not, no worries. Sure appreciated you help on this one.
Sam
https://www.experts-exchange.com/questions/21067967/Database-crashes-when-signed.html
If not, no worries. Sure appreciated you help on this one.
Sam
Sorry Sam, I have never done anything like this before in Access, so would not be able to make a wild guess even.
ASKER
ThanX anyway!
ASKER
It seems that he got it working for now, but I will suggest this to help prevent this typ of error in the future.
Would it be the same for Outlook.Namespace? Or is that different?