My VBA code opens another workbook and executes commands and then closes the workbook and closes my VBA workbook. This works before converting the VBA into an exe. After that the newly created exe named “My Application” remains open even after the VBA is completed. I have to manually close the “My Application” workbook. How do I accomplish this within the settings of the exe or in the VBA.
Try this:
Thanks that worked to close the application when task are completed. But the original xlsm opens on execution, although it closes on comoletion. How do i stop the xlsm from showing at all. I only want the userform to be shown.
Maybe with VBA you can hide the workbook?