Error on HO3

37 views
Skip to first unread message

Katongo Yamba

unread,
Nov 22, 2021, 5:31:32 PM11/22/21
to OSeMOSYS
Hi Everyone! I am getting this error when I run HO3:

Error extracting data:
Cannot run the macro ''C:\Users\katon\OneDrive\Documents\Training\EMP\Hands on Exercises\HO3\SAND_Interface_HO3.xlsm'!Module1.writefile'. The macro may not be available in this workbook or all macros may be disabled.

What could I be doing wrong? 

Thanks in advance. 

Rudolf Yeganyan

unread,
Nov 23, 2021, 4:23:35 AM11/23/21
to OSeMOSYS
Hi, 

It seems like you have not enable the macros, and also your files is saved on a one drive, which prevents the model from seeing it. Check that you have enabled macros (when you open the excel sand file, it asks enable macros, and clicks on enable), and save your file on C drive, and not on a onedrive. 

Let me know if this works.

Best,

Rudolf

Reply all
Reply to author
Forward
0 new messages