Search results

  1. S

    Resolved Excel cant seem to find my comhost.dll

    Ok thanks, i forgot you could embed the tlb which is much neater. Yes it was a combination of various things on different pcs, not having the right framework, excel 32 bit etc etc, all sorted now, thanks for the prompts.
  2. S

    Resolved Excel cant seem to find my comhost.dll

    On my main machine, my .Net Core 6 functions work via a comhost.dll / tlb in Excel with no problems. They work if i just manually register it via Power Shell using Regsvr32 inside of visual studio. I can then create a SetUp project and install it on my main machine and that also works, i can...
  3. S

    Resolved How to run (or install) App as administrator

    Hi, I'm using .Net 6 on win 11 and since upgrading windows i ran into this problem where my c# app now will only run as an admin. Spent quite a long time googling but none of the answers seemd to be the right one. I have added in a manifest but this still doesn't allow the app to run when...
  4. S

    Tip Using Ribbon Control in WinForms

    Hi, im sorry i dont understand what you mean. Neither package has the required functionaility when converted to .net 6. Both compile with no problems, nothing is missing, but the neccesary design time functionality simply doesn't work in either package in .net 6.
  5. S

    Tip Using Ribbon Control in WinForms

    Also just got exactly the same problem witht the Krypton tools when converted to .Net 6
  6. S

    Tip Using Ribbon Control in WinForms

    Yes i tried that it doesnt work, compiles ok, but the design time functionaility is mssing, it's allmost lke the Verbs design time stuff (of which i know nothing) is missing from .Net 6.
  7. S

    Tip Using Ribbon Control in WinForms

    I there any possibility of this being upgraded for .Net 6?
  8. S

    Backroundworker is having Cancellation pending set at random

    Ok thanks, that gives me somewhere to look for a problem
  9. S

    Backroundworker is having Cancellation pending set at random

    I can reproduce this but not every time the sub method is called (it seems to depend were its called from), however at no point have i called CancelAsync() method so i dont understand why the CancellationPending flag is ever set...
  10. S

    Problem .Net 6 COM and excel VBA revisitied

    Thanks, ill stick with the keeping them in the same order approach, there was about 80 method calls but i managed to sort them and the Interface out quickly in excel and paste them back in the right order so they seem to be working ok now. That was the last of my conversion issues to .Net 6.
  11. S

    Problem .Net 6 COM and excel VBA revisitied

    OK, i have no idea what im doing but after a load of trial and error, mostly error, i found that you can have more methods declared in your C# class interface than you have in the IDL/TLB file, but if you do the order you put them becaomes very important. Even more than that, in any case, the...
  12. S

    Problem .Net 6 COM and excel VBA revisitied

    My understading is for .Net 6, you generate an extra DLL (in my case called "COMThermoClass.comhost.dll") by adding a line to the project file "<EnableComHosting>true</EnableComHosting>". You then register the created DLL using regsvr32.
  13. S

    Problem .Net 6 COM and excel VBA revisitied

    I dont i have anything the GAC.
  14. S

    Problem .Net 6 COM and excel VBA revisitied

    It shouldn’t be but right now i guess anything is possible. Ive succesfully debugged some other calls in exactly that way and i don’t think the code is getting that far. I’ll try taking it out and see though… EDIT: I tired it, same problem. Beginning to think this part of .net 6 is a bit buggy.
  15. S

    Problem .Net 6 COM and excel VBA revisitied

    Hi, i've setup a project that uses .Net 6 and is call from excel VBA. Some of the functions work fine but others are not. Its really not clear to me why they dont work. I've tried everything i can think of many times over. The interface; namespace COMThermoClass {...
  16. S

    Excel VBA calling a .net 6 function?

    Finally got time to try this, taken me all day but got it working in .Net 5 eventually. Most of it was just getting the format of the IDL file correct with the right GUIDS in the right place for the class and the Interface, but took most of the day to figure out what was going on, then...
  17. S

    Excel VBA calling a .net 6 function?

    Thanks. I just the cold sweaty feeling im going down a blind rabbit hole with this, will give it a go though.
  18. S

    Excel VBA calling a .net 6 function?

    Hi Thanks yes thats the sort of thing i was looking for and i have the example working without to much trouble. However I then get to the point where i either need to "write C++ header file" or write an MIDL file to be able to generate a TLB file otherwise i can't call it from excel? I do not...
  19. S

    Excel VBA calling a .net 6 function?

    Apologies if this has been asked before but i couldnt find an example of this working. In the .net framework is realtively easy to get excel talking to C# code via COMinterop but i cant find anything equivelent in .Net6. Really want to move to .Net 6 as it executes my code faster but i still...
Top Bottom