VBA - Opening Word Causes VBA Error

[Rex2024]

I have a userform in VBA that reaches into a different application and collects data based on user commands.

When you have the userform open, if you open any Word document, save the file, and then attempt to run the VBA commands I get a:

"Run-time error '3':

Return without GoSub.

Why would saving a Word document cause VBA to fail?

    sEntry = "NA/" & sEmp
    Response = Sabre1.Entry("", sEntry, False)

 

[ChrisFoster]

The "Return without GoSub" error message typically occurs when there is a "Return" statement in the VBA code that is not preceded by a corresponding "GoSub" statement. This suggests that there may be an issue with the control flow of the VBA code in your userform.

 

[Rex2024]

The "Return without GoSub" error message typically occurs when there is a "Return" statement in the VBA code that is not preceded by a corresponding "GoSub" statement. This suggests that there may be an issue with the control flow of the VBA code in your userform.

So absolutely. I agree with this in general.

But the code works fine until the separate application Microsoft Word is opened, saved, and closed.

Then the VBA code throws the error.

 

[ChrisFoster]

One possible explanation is that by saving the Word document is causing the Word application to take focus away from your userform, and that when your VBA code tries to execute the Sabre1.Entry method, it is not able to access the necessary data or resources because the focus has been moved to the Word application.

One way to test this would be to add some code to your VBA script that explicitly sets the focus back to your userform before attempting to execute the Sabre1.Entry method. You could try adding a line of code like:

UserForm1.SetFocus

Where "UserForm1" is the name of your userform. This should ensure that the focus is set back to your userform before executing the Sabre1.Entry method.

If this does not resolve the issue, you may need to investigate other potential causes of the error, such as issues with the way that your VBA code is handling events or managing resources.

 

[Rex2024]

One possible explanation is that by saving the Word document is causing the Word application to take focus away from your userform, and that when your VBA code tries to execute the Sabre1.Entry method, it is not able to access the necessary data or resources because the focus has been moved to the Word application.

One way to test this would be to add some code to your VBA script that explicitly sets the focus back to your userform before attempting to execute the Sabre1.Entry method. You could try adding a line of code like:

UserForm1.SetFocus

Where "UserForm1" is the name of your userform. This should ensure that the focus is set back to your userform before executing the Sabre1.Entry method.

If this does not resolve the issue, you may need to investigate other potential causes of the error, such as issues with the way that your VBA code is handling events or managing resources.

This makes sense.

I will attempt this and post if it works! Thanks.