- Remove From My Forums
-
Question
-
Hello
I have this error pop up from time to time and I haven’t figured out how to fix it. I’ll give some background.
I developed a macro in Excel 2003 that runs a loop where outlook is called and an email is created and sent. The loop can potentially run a hundred times or more sending out that many emails. My computer was the first to run this program and I had no issues
with it. It sent out over a hundred emails successfully. I then copied the program to another user in my office who also has 2003. It’s been running on that machine multiple times successfully. After a couple months I copied it again to another user in
a different city. When he ran it it threw this error message after the first email was generated and sent…it never got to the second email. In all of his attempts it almost always blew up after one email…he claims, though, that one time he ran it it made
it into the 20’s (over 20 emails sent) before the error was thrown. He was using 2007. I tried it on a user in my office who also has 2007 and he was able to send out about 10 emails before the error was thrown. I tried it on another user in our office who
has 2007 and it ran perfectly sending out all the emails that were required to be sent. I then got our corporate help desk involved and the tech tried the program on their computer that has 2007 installed and it sent out 70+ emails before the error was thrown.
The tech was at a loss to find a solution. Finally I installed it on another user in another city who has 2003 running on his machine and it sent out 55 emails before blowing up.Now, sometimes all of the emails are going to the same person (as a test) but
that doesn’t seem to make a difference since the computers that run it successfully don’t seem to have a problem with it. When I googled the error I found it show up several times. Microsoft knows about it and they say the problem occurs when you use a UserForm.
I don’t use a UserForm in my macro so that didn’t help me. The only thing I can think of is that it has something to do with the memory allocation on each computer. Some computers can handle more I suppose. Although I would think the one user I mentioned should
be able to send out more that just one email. His memory can’t possibly be that taxed.Does anybody have any suggestions or have run into this before?
Thanks
Answers
-
Error message starting with &H8 are usually permission type errors. Either a pointer is addressing an area of memory that you don’t have permission to access, or a file permission error. Sometimes it is linked to pushing/puling variables
onto the stack when subroutines are called. This type error may occur if the parameters arren’t the same in the calling routine and a subroutine.I would open the task manager as you run the program and see how many processes are being spawned when the program is running. You may be creating a lot of processes and having some sort of stack issue.
jdweng
-
Marked as answer by
Friday, September 16, 2011 10:38 AM
-
Marked as answer by
I’m almost 100% certain I found a solution to this issue. It may have caused issues for someone else 4 years ago, but it caused issues for me today and I wanted to contribute my answer for anyone else running into the same problem.
I had enabled an «Additional Control» in the Controls Toolbox for Windows Media Player. I think when it loaded in a video file, it overran the memory. This is when I started panicking (company computer and all) and Googling and came across this and a few other articles without a real, fast fix.
The hunch: Once that video file was attempted to be loaded in RAM memory (because that’s how Userforms work) it locked up all the memory Excel would allow before throwing all the errors.
What I tried from other posts in various places: I rebooted a few times (before Googling, even). I tried the Quick Repair of Office from Add/Remove programs, that didn’t work. (I’m using Office 2016.)
So, what worked? I had the idea that maybe I could disable all ActiveX from loading in my file, and Googled that. I got: https://support.office.com/en-us/article/enable-or-disable-activex-settings-in-office-files-f1303e08-a3f8-41c5-a17e-b0b8898743ed and proceeded to disable all ActiveX controls in Excel. I closed the file out. Can’t recall if I closed Excel but I probably did.
Then I loaded up my file. (ActiveX is totally disabled at this time.) No errors! I went to VBA (ALT + F11), opened my UserForm, and the video I had inserted and could not remove was just… gone. I saved the file. I closed the file.
I opened Excel. I re-enabled ActiveX in the Trust Center. I opened my file. Still, no more video on my UserForm (I didn’t need it anyway) and no «Unspecified» (memory) errors! And, I can save again!
I hope this solution persists… if not I’ve got some «splainin’ » to do. So far, I’m designing and using the Userform, and saving the file, with no issues whatsoever. I think it worked!
-
Вопрос
-
Hello, on excell 2013 when running a VBA macro I have the following error message: Microsoft Visual Basic for Applications = System Error & H80004005 (-2147467259), Unspecified error, how could I fix this problem , Thank you
-
Перемещено
Emi ZhangMicrosoft contingent staff
1 марта 2018 г. 5:33
Move
-
Перемещено
Все ответы
-
Hi,
This is the forum to discuss questions and feedback for Microsoft Excel features, I’ll move your question to the MSDN forum for Excel
https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev
The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you
for your understanding.Regards,
Emi
Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact
tnsf@microsoft.com.
Click
here to learn more. Visit the dedicated
forum to share, explore and talk to experts about Microsoft Teams. -
Hi,
I’m afraid you need to provide your code related with the issue.
It would be hard to make some suggestions only by «Unspecified error».If you don’t want to provide code, please search web by «System Error & H80004005 (-2147467259), Unspecified error», and you will find some articles.
Regards,
Ashidacchi
-
Hi,
Thank you Ashidacchi !
Wich code you mean ?
-
Hi,
Thank you Ashidacchi !
Wich code you mean ?
Hi,
«Which code»?? It’s only you who write code and encounter error.
I don’t know. so, I wrote «provide your code
related with the issue«.
Regards,
Ashidacchi
-
Hi,
There is the error «System Error & H80004005 (-2147467259)» it hasn’t any error code.
Thx
-
Hello Papichou,
>>on excell 2013 when running a VBA macro I have the following error message: Microsoft Visual Basic for Applications = System Error
& H80004005 (-2147467259),You said you got error when running a VBA macro, the code in the macro is what we want to know. Why do you say it hasn’t any code? Could
you detail when will the error occur?Best Regards,
Terry
MSDN Community Support
Please remember to click «Mark as Answer» the responses that resolved your issue, and to click «Unmark as Answer» if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to
MSDN Support, feel free to contact MSDNFSF@microsoft.com.
|
|
[RESOLVED] System Error &H80004005 (-2147467259). Unspecified error
Originally Posted by Coding
First i did looked at other threads and all the answer specified were didn’t helped, as i was getting this error only for specific SQL execution. Whenever i am trying to run SQL with select * from dual i was getting below error message.
Below is my VBA Code
Set cn = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
StrCon = "Driver={Microsoft ODBC for Oracle}; " & _
"CONNECTSTRING=(DESCRIPTION=" & _
"(ADDRESS=(PROTOCOL=TCP)" & _
"(HOST=dhotname)(PORT=1521))" & _
"(CONNECT_DATA=(SERVICE_NAME=APSQ))); uid=username; pwd=password;"
cn.Open (StrCon)
vSQL = "select * from request"
rs.Open vSQL, cn
asked Apr 1, 2016 at 21:52
7
I am putting solution here, which worked for me. In other similar post it was more over connectivity issue, but in my scenario it was one of the column in table i am trying to access. In my table i had column which is having timeStamp and that’s the column was causing above error, when i removed or used formatting for that column it worked without exception. I wonder if this error would have been more explanatory, as i spend time on trying other stuff instead of just fixing my SQL.
Solution:
Set cn = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
StrCon = "Driver={Microsoft ODBC for Oracle}; " & _
"CONNECTSTRING=(DESCRIPTION=" & _
"(ADDRESS=(PROTOCOL=TCP)" & _
"(HOST=dhotname)(PORT=1521))" & _
"(CONNECT_DATA=(SERVICE_NAME=APSQ))); uid=username; pwd=password;"
cn.Open (StrCon)
vSQL = "select request_id,user_name from request"
rs.Open vSQL, cn
Now if you look at above example i have specified exact column names, the issue here was REC_DT column which had time value. Either you can convert that value or remove column, for me that value was not required so just removed from my SQL and it worked.
answered Apr 1, 2016 at 21:55
AkshayAkshay
6472 gold badges17 silver badges37 bronze badges