I am attempting to use the edrawings VBA api via excel. I have downloaded the edrawings SDK and it seems as though the api only runs through a user form. I have made a few vba macros for solidworks via excel but unlike solidworks there is very limited documentation. I simply want to make a connection to the API, after which I should be able to take it from there.

For right now I would simply like to open up a solidworks drawing in edrawings via excel. So something like the following:

<span class="kwd" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #101094;">Sub</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;"> OpenDrawing</span><span class="pun" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">()</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">  <br><br></span><span class="kwd" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #101094;">Dim</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;"> xlBook </span><span class="kwd" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #101094;">As</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;"> Workbook <br></span><span class="kwd" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #101094;">Dim</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;"> xlsheet </span><span class="kwd" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #101094;">As</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;"> Worksheet <br></span><span class="kwd" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #101094;">Dim</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;"> eDraw </span><span class="kwd" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #101094;">As</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;"> </span><span class="kwd" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #101094;">New</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;"> EModelViewControl <br></span><span class="kwd" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #101094;">Dim</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;"> FilePath </span><span class="kwd" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #101094;">As</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;"> </span><span class="kwd" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #101094;">String</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">  <br></span><span class="kwd" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #101094;">Set</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;"> xlBook </span><span class="pun" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">=</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;"> ActiveWorkbook <br></span><span class="kwd" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #101094;">Set</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;"> xlsheet </span><span class="pun" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">=</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;"> xlBook</span><span class="pun" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">.</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">Sheets</span><span class="pun" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">(</span><span class="lit" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #7d2727;">1</span><span class="pun" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">)</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">  <br>FilePath </span><span class="pun" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">=</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;"> Range</span><span class="pun" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">(</span><span class="str" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #7d2727;">"B1"</span><span class="pun" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">).</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">Value  <br>eDraw</span><span class="pun" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">.</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">OpenDoc FilePath</span><span class="pun" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">,</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;"> </span><span class="lit" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #7d2727;">False</span><span class="pun" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">,</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;"> </span><span class="lit" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #7d2727;">False</span><span class="pun" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">,</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;"> </span><span class="lit" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #7d2727;">True</span><span class="pun" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">,</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;"> </span><span class="str" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #7d2727;">""</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">  <br><br></span><span class="kwd" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #101094;">End</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;"> </span><span class="kwd" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #101094;">Sub</span>

As an example, Range B1 is the following "C:\\ _EngVault\\000S\\090\\090-40400-01.SLDDRW". I have activated the EModelView2018 Type Library and running edrawings 2018. Again, once I can figure out how to connect to the program I should be good but I am unable to make it that far.

Also, do I need a user form for this or did I misunderstand?

Thank you in advance,

Farzad