I am calling GetGlyphIndices from Vb.Net. I am using a single character string. I get the correct value in the indices array for the character '6' but not for characters requiring 2 bytes to be returned.
Does anyone have any experience with this API call? My next step is to write the C equivalent and make sure I can get it working without interop.
[Code]...
In C# I'm calling a function on an interop class (Connection, written in VB6), which itself returns a plain object (System). Then there's a function on that object (InitialiseData) that I also call (even though the compiler isn't aware of it). var isInitialised = Connection.System.InitialiseData(path); The problem is, because that System object is returning a mere Object, I get the compile error "cannot resolve symbol". I can see why, but the same thing works fine in VB.NET:
[Code]...
Is it possible to register a vb.net Service for com-interop?
View 1 RepliesI'm wondering if you can use the Microsoft.Office.Interop.Excel in a windows service application type.
I've a windows form application which opens an Excel file and do some actions and save it as another file. All this is working perfect in windows forms. When I copy the same code and paste it in a windows service, then it is not possible to open the file even.
I receive the following error message:
[Code].....
I am migrating VB application in VB.NET. In VB application , there are using Microsoft windows common control 5.0 COMCTL32.OCX. When I add this component in migrated project, it becomes interop_mscommlib.dll. I want to remove any interop dll in my migrated project. So my question is : Is there any .net supported COMCTL32 which i can use and from where I can get that.
View 3 RepliesI have an application that creates desktop shortcuts. To do this I have to reference the Windows Script Host Object Model. When I add it as a reference, it always creates the DLL, Interop.IWshRuntimeLibrary.dll, in the objx86Debug directory, then references itself to it, rather than looking at wshom.ocx. Even if I add reference wshom.ocx it reverts to saving the file in the objx86Debug directory. The problem is if I move my application to another computer without that DLL being present, the program fails to run.
View 1 RepliesI have a VB6 DLL that wraps a call to a 3rd party component. When I call my DLL from VB6, everything works fine, but when I call it from vb.net (2.0 framework targeted - VS2010) I get this error:
AccessViolationException occurred
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.This error only occurs on Windows 7 (Windows XP clients work fine).I've looked this up and all the articles I found talked about the declaration not being correct.I am not declaring any APIs calls though, the 3rd party component is early bound in my VB6 DLL.I can run the DLL, set a breakpoint,and it goes into my VB6 function, but errors calling a function in the 3rd party component.My VB6 DLL takes 3 string and one 32bit numeric (long in VB6) parameters. The 3rd party's DLL function that I am calling is taking a string (bstrDNSID as string is what Intellisense shows in VB6). This is where it errors.
Update: None of the marshalling has helped, so I tried creating a test sub in my VB6 DLL. I hardcoded all the values within the DLL's test sub. It works fine when called from VB6, but gives the same error as above when running from .NET. Also of interest, when I have the VB6 DLL running from the VB6 IDE, I do not get the error when calling the DLL from .NET.
If I wanted to call the RUN prompt and the Command prompt in my application, what exe's would I need to reference?
View 6 RepliesCan somebody tell me how to call Windows Hard Disk Defragmenter in VB.Net on Button Click.
View 4 Replieshow to call Windows Hard Disk Defragmenter in VB.Net on Button Click.
View 1 Replieshow to call Windows Hard Disk Defragmenter in VB.Net on Button Click
View 1 RepliesWe just spent 300 man-hours fixing a buggy application in the field. It all came down to calling Application.DoEvents (re-entrancy problem).This was not caught in design reviews, code reviews.The code was inserted two years ago with the first version; the application was always "flaky" but recent changes exposed the re-entrancy problems to a greater degree. This incident is the second time in our organization that Application.DoEvents caused failures and multi-man hours of debugging.It was discovered in this case by simply noticing the call,buried way down in a complex event handler for an asynchronous task.What do you suggest to prevent this issue from happening again:
Add checkin gates to source control?
Developer training?
Code Analysis rules (why is this not already a built-in rule?)
How to I enforce a coding practice?
i want to write a small app which enables the user to burn some files on cd/dvd. Something like:
- Make an export from related DB Tables with informations
- Collect customers informations
- zip everything
-burn on cd (its a settlement related tool)
Does calling the Dispose method on a Windows.Forms.Timer call it's Stop method? Or should I stop the timer before I dispose it?
View 5 RepliesWe have a windows service running under a network account that calls and runs an ActiveX exe. The exe is running under the local system account, not the network account of the service.
View 1 RepliesThis might be a bit of stupid question but I need some clarification. I'm somewhat new to .NET and have created a EXE that had to reference an existing COM DLL. In doing so, Visual Studio 2010 automatically created an "Interop" DLL that it needs/uses to work with the legacy COM DLL.
I have deployed my project and included this Interop DLL with it (in the same folder) and everything is working fine. However, I have other applications that will need to use this same legacy COM DLL. Is it okay to reference it they same way in each application and keep deploying the "Interop" DLL with each application? Unfortuantely, all of these small applications go in the same folder and each use the same Interop DLL (so it will already exist there if it's used by another app.) I'm forced to having them in the same folder because these applications are being called as a way of customizing a parent application. As such it only looks in it's local folder when it wants to run a "custom" app. I'm just concerned if one the EXE's is ever removed and they take out the Interop DLL, then the others that still depend on it will fail.
So, I was wondering if it is possible or a good idea to put that Interop DLL in the GAC? I went ahead and installed the Interop DLL into the GAC and then removed the Interop DLL from the folder where my EXE runs and it failed to work. I get an error that says "Could not load file or assembly". I'm stuck on getting this working.
Do I need to reference the Interop DLL in my project differently such that it's now from the GAC? or Do I need to add something to my .NET code like Assembly.Load to make it work? Do I need to create that Interop DLL myself using TLBIMP?
What is COM Interop? Please remember to mark the replies as answers if they help and unmark them if they provide no help.Welcome to the All-In-One Code Framework!
View 1 RepliesI am using Interop to read and write to excel but I'm having some problems writing to excel... When I enter the information I need to be written on the excel in an inputbox, this pops up "COM object that has been separated from its underlying RCW cannot be used."Heres the Code:
Code:
Private Sub editmodelbtn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles editmodelbtn.Click
[code].....
I am trying to use a 3rd-party Interop assembly called SmartWIM.
I have added it as a reference and added an Import statement
Imports SmartWIMLib
I then initilalise it with
Dim objSmartWim As New SmartWIM
All pretty standard stuff, I've done this countless times with Interops. However, whenever I try and use any methods I get the following error [code]...
I'm kinda new to using VB.NET and certainly with the Excel Interop.I have the impression that I'm doing something wrong in these simple procedures. I keep getting errors on them:
[Code]...
The first procedure fills a combobox with all the worksheet names of the workbook.The second procedure copies all cells in the selected worksheet to an array.The error is the following: System.NullReferenceException: Object reference not set to an instance of an object.I think the error is in the cleanup part, when I set the objects to nothing and close everything. Can someone confirm if this is good or wrong code and maybe point me in the right direction?
I Programe a COM Library in VS2008 to use in Excel , but I'm stuck with an error that I don't understand.
I use this two classes , that compile and register OK. One Class QBitems return a nongeneric collection of QBItem but when I tried to use the Add and/or Remove Method, I receive the following error in Excel VBA :
Run-time Error '438': Object doesn't support this property or method.
I added a class (SImpleClass) in the library and I called from VBA it returned the QItems collection without problem.
NEW: When I replace the QBItem object with a string in the Collection QBItems everytthing works OK. It looks like interface doesn't like to pass an object like QBitem class
Excel/VBA:
Sub Pru()
Dim obj As New CollectionCOMClass.SimpleClass
Dim Itms As New CollectionCOMClass.QBItems
[Code]....
I have a .NET application that interops with a VB6 COM DLL. After installing the application on a Vista machine, I try to execute the code that consumes that COM component and I get an error attempting to read or write protected memory. The system's DEP is set to only essential programs and services, but apparently that automatically applies to .NET applications. When I tried to exclude the application from DEP, it said that DEP must be on for this program (could not be turned off). I had to use the bcedit.exe program to manually turn DEP off system wide and then reboot. After that, the application ran without a hitch, but this is not the route we want to go for our users. Are there any solutions/recommendations for this? It seems as though DEP has been more of a headache than not.
View 5 RepliesHow can i add Interop.ADODB.dll to my references as i cant seem to find it when i try?
View 3 RepliesI am creating a report in my asp.net application. The report outputs to excel using the excel interop. Some calculations in the report cause excel to display "Inf" or "NaN" I want to force these calculations to zero so that the report displays zero and NOT "Inf" or "NaN"
View 1 RepliesThe Current Setup:So, I can use the following code to save a file as an XLS:
_myWorkbook.SaveAs("FileName.xls", Excel.XlFileFormat.xlWorkbookNormal)
I can also use the following code to save a file as an XLSX (Since I use Office 2010):
_myWorkbook.SaveAs("FileName.xlsx", Excel.XlFileFormat.xlWorkbookDefault)
I have tried (unsuccessfully) to save the file as an XLSX using the following code:
_myWorkbook.SaveAs("FileName.xlsx", Excel.XlFileFormat.xlExcel12)Why does this not work? Last I checked, Excel 12 was Excel 2007 (a version that supports XLSX). Am I missing something?
I get a This extension can not be used with the selected file type error)
I've developed a vb.net app which works great on my dev machine, both within the IDE and as a compiled executable. But when I deploy it to a user workstation, I receive the following:
Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately.
Could not load file or assembly Microsoft Office Interop.Excel, Version=11.0.0.0,Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannon find the file specified.
Im doing a VB .net2 program and when building i get file interop.shell32.dll in my bin folder.
Can i embed that in my final .exe file so I only have to destribute 1 file ?
There is a properties on my form where I can choose a "Build Action: Embedded Resources" , is that the option to accomplish me goal?
I am trying to Import an XML file into Excel and then Export the data to CSV. I did the Import Data steps manually in Excel while recording a Macro. I am basically using those commands in VB.NET.
Try
xlWBook.XmlImport(filename,, True, xlRange.Cells(1, 1))
xlWBook.SaveAs(outFile, xlCSV, False)
[code].....
i want to know how interop.speechlib.dll works and reads the English text because i want to Develop a Project that reads other languages.
View 6 RepliesI have Office 2007 installed on my Win7 development machine, however I want my Office-reliant VB.Net app to reference/work with, Office 2003 and above. I tried installing the Office 2003 interops redistributable but the installation tells me that I need
to have Office 2003 installed. Is there a way I can install the Office 2003 interops so that my app can have references to Office 2003 and thus work on Office 2003, 2007 & 2010?