I have a program in VBA that uses Flexigrids. A little while ago, the program stopped working giving the error 'Compile Error In Hidden Module'. We were advised to remove Windows update KB960715 which we did and it worked fine. However, it has just stopped working again for the same reason and that update is no longer installed.
View 1 RepliesI get an error while trying to install a third party Excel add-in [Thomson One Analytics]. Error: "Compile error in hidden module: Main" Microsoft Excel 2003
[Code]...
We have a VBA based application that run with Excel, in where we are facing an error like "COMPILE ERROR IN HIDDEN MODULE". This issue occurs only at WINDOWS VISTA machine. This issue does not occur with WindowsXP/Windows 2000
Initially this issue comes where ever "Dictionary" class used. When we replaced it by explicitly specifying it's library like "Scripting.Dictionary", the same error comes where ever "VBA" library classes used. After investigating further, it's found that none of the built in classes able to find references to their corresponding libraries. We have all the proper references check box checked, at Menu-> Tools-> References Window.
I have a Linq-to-SQL class diagram in my web application containing the two tables in my database (held in a DBPro database project in the same solution). All was working fine yesterday. I start doing some work tonight and note that the solution compiles fine in Visual Studio, but when I run the web app I get a compilation error:
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message: BC30002: Type 'FrostAlertDatabaseDataContext' is not defined.
[code]....
I'm trying to compile a brand new 2010 windows forms application with a form and a single button that should display a msgbox with "hello" in it.When I try to compile I get the error message:
Unable to write to output file <filename>: This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms.
This is my first post. Please forgive me for asking a basic question as I'm new to programming.
I have following code and it just didn't compile
[Code]...
Lesson: Need to instantiate class before using it,
I have a project that up until recently has been working fine. It sends an email message to a user once a file has been successfully uploaded, registered and/or approved to use the website. It is written in VB.NET framework 1.1, running ASP.NET on a Windows 2003 server SE sp2.
First the code
Public Sub EmailAfterRegister(ByVal sEmail As String, ByVal sUser As String)
Try
[code]....
This has worked for over one or two years. Today I realized upon testing I get the following error:The procedure entry point IstrcmpiI could not be located in the dynamic link library MSDART.DLL.Upon some research I found that maybe I needed to install MDAC 2.8, which i downloaded and installed today, however i still get the same error. I have had my communications and network admins check traffic and connectivity to the smtp server and all is working fine. Yet I still get the error.
My team desperately need the Scrum Solution Starter for MS Project 2003: [URL]
To use this add-in it's needed to be compiled however we don't use Visual Basic (only Visual Studio).
I am trying to retrieve the data from EXCEL 2003 spreadsheet from row 8 onwards because from Row 1 to Row 7 the row is merged columns from A1 to K1, A2 to K2, A3 to K3, A4 to K4, A5 to K5, A6 to K6, A7 to K7.
View 28 Replieshow can I create an excel file in excel 2003, open it, add workbook, write into it, save it and close it by visual basic 2008.
View 2 Replieshow I can use excel 2003 and excel 2007 on my application. I add a reference to Excel 12.0 Object but this one is not compatible with Excel 2007 and i think if i add Excel 11 Object it will not run on excel 2007.
Is there any solution that I can use so that my project can be used with either excel 2003 and 2007?
I am using following code to close excel applications . I want to kill the hidden excel apps how to do it, Means following code closes all the excel apps but I want to close those opened from my program and are hidden
View 4 RepliesI am working on moving applications from Windows 2000 to new server Windows 2003 R2(64 Bit). I noticed that there are some VB programs and config files for those programs have been placed in Windows 2000 Registry. Some other applications are using them from different servers.Why do we use registry here? How can i move these to registry in windows 2003? Can I just move these or do I have to write VB programs to place them in 2003 registry?
View 1 RepliesI have a .net Windows Service developed in VB.net. I have a settings file in the root directory called Connections.XML and I am setting the basedirectory [code]...
When I schedule the service this is working absolutely fine in my Windows XP machine. But when I installed the same service in our development server (Windows 2003 64 bit Server) for some reason it is not able to locate this file.
I am building a Setup project for a Web system using Visual Studio 2008. I upgraded my development machine from Windows Xp to Windows 7. The problem started with Windows 7. Whenever I try to build I get the above error. I ve tried several solutions given online but I ve failed to get a solution. When I transfer the system to a machine running Windows Xp or Windows 2003 Server it builds successfuly.
View 4 RepliesI have a problem with scroll in a treeview in a Windows forms application (Framework version 3.5).
The strange thing about the problem is that on Windows XP, Windows 7 and Windows 2008 the scroll works as excepted, but in Windows Server 2003 SP2 the scrolling doesn't work. Enable/disable Visual Styles doesn't seem to make a difference on Server 2003.
Steps to reproduce the error:
1. Add a treeview to a form and add x nr of root items (and 1 sub item to each item).
2. Expand a number of nodes. The non-standard thing here is that we are changing the node integral height because we display a usercontrol with the treenode (See example of the code below).
3. When you scroll afterwards, you cannot scroll to the bottom node. The scrollbar is all the way down, but we are not seeing the last node.
Public Shared Sub SetNModeHeight(ByVal Node As TreeNode, ByVal IntegralHeight As Integer)
'Create instance of tvitemex structure.
[Code]....
How do I find out the hidden excel sheet name using ADO(OLEDB) in C#? In My Excel workbook there are a lot of sheets. Only one Excel sheet is in hidden mode. I need to find out the names of hidden sheets. My code finds both hidden and visible sheets.This is my code to find excel sheet names for all sheets. Is it possible/can any one tell me how to find out hidden excel sheet names without using Interop services in C#?
[code]...
I am reading XLS files, via JET provider, using the following
Dim conString As String = "Provider=Microsoft.Jet.OleDb.4.0;data source=" + fileName + ";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1;"""
cn = New OleDbConnection(conString)
cn.Open()
da = New OleDbDataAdapter("SELECT * FROM [" & sheetname & "]", cn)
da.Fill(dt)
The problem I am facing now is that some of these excel files have hidden columns: These columns are meant to be ignored. However, the code above fills my datatable with ALL columns (hidden and nothidden). Is there any "Extended Property" that I could add to the connection string, to ignore hidden columns?
I am uploading Excel File and below is my code. I have no problems so far with filling my dataset but when I tried to validate required fields, I get the error that some values are missing. I checked the Excel files and noticed that there are hidden rows that the user was not able to checked when he's adding values.[code]...
View 2 RepliesMy boss has used VBA in excel to create an application and we have had problems deploying the application to various PCs. Errors occur during the execution and we have to address dll inconsistancies between PCs to make it run.
I have heard that it is possible to compile the VBA code with VB.net.
I need to migrate from Excel 2003 VBA to Excel 2007 VBA. When Microsoft introduced Excel 2007 it removed many objects from the previous versions and added some new objects. Also it hid some properties of particular objects. These hidden properties can be viewed by going to the object browser, right clicking any object and selecting "Show Hidden Members". My problem is I need to access these hidden properties. Is there any way I can access these properties. I can successfully migrate from Excel 2003 VBa to Excel 2007 VBA with the same functionality?
View 5 RepliesI have an application that opens and saves spreadsheet via interop.At start up I set
Code:
_excelApp.Visible = false;
_excelApp.DisplayAlerts = false;
[code].....
How can I do this with either the My.Computer.Audio method or using a hidden windows media player control.
View 1 RepliesI am developing a project in Visual Studio 2008 with a team of 5 people. Each of the 5 people develop Windows forms and a repository in maintained on the server. The problem is that I have to individually compile each form manually after opening Visual Studio and adding the forms in the project.
I want to add and compile the forms using a GUI and not Visual Studio as such. Is this possible? Basically, the solution lies in programmatically adding Forms to Visual Studio Project I am not sure if such an application could be developed.
I want to delete the record from excel but i has getting the ISAM error, [Code]
View 1 RepliesExcel 2003 Row Limit?
View 2 RepliesI have a vb6 app that creates an Excel 2003 doc that I need to export to pdf. I have the following code to export,
excelWorkBook.Worksheets.PrintOut Copies:=1, ActivePrinter:="Adobe PDF",' printtofile:=True, prtofilename:=strOutputName
but nothing prints. The app exports to pdf works in test, but not when I move it to production. I have to remote into the machine that runs the app, so my printers from my local pc are "attched" to the remote session, can this have something to do with no output. The remote machine does not have the Adobe print drivers installed.
What can I do to get the export to work?
Using vb.net. I've got a main form that displays when application is opened. A popup form can then be opened. If there are other windows opened on the desktop, for example windows explorer, then when the popup form is closed, the main form gets hidden behind windows explorer. You have to move windows explorer out of the way to get to the main form. Is there a way to keep this from happening?
View 2 RepliesI am using a Windows Dialog form in my VB 2008 project. I bring up the dialog form no problem with the following
Dim resultNewInc As DialogResult
resultNewInc = frmDialog.ShowDialog()
If resultNewInc = DialogResult.OK Then
...some code here ...
End If
And in the Dialog Form, the OK button has code
Me.DialogResult = System.Windows.Forms.DialogResult.OK
Me.Close()
But there is one problem. If I call up the dialog form again, the form controls have the text values that were typed in during the previous instantiation and a class which is part of the form was not disposed. So it looks like the form is being "hidden" and not closed. I tried to use the code form.dispose but it didn't work.
When I try to make a new workbook from excel it doesn't work and returning the following error:
System.Runtime.InteropServices.COMException was unhandled ErrorCode=-2147319784 Message="Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))" Source="Microsoft.Office.Interop.Excel" StackTrace:
[Code].....