Sudden/unexplained Run-Time 7 error

ok, so this one has me baffled, i've got a workbook with a lot of code in it, it's been working fine for a long time (with one minor unrelated issue) and was working fine on thursday, and yesterday it started throwing the following error when running one procedure....

Run-time error '7':

Out of Memory

I've checked the code, nothing had changed, and all seems ok, the calling procedure i will also list below, but also seems fine.

There literally has been no changes between thursday and now that should have affected this, a couple of drivers for phone connection, multibit bitcoin program install, flash player update and that's about it, but, to be sure i've rolled the OS back to the 7th, and it is still failing.
I've checked the Internet Explorer settings, and as far as i know, nothing changed in there either that would affect it connecting out

OS: Windows 7 64 bit
Office 2010 64 Bit
System RAM 32GB


here's the procedure that's failing......

Please Login or Register  to view this content.

I've marked the line it errors at, with red text

and here's one of the procedures that calls it

Please Login or Register  to view this content.

by placing msg boxes at various points, i can see the correct data is being passed to the routine, and i know i have the 'On Error Resume Next' line commented out, that was so i could find out why the comments were not showing.

this is an example of the completed line that gets the images, and also the line it's failing on

Please Login or Register  to view this content.

anyone got any ideas ? because i don't understand this one

hard coding it failed, already tried that, and also changing it to https as that seems to be what it redirects too.

havent tried the private sub, will try that and post back. EDIT: I read that bit wrong, yes i hard coded the address in, then changed the item in the cell using it's drop down list, that's what triggers the change and then the update comments chart code.

when this is failing with the "Resume Next" code in play, you see a comment indicator appear and then vanish from each cell in the range, stepping down through the column, sometimes it gets to the end, sometimes it doesn't, and then at the stopping point, if you have the vba editor open, it brings that to the top most view status, if you dont have it open, it opens it briefly then closes, just long enough for you to see the icon open in the task tray then close, this too is new

i'm going to try and run the file on another machine later and see if it's my office install that is knackered

hmmm, never thought about the temporary internet garbage, i'll try that too, going to start out wide and narrow down on this, because of the wide restrictions and other trigger code in this workbook, i'll go for this...

1. try your stand alone test sub in a new workbook
2. clear internet crap
3. will try to message box the link it's auto compiling, i did use message boxes previously to check data being passed, and the error code generated, but i didn't try and put the link as text in a message box, that might be worth a try
4. try different machine
5. i'll send you the entire work book, but i'll need to remove sensitive data from it first.


be back in a bit

Ran CCleaner, cleaned out a fair bit of garbage, re-ran the stand alone routine in a new workbook, same error

no, that was what i was about to do, also, because this file is on version 34, i have numerous older ones not used for a while, that whilst have issues or old code, do have this comment code in, and they were failing too.


off to reboot now and grab a coffee

hyperlink on it's own works

excel file on different machine (32bit version) works fine.... i doubt it's a 32 vs 64bit version issue as the file was written in the 64bit version

just rebooted, going to try the stand alone code first, then my file

standalone vba code failed
so did my file
so did textbox method


all return out of memory error

that looks like my only option, complete re-install of office, but i am at a loss as to why system restore failed to fix the issue

thank you btw, for your help with this

I hope so too, looks like i'm going to be a busy bunny the next few days, re-installing and updating office,
and then spending a huge chunk of time re-installing add-ins and reseting all the settings i've spent ages adjusting


I am beginning to suspect that the culprit to my problems, may indeed be this file, in particular the one issue it has with windows hooks, and one that doesn't release right which is why i'm reluctant to post the whole file for people to look at
Think i might have to isolate the code that's involved and post it up to see where i've gone wrong, i'd always assumed i'd got something wrong in the 64bit side of the code, and that it would work in 32bit,
but on my test of this comments issue earlier on my other machine (32bit), i tested the other thing and it crashed the same, so looks like i have something else wrong, but it's above my abilities to fix now