I have five Excel data sheets I transferred to Numbers due to Microsoft using costly cloud. Four transferred well but one is a macro. Macros don't work in Numbers so is there a way to write a script in/for Numbers to do what macros do in Excel (Basic language)?
Mac Pro, macOS 11.6
In most cases, yes. The script, written in Applescript, would be external, and would be activated with a menu choice or a keystroke combination.
SGIII is the most likely participant here able to write the script, but will need further details on the Excel macro being used, and would probably appreciate a screen shot of the Excel docuent as well.
Regards,
Barry
AppleScript is very different from VBA. You launch it from outside the app via a click or a keyboard shortcut. How well it can meet your needs very much depends on the specifics of your document and what you are trying to do.
SG
Quite Right but I'm reluctant to put the whole script on the thread as it quite lengthy. Something like 335 lines pin Excel. There does appear to have some redundancy. I did this about 15 years ago and am now attempting to see if numbers can handle the Excel stuff.
Let me look into AppleScript first be fore I do anything else.
Yes, thanks. I very much expected that and will try to learn as I work it. Like when I try to save what I've done, get an error message stating cannot save Expected end, got unknown.
I think what we're saying is that for scripting (both in VBA and AppleScript) specifics are needed.
Thus far none have been provided. "What I've done" is a total mystery.
SG
Well, all I can say then is good luck with your project!
Not enough here to suggest anything meaningful.
SG
Would you be willing to examine the lines of code
I know it's difficult to work someone else's problem but we naive people do need help now and then so please continue this thread
Does/can Numbers use macros and/or how does it?
