Step1: You need to create an AppleScript file to call in VBA.
Excel library for mac how to#
If you keep reading the following, then I can give you a sample of how to make it work. The good news, now we have AppleScriptTask since Office for Mac 2016. So, even you have 2011, it won't let you open a folder in Finder. However, it is deprecated due to restrictions of the sandbox on Mac, and although It can do some simple stuff like displaying messages, etc., it cannot "tell" what to do to other applications Like Finder anymore. There is (was) a beautiful(!) function called MacScript in VBA (Office for Mac 2011). I'm thinking it's a simple one line command but I can't figure it out.Ĭlick to expand.It was a simple one-line command before, but not anymore This would the last function of the macro. Then he closes Finder and everything's back to normal. The user then goes thru the files and manually deletes the ones he doesn't want anymore just as if he was in Finder (he IS in Finder). What I want to happen is after the copy is made and put in the backup directory I need code to pop open Finder at the Backups directory, showing the user all the files in that dir. What happens is after a while the Backups directory gets cluttered with backup files. I know the path where I put it and it's always the same directory. The macro is names "MakeDatedBackup and thats what it does. I have a macro that takes the open excel file and copies it to another ("Backups") directory with a new filename that includes today's date. I'm kinda embarrassed to ask this question but I've spent an hour doing searches and I haven't found the answer.Īnyway- Running VBA on a macbook pro w/ Big Sur.
0 kommentar(er)
