Office 365 is a subscription-based program. However, there is a free browser-based version that not only gives you free access to Word, Excel, PowerPoint, Outlook, Access, and Publisher but you’ll also get 5GB of free storage on the cloud-based OneDrive storage. Can I just buy one of the Office 365 apps?
Usually when developing Excel solutions you want to version you file often to prevent data loss due to the application crashing etc. You will probably also want to keep the older versions of you files to be able to go back and recover any previously working code. When you do this once or twice in a while this is no issue. But when you are making significant changes in a short amount of time saving new versions is a time-consuming task. Excel versioning is therefore something many deem useful.
Other VBA File resources
That’s why I made myself a very simple VBA method for automatically saving the current Excel xlsm file as a new version while keeping the previous versions of the file. The macro increments the current file version. It is best to set a keyboard shortcut to the macro to save time.
Versioning Excel Code
The following code will save the ActiveWorkbook as a new Workbook while appending the version number by 1 in the format “_vXXX” where XXX is the version number. The versioning macro will maintain the file extension.
Download![]()
You can also download the file as a bas file:
The module sets the macro as a CTRL+SHIFT+S shortcut as having this line of code: Setting up the Versioning Excel MacroKeyboard shortcut
As mentioned above the macro in the download section is setup by default for CTRL+SHIFT+S shortcut. However, in case you want to change the shortcut. Simply go to the DEVELOPER ribbon and select Macros. Next select the SaveNewVersion macro and click Options... This will prompt you for a new keyboard shortcut.
Quick Access Toolbar
Why remember a keyboard shortcut when you can add a neat icon to your Quick Access Toolbar in Excel.
Open the Quick Access ToolbarMicrosoft Excel Update
Go to File, Options and open the Quick Access Toolbar.
Add versioning VBA macro to the Quick Access Toolbar
Proceed as shown below to Add the SaveNewVersion macro to the Quick Access Toolbar:
Optional: Modify the icon
Why stick to a default macro icon when we can make it more pleasant to the eye? Click on the SaveNewVersion macro and hit Modify. Next select a new icon from this window:
This is the final effect: Simply hit the icon to save a new version of your Excel file! Remember to save the file in XLS/XLSM/ or XLSB format. What Is The Latest Version Of Excel CalledInstalling as an Excel AddIn
The above will add the versioning feature to all your Workbooks as long as your Excel file with the SaveNewVersion macro is not moved or deleted!. Edit audio files. I strongly recommend that instead you include this file into the AddIns folder before configuring this shortcut.
Save the XLSM file as AddIn
First save the file in XLA or XLAM format, as an Excel AddIn.
Save the file in Microsoft Excel AddIn directory
Save the file in the following directory for it to open automatically on startup:
Related posts: -->
Office for Mac that comes with a Microsoft 365 subscription is updated on a regular basis to provide new features, security updates, and non-security updates. The following information is primarily intended for IT professionals who are deploying Office for Mac to the users in their organizations.
Note
Most current packages for Office for Mac
The following table lists the most current packages for the Office suite and for the individual applications. The Office suite includes all the individual applications, such as Word, PowerPoint, and Excel. All packages are 64-bit only. The build date is listed in parentheses, in a YYMMDD format, after the version number. The install package is used if you don't have the application already installed, while the update package is used to update an existing installation.
To view release notes, see Release notes.
February 16, 2021
Version 16.46 (21021202)
Release history for Office for Mac
The following table provides release history information and download links for Office for Mac. The table is ordered by release date, with the most recent release date listed first. The build date is listed in parentheses, in a YYMMDD format, after the version number. All releases after August 22, 2016 are 64-bit only. All releases prior to August 22, 2016 are 32-bit only.
Note
Download Excel 2010 Free
Update Office 365
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2021
Categories |