Error: Old Format Or Invalid Type Library. (Exception From HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))
Mar 27, 2012
I had a working program a while ago, but now it is giving me an error when I try to insert some data to my Excel-file.I get this error: Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD)) For example, one of my Excel referencing codes is:
Dim XL_App As New Excel.Application
Dim XL_WB As Excel.Workbook = XL_App.Workbooks.Open("C:Program FilesIAAExcelitTuntilappu.xls", , True)
Dim XL_WS1 As Excel.Worksheet = XL_WB.Worksheets(1)
The above code used to work, but now it gives me the error...I recently updated my Office from 2003 to 2010. How can I fix it?
View 3 Replies
ADVERTISEMENT
Jan 9, 2008
Iam getting an error "Old format or invalid type library" when im running the .net application in systems(pc) having MS Office 2000 versions.and im not getting any errors for higher versions like 2002,2003 etc.This error im getting when exporting to Excel.And i tried the following link [URL] Then also im getting same error.
View 5 Replies
Feb 24, 2012
I am trying to open an Excel file using the following commands:
xlsWB = xlsApp.Workbooks.Open(filename, , True)
where 'filename' is the name of the file.However I am getting the following error message:
Message = "Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))"
I originally developed an application where I used the above code with default language setting of "English" (under regional and language settings). When I am changing the language setting to "French", the above errror comes up. I am changing the language setting to French in order to simulate an error when this application is run in a French version computer.
View 3 Replies
Aug 8, 2009
Im getting the fol. message: Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))when i try to run a code from my vb app. I've just tried to change my regional settings to English but no luck
View 3 Replies
Apr 20, 2009
I have a windows form application in Vb 2008 pulling data off SQL Server 2005. I need to be able to create an Excel report on the fly and dump the results from a query onto the first Excel sheet. After that I run another query and need to dump the results to the next sheet in the same workbook. Problem is that this query may spit back more that 65356 rows. Therefore I need to put the first 65000 rows in the second sheet and then the rest in the next sheet and so on and so forth.
Unfortunately, when I fix the sheet_var = 2 to start dumping in the second sheet, I get an index error. Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))
The error is occuring in this line: oSheet = obook.Worksheets.Add(After:=obook.Worksheets("Page " & sheet_count))
Here is the code:
Code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Cursor.Current = System.Windows.Forms.Cursors.WaitCursor
Dim cnn As SqlConnection
[CODE]....
View 4 Replies
May 8, 2009
I am controlling an external piece of test equipment and using VB in Excel it works fine, but now I've moved the code into VB Studio 2008 it produces an error. Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))
The code is as follows:
Sub CheckError(ByVal Ret)
Dim Id As Long
Dim ErrorNr As Long
[code]....
I have deliberately disconnected the test kit and in Excel it raises a msgbox with error 20: No CMC Connected. When debugging I can see that the error code is returned correctly ErrorNr = 20. I've tried changing the data types to short and integer but this has not worked.
View 3 Replies
Jul 30, 2010
[Code]...
This code has worked for me on an other machine, but when I try it on my own I get this error: "Old format or invalid type-DLL."
View 8 Replies
Aug 10, 2009
I imported an app from vb6 to vb.net It works fine. It has one axmsflexgrid control. Now I want to add another axmsflexgrid control in the same app. I tried to copy and paste from one frame (groupbox) to another and got this error:
"An error occurred while processing this command: Exception from HRESULT:0x800A018A (CTL_E_GETNOTSUPPORTED)"
An inputs on how would I fix this? Or just make a new axmsflexgrid?
View 18 Replies
Nov 5, 2008
i'm using VB.NET 2003 application program.i'm using WinSock in this program. on Page_Load, i used this code[code]......
View 1 Replies
Nov 28, 2011
When I am open Excel through work book I got the below error
Exception from HRESULT: 0x800A03EC
I am posting my code Below
Dim xlApp As New xl.Application
Dim oldCulture As System.Globalization.CultureInfo = System.Threading.Thread.CurrentThread.CurrentCulture
'Initialize Excel
[code]....
View 12 Replies
Jan 5, 2011
This is a strange one that I have so-far been unable to resolve. Basically, when you click on a function icon within the software application it throws up the following message in box:"An unhandled exception has occurred in your application. if you click continue, the application will ignore this error and attempt continue. If you click quit, the application will close immediately"The specified module could not be found. (Exception from HRESULT: 0x8007007E)See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box.
System.IO.FileNotFoundException: The specified module could not be found. (Exception from HRESULT: 0x8007007E)
at Universal_Camset.Communications.Transmit(String Data)
at Universal_Camset.VCL_MIC_500_Module.VCL_MIC_500.Send(String Data)
[code].....
This happens on two systems; Windows XP SP2 or SP3 - .net framework 1.1 & 2.0 & all necessary patches etc installed. Just can't seem to get around it. What is more frustrating is I have a test rig that has exactly the same software attributes & it works fine on that.I have even tried full clean O/S install with no other applicationms installed & get the same eratta as above.
View 2 Replies
Jan 10, 2009
i just got my vista 64 bit and i was trying to use XPButtons.ocx
heres the error An error occurred creating the form. See Exception.InnerException for details. The error is: Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))
System.InvalidOperationException was unhandled
[code]....
i think it was activeX component but i can't find it and it wont work with any .ocx files becouse im running a 64bit?
View 3 Replies
Dec 12, 2009
{"An error occurred creating the form. See Exception.InnerException for details. The error is: The specified module could not be found. Exception from HRESULT: 0x8007007E)"}i got the following error...what is this error??can't figure it out...i m using vb2005..vb.net
View 1 Replies
May 8, 2006
I have just created a new Extensibility Addin for Visual Basic using VS2005 Professional. This addin will be targeted at MS Outlook (I hope).When I look at the References tab of the project properties, I see the following message:-An error occurred trying to load the page.Unable to cast COM object of type 'System.__ComObject' to interface type 'EnvDTE.ProjectItemsEvents'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{22800963-2811-410D-BF87-A7808EAC977D}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).Why does this appear?How do I correct this?
View 6 Replies
Apr 15, 2012
i know this may seam odd but I'm getting an error navigating through a datagrid of an invalid cast. The trouble is it is of the same types!! I working on customising some Sage code and in the form there is a datagrid that is populated by a series of Sage.Accounting.Stock.TraceableSOPAllocationItems (a batched stock item allocated to an SOP).
I want to give the user some further information on each item so they can decide which batch and bin to use. I want to go through each item in the grid and then go find this extra information for it. the trouble is when I go to navigate through, My VB.Net code throws the error.InvalidCastException was unhandled by user code, Unable to cast object of type 'Sage.Accounting.Stock.TraceableSOPAllocationItem' to type 'Sage.Accounting.Stock.TraceableSOPAllocationItem'.
[Code]...
View 4 Replies
Aug 25, 2011
i have added a winsock control to my program. I know that vb 2008 dosent really support winsock no more but its needed for my project.Anyways i have form1 with a button that does "form2.show"This works as it should and opens form2 but when i add a winsock control to form2 then i get this error when i click the button to show form2
"An error occurred creating the form. See Exception.InnerException for details. The error is: Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))"
I dont get it, there are no classes apart from the form class.
View 8 Replies
Jan 13, 2011
im developing a desktop program where i use VLC libraries but when i compile de code on visual studio .net and i try to execute the binary on clean windows installation dont work and give me this error message
[Code]...
View 1 Replies
Nov 2, 2009
I've created a class that inherits from Dictionary(Of TKey, TValue) called KeyCopyDictionary(Of TKey, TValue). I'm now trying to use a pre-existing function which returns a Dictionary(Of String, String) and assigning it to a variable of type KeyCopyDictionary(Of String, String). I'm getting an invalid cast exception. Is it not possible to assign a variable of a parent type to a variable of its child type? I've tried DirectCast and CType to no avail on this...
View 5 Replies
Aug 25, 2011
I've just finished installing VS2010 on my computer. I have a project I built in 2003 that I'm trying to open in 2010. It went through the conversion process and generated this error: System.SystemException - The type library importer encountered an error during type verification. Try importing without class members. : System.MissingMethodException - Method not found: 'Void
[Code]...
View 4 Replies
Jul 2, 2010
When I try to create a instance of a COM class it throws an exception as Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))
View 2 Replies
Sep 30, 2009
When I try to create a instance of a COM class it throws an exception as Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))
View 4 Replies
Feb 9, 2012
Private
Sub cmdExit_Click(ByVal
sender As System.Object,
ByVal e
[code]....
View 3 Replies
Aug 15, 2011
I am getting Invalid Cast Exception was unhandled.Conversion from String 'abc' to type 'Double' is not valid in the following line!
If
((xlBook.Worksheets(2).Cells(iRowIndex, iColumnIndex).Value)) = avFoundKeywordds(iSearchText)
Then
The business intent is that user enters the keyword 'abc' and clicks search button . We have defined different keywords in a xls which has 1600 rows and 16 columns . so when finding abc in any of the cells ,it has to return the value of a column#4 where the name is specified !
View 3 Replies
Feb 6, 2010
i have a datagridview that show an access database also there is toolstrip menu i defined the datasource and everything is fine except that when i run the application and edit anything and when i press the save button on the toolstrip an error appear and highlight this: Me.TableAdapterManager.UpdateAll(Me.My_phone_numbersDataSet)
and the error is: invalid operation exception was unhandled
View 1 Replies
Dec 10, 2009
I am running the same program on two workstations. One reveals no errors while the other shows a "COM exception error: invalid parameter." The offending line of code is shown below.Is there an explanation for the inconsistency?
.SeriesCollection(iRet).Name = "=""Q" & Str(iRet) & """"
View 1 Replies
Jun 29, 2009
I'm scanning using WIA. What is happening is there is a temp file created under "C:Documents and SettingsuserLocal SettingsTemp". For some reason, the WIA service is deleting the temp file before I can transfer the image. The exact error is: "The system cannot find the file specified. (Exception from HRESULT: 0x80070002)". Is this a bug in WIA? The error occurs on the last line...
Code:
'Define objects
Dim WiaCD As WIA.CommonDialog
Dim WiaDev As WIA.Device = Nothing
Dim Itm As WIA.Item = Nothing
[code]....
View 1 Replies
Sep 2, 2009
I have a large project where we have 2-3 dll projects that are converted from VB6 to VB.NET. We have fixed all the issues that caused compilation errors, and most of obvious issues in running, so now we have basically a program up and running. The exe is created from scratch in VB.NET, using a lot of functionality from the converted dll's (including GUI forms). What I wonder is when I run the program in debug mode, I get a bunch of warnings in the "Immediate Window" saying:
A first chance exception of type 'System.Exception' occurred in Microsoft.VisualBasic.dll
...and some of other type (but most of them in Microsoft.VisualBasic.dll).I was wondering if this is common in projects converted from VB6, or if it is caused by bad design in our code...
View 2 Replies
Sep 15, 2011
I have inherited a VB.NET project which was created in VS 2003 and is now in VS 2010. It works fine on one macine (32 bit). However, on my Win7 64 bit machine it simply won't build or run. I get an error saying "xxx is not a valid Win32 application. (Exception from HRESULT: 0x800700C1) Line 4762, position 5"
[Code]...
View 6 Replies
Oct 15, 2010
I requested a Code Signing Certificate from my own domain Certification Authority on my Windows 2008 R2 domain controller.
When trying to publish my code to my webserver via Clickonce, it throws "an error occurred while signing: Invalid provider type specified"
In order to get the certificate I duplicated the Code Signing template on my CA, and tried both options available:
1) must use Microsoft Software Key Storage Provider
2) use any provider available locally
algorithm is RSA, key minim size 2048, Hash SHA1, alternative format unchecked
View 1 Replies
Nov 28, 2009
Any thoughts on what might cause a thread error like this?Error:InvalidOperationException was unhandledCross-thread operation not valid: Control 'Form1' accessed from a thread other than the thread it was created on.
Relavent Code:
Private Sub SerialPort_DataReceived(ByVal sender As System.Object, ByVal e As System.IO.Ports.SerialDataReceivedEventArgs) Handles SerialPort1.DataReceived
[code].....
View 3 Replies
