Features : Successfully received unicode string in Korean
Click [Run] Button
Run python code by Shell command
Request an answer to ChatGPT API and receive it into an external yml file as utf-8-sig
Parse the answer string from the yml file
Future Improvements
Fix critical bugs
Proceed to the next line without waiting for the result of Python code execution through the Shell command
-> Returns a message that the yml document is not created because it is not waited
Read only the first line of the content item in the yml document
Python code error: Unlike standalone execution, a path issue occurs in openpyxl.load_workbook()
Use xlwings instead of openpyxl so that you can interact with Excel sheet in real time without the need to transfer an external yml file between VBA and Python
Features : Successfully received unicode string in Korean
Shellcommandymlfile asutf-8-sigymlfileFuture Improvements
Shellcommand-> Returns a message that the
ymldocument is not created because it is not waitedcontentitem in theymldocumentopenpyxl.load_workbook()xlwingsinstead ofopenpyxlso that you can interact with Excel sheet in real time without the need to transfer an externalymlfile between VBA and Python