Author | Sarang Kharche |
Date Modified | 21/11/2019 |
Doc Saved As | MS Excel Macros Backup from Scheduling PCs |
Path | Knowledge Base/Engineering/Troubleshooting |
Application Name | MS Excel |
Network Type | - |
IP | - |
Login Details | - |
How to connect | - |
Query?
MS Excel Macros Backup from Scheduling PCs.
There are 4 Scheduling PCs at the moment as below:
ABSOFF3
ABSMCR009
ABSOFF005
ABSMCR007
How to:
1. The macros are backed up in Dropbox at Dropbox (ABS Broadcast)\ABS Technical And Operations\Excel Macros\
2. There are 4 different folders corresponding to the 4 computers we have in Scheduling.
In each folder, there is a Macros-enabled excel file E.g. Macros.xlsm
3. The macros of that computer are stored in the Modules folder at Developer --> Visual Basic tab once you open that document.
Tips: You can right-click on one of the macros in the above picture E.g. Nolly and click on 'Export File' which will export that individual macro and that can be used on another machine by importing it.
THE END