ABS Broadcast

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