Anyone have any luck on this error? I have a VBA code that refreshes 100 other workbooks. It has been working fine but now it doesn't. I get a "Run-time error -2146232576 (80131700)" after the first 3 workbook updates. I looked on-line and got a recommendation to install .Net Framework, which should've fixed the issue but it did not.
See sample workbook and pic of error....thanks
Last edited by KerahJoy; 10-02-2022 at 07:13 PM.
I can only imagine there is something different about the fourth file.
Maybe there are no Pivot Tables, or perhaps the password is different.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are no pivot tables....just tables it downloads to. No sure how that would make a difference. I checked the passwords and they are the same.
Comment out the code for the file that fails and try again. See if it IS just that one file. If you can isolate the file(s) that fail, you can focus on what is different.
I've seen a few mentions of that error being caused by an update (though I haven't seen it mentioned for a while). Sometimes it can be worked around by using a variable for the worksheet, so you might try this: (your code is quite repetitive so I refactored it a bit)
Please Login or Register to view this content.
Rory
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks