Power Automate Desktop (PAD)ソースの共有

Ways to Make Money
In this era of advanced IT, there's still a pervasive and challenging issue faced by companies worldwide. It's the problem of "continuing to use systems created by predecessors without the ability to analyze them." For instance, if an employee uses Excel VBA (macros) to streamline traditional tasks. Once the creator leaves the job, it often happens that no one else can properly analyze it. It's a situation where the tool is essential for work, but no one understands its inner workings. This business model involves automating ChatGPT to solve this problem and earn revenue.

Is It Really Profitable?
Upon searching for "VBA Code Analysis" jobs on sites like freelancer.com, opportunities ranging from $50 to $300 were found. From this, we see that creating a system for automatic VBA analysis and producing quality analysis reports for these jobs could be profitable. Moreover, since ChatGPT allows output in different languages, you can do business worldwide.

The Big Picture
(1) Extract VBA from Excel files
(2) Pass the extracted VBA to ChatGPT for generating an analysis report
(3) Automate (1) and (2) using an automation tool

(1) Extract VBA from Excel files
Step 1: Install Python
(We will use the 'oletools' library in Python)
Step 2: Execute the following in the command prompt

pip install oletools
olevba "+ファイルパス+" > result.txt

(2) Pass the extracted VBA to ChatGPT for generating an analysis report
We will use ChatGPT's "AdvancedDataAnalysis" feature.
(Available with the $20 per month ChatGPT Plus subscription)
Upload the VBA file using the '+' button below, and request analysis.

SS3.png
For very long source codes, they cannot be accepted just by entering in the text box. Therefore, uploading the VBA source code using the "AdvancedDataAnalysis" feature becomes necessary.

(3) Automate (1) and (2) with an automation tool
By automating (1) and (2),
we aim to create a situation where simply placing an Excel file in a specific location will automatically generate an analysis report.Details on the specific source code and methods will be in the next article!