VS 2005 : Error In Opening An Excel File : Old Format Or Invalid Type Library
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
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
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
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
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
Apr 17, 2012
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source='" + fileName + "'; Extended Properties=Excel 5.0"
Dim ExcelConnection As System.Data.OleDb.OleDbConnection
ExcelConnection = New System.Data.OleDb.OleDbConnection(ConnectionString)
Error occurs on line ExcelConnection.Open()External table is not in the expected format.
View 2 Replies
Aug 26, 2009
Dim excel As New Microsoft.Office.Interop.Excel.Application()
Dim wb As Microsoft.Office.Interop.Excel.Workbook = excel.Workbooks.Open(txtFileLocations.Lines(w))
Dim ws As Microsoft.Office.Interop.Excel.Worksheet = TryCast(excel.ActiveSheet, Microsoft.Office.Interop.Excel.Worksheet)
when the program tries to opens an excel file, it always throws me an error "Office has detected a problem with this file. Editing may hard your computer" and my program crushes.......The problem appears on the SECOND line, on DIM wb...blahblah.. i went to the office and unclicked the "protected view" checkboxes.. but it still throws me those errors. my guess is that the office i have in the computer is not the same as the one that my program uses to open excel files (i mean, i loaded/imported some excel.dll files in the program so i guess that will be the one) But how do i make the program not care if the excel file is "potentially dangerous"?
View 3 Replies
Jul 26, 2011
[Code]...
when the program tries to opens an excel file, it always throws me an error "Office has detected a problem with this file. Editing may hard your computer" and my program crushes. The problem appears on the SECOND line, on DIM wb.
[Code]...
View 14 Replies
Apr 13, 2011
I'm trying to open an Excel file to get and set some values. Unfortunately, I have no choice, I must to work with Excel.
Dim xAp As New Microsoft.Office.Interop.Excel.Application
Dim xWkb As Microsoft.Office.Interop.Excel.Workbook
xWkb = xAp.Workbooks.Open("c:uploads este.xls")
Always I have this exception: (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT))
Need I Excel installed in server machine to open Excel files? I don't think so, because when I create a new application and workbook throught code, all things go right, but... its a possibility...
View 1 Replies
Sep 25, 2009
Error Opening Excel File Read Only ODBC
View 1 Replies
Oct 25, 2009
I have an Excel file with utilizes macros to allow a user to enter names of people and then double click on cells to enter ratings via radio buttons. When I open a blank file and enable the macros, I can add users, rate their skills using the radio buttons, etc. with no issue. I then SaveAs the file and continue working on it. once I Save and CLOSE the file, then go to re-open it, the trouble begins. Keep in mind, there is no alteration to the macros directly. Just entering data and using the form as intended. Here's what happens.
I reopen the file.I enter in the name of a person on one line. I go to the first box - double click on it.It is supposed to pop up a dialog box which allows me to choose a rating via radio button (as I had been doing before I closed the file). Instead, in that first column of ratings, it instead gives me the following error:
Runtime error '1004'Unable to set the LineStyle property of the Border class
When I hit "debug" this is the code it points to:
If ActiveCell.Column = leftb Then Range(Cells(ActiveCell.Row, leftb), Cells(ActiveCell.Row, rightb + 1)).Borders(xlEdgeTop).LineStyle = xlContinuous I have no idea why this would not work when I re-open the file!
note that when I go to click on the subsequent cells (there are 8 cells in which you provide ratings, moving across the columns with each cell) - the 2nd through 8th cells function fine. The dialog box pops up, the rating can be selected. it's just the FIRST cell that gives the issue What would possibly be the cause of this? We need users of this form to be able to save, close, and re-open it if needed.
View 1 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
Aug 6, 2010
i have usied ICSharp.dll for zipping my folder.it sucessfullyzip the folder but when i try to unzip file manually it shows me error "xx.zip this file is not in the standard ZIP format 2.0"
View 5 Replies
Oct 6, 2009
I'm trying to upgrade a VB6 app to VB 2008. I have read the article in the tutors corner about automating Excel from VB but I cannot get it to work. Heres what I have done:
1) set a reference to the Microsoft Excel 12.0 Object Library
2) Added "Imports Excel = Microsoft.Office.Interop.Excel" to the top of the module
3) in a routine I have added: Dim X As New Excel.Application Here's where I get an error: Error 75 'Application' is ambiguous in the namespace 'Microsoft.Office.Interop.Excel'.
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
Mar 5, 2012
I have a project that has a need to display a Excel file in second window, but because other controls are needed, simply launching excel is not sufficient. Right now I do not know if the target machines have excel installed but I know with certainty that if they do it would be 2010, is there any method or library that allows you frame your own form around an excel window?
View 1 Replies
Aug 30, 2010
Is there any way to insert an existing macro into a existing excel file without using the excel library ? I need this to set the excel to print whole work book .I cannot use excel library because it will be done online in the server where installation of excel is not possible. I can however use the c#.net coding . I am using NPOI to generate the excel.
the macro is given below
Private Sub Workbook_BeforePrint(Cancel As Boolean)
If printed = False Then
Cancel = True
[Code]....
View 1 Replies
Dec 23, 2009
I am using Visual Studio 2008. While opening some of the .resx file, it is giving me error that "The operation cannot be completed. Invalid Pointer". What can be the possible problem and solution?
View 1 Replies
Jul 4, 2005
How to print excel file form vb .net without opening excel?
View 9 Replies
Jan 28, 2010
i'm trying to save an excel file after I open my excel application. This is what I have so far:
'Opens the report
xlPeakDemand.Visible = True
xlPeakDemandWorkbook.SaveAs("C:Documents and
[Code].....
When saving as an xls it works fine but when saving as a htm its a disaster Just a bunch or symbols and stuff. BUT if I go into my xls document and Save As webpage from there, it works fine!
View 2 Replies
Apr 25, 2011
Having trouble compiling when I have a reference to SHDocVw.
I've done some searching and found that tlbimp is the tool needed and to use my solutions key, however I am getting an error stating that SHDocVw.dll isn't a valid type library.
View 1 Replies
Sep 24, 2009
What do you think is wrong with the commented line in my vb.net code below? it returns the error message "member not found".[code]...
View 1 Replies
Apr 25, 2012
We have created a dll to convert an excel spreadsheet to a csv file. At the moment we open the xls file, an eror occured (file doesn't exist / is used by an other user)
Used
Dim excel As New Microsoft.Office.Interop.Excel.Application
Dim wb = excel.Workbooks.Open("d:my.xls") '<<<<<<<<<<< not possible to open
wb.SaveAs("d:my.csv", Microsoft.Office.Interop.Excel.XlFileFormat.xlTextMSDOS)
wb.Close(SaveChanges:=False)
View 3 Replies
Apr 9, 2009
[Background]:I created a Winforms App that reads data and spits it out into an Excel Spreadsheet. On my computer, I have Microsoft Office 2003 and inside of the Visual Studio Project, I referenced COM Object "Microsoft Excel 11.0 Object Library". The Executable is on a shared directory and end users can run the application and generate the reports themselves.
[Problem]:Problems arise when an end user with Microsoft Office 2007 runs the application, generates the Excel Spreadsheet and sends it to someone with Microsoft Office 2003, the Excel Spreadsheet opens with the standard "this file is not in recognizable format" error and when you push "ok", the data shows up as symbols (garbled text).
[Question]When I reference "Microsoft Excel 11.0 Object Library" in my project, how does the .Net Framework (or my Application) find this COM Object object when it is ran from another CPU?I guess, I would like to know how references work. When you reference DLLs in a VS.Net project, compile the program and then put the execuable on another PC, how does VB.Net go about finding those DLLs you referenced or is it part of the compiled program?
I suspect when a user running MS Office 2007 runs my app, it is running a 2007 dll instead of a 2003 dll.However, I would think an error would be thrown if this was the case.
View 4 Replies
Jul 15, 2009
I'm using WMI code and VB 2008 to see NIC status. So far the queries are working, but the methods aren't. For example, I'm trying to set a network card to use DHCP, I get invalid function with this code:
Dim classInstance As New ManagementObject("rootCIMV2", "Win32_NetworkAdapterConfiguration.Index='7'", Nothing)
Dim outParams As ManagementBaseObject = classInstance.InvokeMethod("EnableDHCP", Nothing, Nothing)
View 3 Replies
Oct 20, 2010
A co-worker checked a very simple Visual Basic Visual Studio 2010 application into our version control system. When I checked it out and tried to build it I got the weird error below, which I am guessing has something to do with which .Net Framework the build is targetted towards and also which Framework I have installed.
------ Build started: Project: VB-DEER10, Configuration: Debug Any CPU ------
Build started 10/20/2010 3:35:57 PM.
C:WINDOWSMicrosoft.NETFrameworkv4.0.30319Microsoft.Common.targets(1558,9): warning MSB3283: Cannot find wrapper assembly for type library "Microsoft.StdFormat".
Build FAILED.
Time Elapsed 00:00:00.15
Build: 0 succeeded, 1 failed, 0 up-to-date, 0 skipped
View 1 Replies
Apr 25, 2012
We have created a dll to convert an excel spreadsheet to a csv file. At the moment we open the xls file, an eror occured (file doesn't exist / is used by an other user)
Used code:
Dim excel As New Microsoft.Office.Interop.Excel.Application
Dim wb = excel.Workbooks.Open("d:my.xls") '<<<<<<<<<<< not possible to open
wb.SaveAs("d:my.csv", Microsoft.Office.Interop.Excel.XlFileFormat.xlTextMSDOS)
wb.Close(SaveChanges:=False)
View 1 Replies
Aug 13, 2010
ok.. i have i "Worldchat.rtf" on a server.. that was a .txt before.. but i can open it whtout problem in windows. Dim strtemp As String = My.Computer.FileSystem.SpecialDirectories.'downloads the fileRichTextBox1.LoadFile(strtemp & "" & "worldchat.rtf", RichTextBoxStreamType.RichText)gets a error saying "file type invalid"
View 8 Replies
Jan 11, 2008
How do I reference the library project when I get this error?
"A project with an output type of class library cannot be started directly In Order to debug this project, add an executable project to this solution which references this library project. Set the executable project as the startup project."
View 8 Replies
Feb 18, 2010
I have downloaded the attached code from codeproject site, i'm new in vb.net, i have some background knowledge in vb6. when i try to run the code the following error message is diplayed:"A project with a output type of class library cannot be started directly"
View 2 Replies
