Click here to Skip to main content
15,868,016 members
Home / Discussions / COM
   

COM

 
PinnedHOW TO ANSWER A QUESTION PinPopular
Chris Maunder16-Jul-09 3:09
cofounderChris Maunder16-Jul-09 3:09 
PinnedHow to get an answer to your question PinPopular
Chris Maunder16-Jul-09 3:05
cofounderChris Maunder16-Jul-09 3:05 
QuestionWhat remote work tools do you use with your team? Pin
JaleyRowe19-Mar-22 0:51
JaleyRowe19-Mar-22 0:51 
QuestionRe: What remote work tools do you use with your team? Pin
Richard MacCutchan19-Mar-22 2:27
mveRichard MacCutchan19-Mar-22 2:27 
GeneralHow to Wrap OLE Structured Storage Pin
Visual Herbert20-Feb-21 0:42
Visual Herbert20-Feb-21 0:42 
QuestionWin32 - Use COM object help Pin
Bret Stern8-Jan-21 5:39
Bret Stern8-Jan-21 5:39 
AnswerRe: Win32 - Use COM object help Pin
Richard MacCutchan8-Jan-21 6:30
mveRichard MacCutchan8-Jan-21 6:30 
QuestionHow to get header and footer value in MS Project file format(.mpp) using office interope (C#) Pin
Member 1481839713-Nov-20 5:38
Member 1481839713-Nov-20 5:38 
AnswerRe: How to get header and footer value in MS Project file format(.mpp) using office interope (C#) Pin
Gerry Schmitz13-Nov-20 9:49
mveGerry Schmitz13-Nov-20 9:49 
AnswerRe: How to get header and footer value in MS Project file format(.mpp) using office interope (C#) Pin
Richard MacCutchan13-Nov-20 22:06
mveRichard MacCutchan13-Nov-20 22:06 
Questioninterop Pin
lista25-Apr-19 7:00
lista25-Apr-19 7:00 
QuestionRe: interop Pin
Eddy Vluggen31-Mar-20 14:39
professionalEddy Vluggen31-Mar-20 14:39 
Questionkey match Pin
Member 141404154-Feb-19 23:24
Member 141404154-Feb-19 23:24 
AnswerRe: key match Pin
OriginalGriff4-Feb-19 23:28
mveOriginalGriff4-Feb-19 23:28 
QuestionObservation Pin
Richard Andrew x6415-Dec-18 8:22
professionalRichard Andrew x6415-Dec-18 8:22 
AnswerRe: Observation Pin
Mycroft Holmes5-Feb-19 14:35
professionalMycroft Holmes5-Feb-19 14:35 
QuestionConnect hsajet printer Pin
Member 1119728820-Oct-16 15:42
Member 1119728820-Oct-16 15:42 
AnswerRe: Connect hsajet printer Pin
Richard MacCutchan20-Oct-16 20:47
mveRichard MacCutchan20-Oct-16 20:47 
QuestionRegistration Free Com in Excel Pin
Member 1233692919-Oct-16 0:40
Member 1233692919-Oct-16 0:40 
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.


VB.NET
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

AnswerRe: Registration Free Com in Excel Pin
Richard Deeming19-Oct-16 2:28
mveRichard Deeming19-Oct-16 2:28 
GeneralRe: Registration Free Com in Excel Pin
Member 1233692919-Oct-16 2:49
Member 1233692919-Oct-16 2:49 
GeneralRe: Registration Free Com in Excel Pin
Richard Deeming19-Oct-16 2:54
mveRichard Deeming19-Oct-16 2:54 
GeneralRe: Registration Free Com in Excel Pin
Member 1233692919-Oct-16 4:18
Member 1233692919-Oct-16 4:18 
GeneralRe: Registration Free Com in Excel Pin
Richard Deeming19-Oct-16 9:21
mveRichard Deeming19-Oct-16 9:21 
GeneralRe: Registration Free Com in Excel Pin
Member 1233692920-Oct-16 0:35
Member 1233692920-Oct-16 0:35 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.