Stop searching for VBA code online. Learn more about AutoMacro — A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users! Note: opening a workbook in ReadOnly mode prevents the file from being saved.
excel - "Save As" Macro (vba) on mac - Stack Overflow
To save the file you will need to use Save As and save the file with a different name. Above, we identified all the ways to specify which workbook to save. You can use those exact same methods to identify workbooks when using Save As. Save As behaves similarly to Save, except you also need to specify the name of the new file. In fact, Save As has many potential variables to define:. A full description of all of the SaveAs arguments is included below.
For now we will focus on the most common examples. Note: These arguments can be entered as string with parenthesis or as defined variables.
Getting the directory from a full path
Keep in mind that this simple code may not be appropriate in all cases. To disable these add this line of code:. Associated Files Download Links. The fileopen dialog box on a mac is best implemented with applescript. This script catches errors within the Apple script and returns the error number as text which always begins with a '-' allowing the calling code to decide what to do.
This catches 'errors' such as clicking the cancel button and opening with a directory that does not exist.
I was not able to identify detailed error info if I caught the error in the VBA. All Windows versions have ActiveX controls; the Mac does not. This applies only to adding controls to a document; UserForms are cross-platform. A good starting point for understanding the differences and limitations is the Help in Word X for Mac.
Two Help topics in particular give a fairly good overview of some pitfalls to avoid. These topics are:. If you need to access files, pay special attention to what the second topic has to say about paths and the Application.
Developing with VBA on PowerPoint Mac
PathSeparator function; hard-coding file paths will surely fail cross-platform. While not a design issue, another missing feature on the Mac is the ability to directly export and import items in the Visual Basic Editor.
If you have a. TakeFocusOnClick and. TabStop properties to false to disable this on either platform.