I am new to Visual Basic, basically trying to do something for renaming multiple PDF's. The code I have works fine in Excel on Windows, but on a Mac I get error messages. Does anyone know why or what would need to change for this code to run fine on a Mac? Latest versions of Excel Office 365 on Mac latest updates Ventura.
Got a tip for us?
Let us know
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
Visual Basic in Excel works different Windows then Mac?
- Thread starter wonderings
- Start date
- Sort by reaction score
Microsoft:
"Unlike other versions of Office apps that support VBA, Office 2016 for Mac apps are sandboxed.
Sandboxing restricts the apps from accessing resources outside the app container. This affects any add-ins or macros that involve file access or communication across processes. You can minimize the effects of sandboxing by using the new commands described in the following section."
https://learn.microsoft.com/en-us/office/vba/api/overview/office-mac
"Unlike other versions of Office apps that support VBA, Office 2016 for Mac apps are sandboxed.
Sandboxing restricts the apps from accessing resources outside the app container. This affects any add-ins or macros that involve file access or communication across processes. You can minimize the effects of sandboxing by using the new commands described in the following section."
https://learn.microsoft.com/en-us/office/vba/api/overview/office-mac
