It looks like you're new here. If you want to get involved, click one of these buttons!
Subscribe to our Patreon, and get image uploads with no ads on the site!
There is no 'H' in Aych, you know that don't you? ~ Wife
Turns out there is an H in Haych! ~ Sporky
Bit of trading feedback here.
Base theme by DesignModo & ported to Powered by Vanilla by Chris Ireland, modified by the "theFB" team.
Comments
There is no 'H' in Aych, you know that don't you? ~ Wife
Turns out there is an H in Haych! ~ Sporky
Bit of trading feedback here.
There is no 'H' in Aych, you know that don't you? ~ Wife
Turns out there is an H in Haych! ~ Sporky
Bit of trading feedback here.
I'd write an add-in.
There is no 'H' in Aych, you know that don't you? ~ Wife
Turns out there is an H in Haych! ~ Sporky
Bit of trading feedback here.
Consider powershell or vbscript, again ChatGPT may help.
Good luck!
The I'd make a workbook with the current code in it, and a button. The button fires the file open dialogue box, then runs the code on whatever is opened.
You can probably get OpenAI etc to write the script for you in a few seconds. As mentioned it may take a couple of iterations but it is generally pretty good if you phrase the description of the requirement accurately.
I suppose you could possibly write something to edit the XML underlying the spreadsheet, but that feels like trying to fix a leaking tap through interpretative dance.
Ive tried ChatGPT for VBA, a D the results were mixed at best. It managed a simple task (is this range within or overlapping this range) but with inelegant code. It's attempt to populate an array from a filtered table was just wrong, and even by the third attempt it was still using an RBAR approach.
This is a relatively simple problem by comparison - the core code is written, it just needs to be pointable at other files.