Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error returned RunForzenPython : it is not recognized as an internal or external command, operable program or batch file #2393

Open
Dulaclyon opened this issue Feb 5, 2024 · 7 comments

Comments

@Dulaclyon
Copy link

OS (Windows 11 Pro Operating system)
xlwings version: 0.30.13, Excel and Python (Office 365 for Enterprise, Python 3.12.1)

Describe your issue (incl. Traceback!)

the frozen python exe runs well if clicked independently, but when using RunFrozenPython in VBA, a same error message comes up every time saying, "the exe file is not recognized as an internal or external command, operable program or batch file.", I couldn't understand this, and I then checked the antivirus, seems no blockage on the exe file. Did anyone have similar issue? Thanks.

image

@fzumstein
Copy link
Member

Copy the path and run it directly in a Command Prompt. Does it work?

@Dulaclyon
Copy link
Author

Yes, after copying the path and running it in a Command prompt, everything works fine and the dashboard got refreshed.

image

@fzumstein
Copy link
Member

The VBA shows reprt instead of report

@Dulaclyon
Copy link
Author

Thank you, Felix. I didn't expect a typo to be here.

Another minor issue is that when running the frozen code with VBA below, the dashboard got refreshed quickly, but the cursor is always in a shape of spinning blue circle, it seems that the application is running even after the dashboard got refreshed., but when I force click any cell in the sheet, the running cursor will disappear...

I am wondering if there any line of code I should add..? thank you very much.

image
image

@Dulaclyon
Copy link
Author

It goes the same when I tried to close the sheet, the sheet did not close even after I clicked "close" on the top right of the worksheet.... the spinning blue wheel keep running forever...

@Dulaclyon
Copy link
Author

In order to close the workbook, I have to force quit the Excel in the task manager.....

@Dulaclyon
Copy link
Author

Hey Felix, I don't know the reason, but the issue got fixed with adding two line of code:

image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants