4,381 questions
i have a microsoft visiual basic error on a excel program
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 93%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGT%3C/text%3E%3C/svg%3E)
Ginger Tims
20
Reputation points
i have an error coming up all of a sudden in a excel program that i have been running for a while. it reads MICROSOFT VISUAL BASIC FOR APPLICATIONS System error &H80070057(-2147024809) The parameter is incorrect. I ran an update two days ago but tryed to uninstall it with no change
Microsoft 365 and Office | Development | Other
{count} votes
-
Olaf Helper 47,441 Reputation points2024-02-19T07:25:28.27+00:00 Please post the complete error message and the relavant part of your VBA code.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 68%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Marcin L 0 Reputation points2024-02-20T08:39:14.3333333+00:00 This is a common problem in Excel, it randomly renders file unusable. The solution came from stackoverflow: open the VBA code module and then selected Debug then Compile VBAProject. Try it.
Olaf, I have added the error message screenshot for you. There is no relavent part of VBA code, it's the excel problem, not the user code itself. It can happen even with files that have extremly easy and small vba codes (like refresh all pivot buffers). The file is working, but the next morning there is this error - without any change in the file itself.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 70%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Jenny Crittell 0 Reputation points2024-02-22T20:45:13.5466667+00:00 I have the same issue. An Excel file we were using for years stopped working two days ago. The Debug then Compile VBPProject did not work.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(182.40000000000003, 28.999999999999996%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Mark H 0 Reputation points2024-02-23T06:49:59.4333333+00:00 Also have the same issue.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 89%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMV%3C/text%3E%3C/svg%3E)
Michel van den Berg 0 Reputation points2024-03-01T13:54:49.9466667+00:00 Also having the same issue.
Sign in to comment
Sign in to answer