title: ImportError: DLL load failed: The specified module could not be found - PyCharm
body: <p>So I've been trying to switch to PyCharm this week and using some of my old code has not been working out. I am using the base anaconda environment as the interpreter, and the following code </p>
  
  <pre><code>import openpyxl
  import numpy as np
  </code></pre>
  
  <p>And then some basic code on opening a sheet and creating arrays with the rows and columns. AFAIK this is an import problem related to a missing DLL, but nothing more than that. Here's the error:</p>
  
  <pre><code>Traceback (most recent call last):
  
  File "C:\Users\nikol\Anaconda3\lib\site-packages\IPython\core\interactiveshell.py", line 2961, in run_code
      exec(code_obj, self.user_global_ns, self.user_ns)
  
  File "&lt;ipython-input-2-a51a1395fac2&gt;", line 1, in &lt;module&gt;
      runfile('C:/Users/nikol/Desktop/APO A1P2/Code/make_excel.py', wdir='C:/Users/nikol/Desktop/APO A1P2/Code')
  
  File "C:\Program Files\JetBrains\PyCharm 2019.2.3\helpers\pydev\_pydev_bundle\pydev_umd.py", line 197, in runfile
      pydev_imports.execfile(filename, global_vars, local_vars)  # execute the script
  
  File "C:\Program Files\JetBrains\PyCharm 2019.2.3\helpers\pydev\_pydev_imps\_pydev_execfile.py", line 18, in execfile
      exec(compile(contents+"\n", file, 'exec'), glob, loc)
  
    File "C:/Users/nikol/Desktop/APO A1P2/Code/make_excel.py", line 2, in &lt;module&gt;
      import numpy as np
  
    File "C:\Program Files\JetBrains\PyCharm 2019.2.3\helpers\pydev\_pydev_bundle\pydev_import_hook.py", line 21, in do_import
      module = self._system_import(name, *args, **kwargs)
  
    File "C:\Users\nikol\Anaconda3\lib\site-packages\numpy\__init__.py", line 140, in &lt;module&gt;
      from . import _distributor_init
  
    File "C:\Program Files\JetBrains\PyCharm 2019.2.3\helpers\pydev\_pydev_bundle\pydev_import_hook.py", line 21, in do_import
      module = self._system_import(name, *args, **kwargs)
  
    File "C:\Users\nikol\Anaconda3\lib\site-packages\numpy\_distributor_init.py", line 34, in &lt;module&gt;
      from . import _mklinit
  
    File "C:\Program Files\JetBrains\PyCharm 2019.2.3\helpers\pydev\_pydev_bundle\pydev_import_hook.py", line 21, in do_import
      module = self._system_import(name, *args, **kwargs)
  
  ImportError: DLL load failed: The specified module could not be found.
  </code></pre>
  
  <p>Greatly appreciate any and all feedback! Thanks!</p>