macro not working on some computers

[Babynana]

Hello, I'm new to everything. We had a person that use to work for us that wrote some macros to scrape information from Rocket Software's Bluezone. Last Tuesday, most of the computers wouldn't let the excel script run. There were 3 that would. One a new desktop, one an older desktop and my laptop. On the ones that it isn't working on, it is like the excel sheet doesn't connect to the bluezone anymore. I have looked at every setting I can think of and they all appear to be the same with all the same trusts. I received an overflow error but it looks like all the integers are already changed to LONG which is something I read with overflow errors. Any one have an ideas I can try? Thank You

 

[Babynana]

That is what I think but can’t figure out what it is. I’ve checked all the settings and they appear correct.

 

[Babynana]

Could a visual c++ update affect a macro? Now I'm down to one computer. THis morning it was working on my laptop. I had to reboot and when it came back up, it would no longer run the script.