microsoft visual basic for applications error 400

The WAIT is a VBA function only available in Excel. Hence we can code in such a way that first, we start that executable then let the code wait for 10 seconds (max time required for this executable to run), and then continue the execution again. So, in such a case we know that VBA cannot directly communicate with the executable file. In such cases, you can find out the maximum time required for completing such a task, and then in your code, you hold the execution for that amount of time.įor example, We have a VBA code that can run some other executable (.exe) and after running that executable you need to wait for that executable to complete and then continue the code.

These functions can be quite useful when you need to hold the program to wait for some other process or task (not directly connected or communicable to the VBA engine) that is yet to be completed. Significance of Wait and Sleep Functions in VBA: Difference between VBA Wait and Sleep Function:.Example 2: Halting the code for a user-defined delay by using an InputBox function. It is a little tricky to fix the error 400 as it doesn’t come with any notification that is what is causing it. For users of our software, this error is typically caused by having the add-in file for the Spreadsheet Assistant for Excel 2003 installed as in add-in in Excel.

Example 1: Pausing an application for 10 seconds.Example 3: Using the VBA Wait function to create a program that tells time after every minute (till 10 loops).Example 2: Pausing an application for 10 seconds.Example 1: Pausing a code till 2.00 PM today.Significance of Wait and Sleep Functions in VBA:.

Microsoft visual basic for applications error 400