While it is easy to have ChatGPT write VBA for you, the process of returning that code to an actual Excel workbook is a different matter.You open the VBE, find the target module, delete the old code, ...
Excel is still my spreadsheet workhorse, but VS Code handles the awkward file-level jobs I don't want Excel touching.
Methods for performing scraping in Excel can be broadly categorized into three types: importing tables using Power Query, building code with VBA, and using AI tools to specify and extract items. While ...