Is it possible to get a sense of depth and 3D space (X,Y,Z planes) from an image or video? Is there an API that can handle this sort of processing? Perhaps with several images or source videos you could possibly determine 3D space and boundaries of an area in a series of photos or videos. I know they have photogrammetry software that can compile 3D objects based on a series of photos taken from different angles. I am wondering if this can be done to map out a terrain in an image or video (or series of them).

Okay so I changed the manifest to reflect the new progid: ExcelInterface.ExcelInterface . I assumed that also meant that I should change the progid in the DLL to match the manifest. I changed the following line: ProgId("ExcelNXInterface.ExcelNXInterface")> Public Class ExcelNXInterface. As a result I am getting the following error: Method 'CreateObject' of object IActCtx failed. Thank you for your help by the way.

Okay, based on some other examples I found online I saw that some people used the progid in the manifest. I wasn't sure why, but I just followed the examples. So I went ahead and tried using your suggestion. This time around I got another error, but it seems much friendlier (maybe). It says "ActiveX component can't create Object". So maybe using ExcelNXInterface.ExcelNXInterface was the way to go, even though it still isn't working. It seems better than the error saying the Create Object Method Failed. Anyway, I am pretty much lost from here out. Not sure what else can be done. I have seen in other forums online that some people claim in order to pull this off you need to alter the Excel.exe.manifest file to point to your dll, and store the dll in the same folder as Excel's executable file. I'm hoping that isn't true.

Hello, in the article you linked in your post, there are two different GUIDs. What are the differences in the 2, and which ones should I be using? Also, in the article to call the COM object he was able to reference the COM wrapper class built to expose the .NET calls to VBA in Visual Studio. I am trying to do this in Excel, where I can't simply reference the dll. Can somebody tell me how I can call COM objects in Excel? Here is my code for the COM Wrapper Class:

Imports System
Imports System.Collections.Generic
Imports System.Runtime.InteropServices
Imports NXOpen
Imports NXOpen.UF
Imports NXOpen.Assemblies

Namespace ExcelNXInterface

\_
Public Interface \_ExcelNXInterface
    Sub HighlightCompTag(ByRef tag As Long)
    Sub Echo(ByVal output As String)
End Interface

Public Class ExcelNXInterface
    Implements \_ExcelNXInterface

    Public \_ExcelNXInterface

    Dim theSession As Session = Session.GetSession()
    Dim ufs As UFSession = UFSession.GetUFSession()

    Public Sub HighlightCompTag(ByRef tag As Long) Implements \_ExcelNXInterface.HighlightCompTag

        'Cycles through component objects by tag in NX, and then when finding it, highlights it. 

        Try
            ufs.Disp.SetHighlight(tag, 1)
            Echo("Component(s) Highlighted...")
        Catch e As NXException
            Echo("NX Exception is: {0} " + e.Message)
        Catch e As Exception
            Echo("Exception is: {0} " & e.Message)
            Echo("DONE!" & vbLf)
        End Try

    End Sub

    Sub Echo(ByVal output As String) Implements \_ExcelNXInterface.Echo

        theSession.ListingWindow.Open()
        theSession.ListingWindow.WriteLine(output)
        theSession.LogFile.WriteLine(output)

    End Sub

End Class

End Namespace

Here is the manifest I built to reference in Excel:

Okay, so if I create my own Library exposing the .NET calls to be consumed in VBA I can reference this Library in Excel? I have Visual Studio so I can build DLL files and anything that does not require installation (or registry access) to run. If I can consolidate the functionality to an Excel workbook that would be great. Which is why I was thinking of Reg Free COM. How can I call the Library in Excel VBA? Edit: I can't build executables either. IT is picky about what we can and cannot do. However Excel is free game.

Hey Everyone, I have been searching the web for days to try and find a potential solution to my problem, and so far I have only gathered bits and pieces of a potential solution. I need to be able to make API calls to a CAD program from an Excel macro. The CAD program is called NX. It was developed by Siemens. They have an API called NXOpen that was written in VB.NET. I have tried referencing the appropriate DLL in Excel, however the DLL is not registered and nor can it be in my limited development environment. I do not have registry access. If I am able to pull this off I would like to distribute the workbook to my co-workers as well. So I have been exploring the possibility of using Registration Free COM in Excel 2010 (Windows 7 64 bit) to make the API calls I need from Excel. To try and do this I was going to use the following code to instantiate an object that points to the manifest for the NXOpen.dll file. I want to access a subroutine in the DLL called "Highlight". Also, from what I have read I will also need the dlls CLSID to reference in the manifest as well. That I don't know how to get. Any help would be very appreciated. Thank you.

Sub EXCELNX()

Dim actCtx As Object
Set actCtx = CreateObject("Microsoft.Windows.ActCtx")
actCtx.Manifest = ThisWorkbook.Path & "\\NXOpen.dll.manifest"

Dim myNX As Object
Set myNX = actCtx.CreateObject("Highlight")

End Sub

Hey Everyone, I am not new to application development in general. I have experience designing basic CAD plugins, but that is about it. I would like to start a new project. I want to be able to draw and render 3D terrain based on information derived from small segments in Google Earth. How do I do that? I know other applications can do this, like Rhino. So it is possible. The target OS for this functionality is Windows 10 (Desktop).