my error code is run-time error 1004 unable to get the correl property of the worksheetfunction class. I read the data from xlsx-files to one dimensional arrays in my vb - program. the essencial code parts are
Option Explicit
Option Base 1
Dim winvyf() As Double, winvx() As Double
[code]....
Here are some important facts:
This code works (no Error 1004 on numerous laptops and desktops) A couple of months ago it began to fail (Error 1004 reared it's ugly head) on a couple of machines. The users claim that nothing changed - I can neither confirm nor deny accuracy of these claims. All users, except one, are running Windows XP and Office 2003. The problem also surfaced on a new machine running Windows XP and Office 2007. I could not force the error on my development/test machine - Windows XP with Offic 2003. It fails every time on another machine I have running Vista with Office 2007
The following is the code that causes me the problem. I know the error is raised on the WB.Save statement. I added the error trap to eliminate the problem of the Excel file being unaccessable without a reboot, due to the fact that Windows thought Excel still had it open.
Public Sub ExportCostAnalysis(ByVal RunMode As String)
On Error GoTo ErrorHandler
As dao.Recordset
[CODE]...
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.
VBA error 1004 - select method of range class failed
View 2 RepliesI am working on a large spreadsheet with Macros. It worked fine when I only had one spreadsheet that the code was pulling from. When I added an array, I get the an error on the Activesheet.unprotect stating 'unprotect method of worksheet failed'.
View 2 RepliesI have three class files, accounts.vb and transactions.vb in addition to my form.vb. I am unable to retrieve a member variable from on class from inside the other. When the combobox index changes, the program loads the correct account (checking or saving) from two different sequential files. I don't think I have the calcBalance procedure in the correct class file. And that is what I am having trouble with. Accessing it to display it. [Code]
View 1 Repliesstart with I was given a program by a friend that was created in Excel 2003 with the help of Visual Basic Editor. He said he used Visual Basic 2003, which he is not 100% sure about. Anyways he used CurLine in the program and when I try to open it in Excel 2007 and then open the Visual Basic Editor and run the program I get the following error:Run-time error '-2147418113 (8000ffff)':Could not get the CurLine property. Unexpected call to method or property access.
View 2 Repliesthis is my code and it doesn't work of course , do you see some error ??
Dim i, j, z As Long
i = 3
j = 3
[code]......
i am writing a mobile application to save some task. In this application i want save the data of task to the text file(*.txt). however, i faced some of the issues that i unable to save data to txt file due to the runtime error on file not exist but i have checked it and the txt file is existed. [Code]
View 10 RepliesI have a small vba in xls 2003:
[Code]...
A VB5 program I wrote years ago stopped working and is now giving me this error:
Run-time error '380':Invalid property value
I cannot figure out what has changed, since I run that program almost daily. It was working fine, then stopped (without any changes to the program). I suspect I may have uninstalled something it uses, but cannot figure out what.When I open the VB5 IDE, I get an error saying:
'c:program filesdevstudiovbComct232.ocx' could not be loaded--Continue Loading Project?
If I say no, it does not load and I cannot see the source code.If I say yes, it does load and I can see the source code but I get weird compiler errors.
In designer i had a button with errorprovider.The button show 3 extra properties at button's property grid in design time.Error on ErrorProvider1
IconAlignmnent on
IconPadding on
But how can i show this 3 extra properties in propertygrid at run time?
Private Sub Form_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim propertyGrid1 As New PropertyGrid()
propertyGrid1.CommandsVisibleIfAvailable = True[code].....
I created a simple VB 6 executable that runs fine on my computer (Windows 7), but when I deploy it to another Windows 7 PC or a Windows 2003 server, I get the error:
"Runtime Error 430: Class does not support Automation or does not support expected interface".
The code
Private Sub cmdStart_Click()
Dim rstLogin As ADODB.Recordset
MsgBox ("Before first recordset")
Set rstLogin = New ADODB.Recordset
MsgBox ("After first recordset")
End Sub
The line that generates the error is " Set rstLogin = New ADODB.Recordset". I had a coworker compile it from his Windows 7 pc and run it on other machiens and it works fine. So I believe it's an issue with my pc config.
I created a simple VB 6 executable that runs fine on my computer (Windows 7), but when I deploy it to another Windows 7 PC or a Windows 2003 server, I get the error"Runtime Error 430: Class does not support Automation or does not support expected interface"
View 12 RepliesWhy isnt this working?Sub Macro1()
[Code]...
I need some help to understand my options to get this working. I try to update a textbox control by a property-changed event from a class variable. I've digged around for a day and have a vague understanding that this can be solved in three ways:
1. Using some "if InvokeRequired", "Invoke" code in the handler method
2. By programming a special delegate class for this variable
3. By using a databinding directly linking the control (textbox) to the class event
Now.. Are these options correct? And would it be possible to get some help to show these three solutions in actual code (relevant to mine)? I can't seem to manage to sort all the information to a working code. Also, what are the pros and cons of the different solutions?
As my code stands now, it's obviously none of the above, as it gives a cross-thread error, as indicated.
[Code]...
I want to created a nested class that can only be visible to and instantiated from the parent class.But I also want to be able to use an instance of the nested class through a public variable of the parent class.I tried making the nested class private, or making the nested class' constructor private, but it won't compile.Is it possible to do this in .NET?
[Code]...
I have a very simple class that holds a few public properties - ID, Text, Colour, etc. and a Boolean called 'SelectedItem'. Just like the Checked property on RadioButtons, only one item can have its SelectedItem property set to True within a particular group. Note: there will be several separate groups (lists), each allowed to have only one item with SelectedItem = True.
My first thought was that I would probably just have to handle everything outside of the class, setting SelectedItem to False for every other item in a particular list when another item was selected. But that seems rather inelegant to me. So I've been trying to think of how this might be done within the class. For example: could I perhaps have a private string property called say "GroupName" - set in the New sub when adding a new instance of the class - and then use a private shared method to set every item's SelectedItem property to False, provided the item has the same GroupName as the newly selected item? I would have a go at doing this but I have no idea how to enumerate every instance of a class from within that class, or whether that's even possible. Is it? Or is there another (better) way to achieve my goal? Here is a cut-down version of what I've got so far:
Public Class ResourceItem
Public ID As Integer
Public Text As String[code]....
As can be seen: instead of instantiating a new ResourceItem and passing that as an argument to the manager's Add procedure, I'm simply passing the details of the new item and the procedure is creating the item from those. I don't know whether this is a good or bad idea - please advise - but I've done it because I couldn't figure out how to make the SelectedItem property only writeable by the manager, so I wanted to avoid having directly accessible objects that could have their SelectedItem property set to True without it deselecting all the other items in the same group. Of course that still leaves the possibility of setting a variable to one of the manager's list items and setting it from there, so I would still like to know how I could prevent that, if possible.
UPDATE: I didn't use the code above in the end, deciding instead to go with Cyborgx37's solution - which seems to work perfectly well for me despite the warnings about best practice. I also realised I would need to use the same class in another scenario where multiple items could be selected, so it was easy to add a Boolean property to the manager to enable that.
I have a Visual Basic 2005 program which runs fine if I execute the built Executable. However if I start the application in VS2005 debugger it gives a weird error
[Code]...
I have the following code:
Public Class MyColorsClass
'Constructors
Public Sub New()
'Empty Constructor
[code]....
However, if the empty constructor was called to instatiate this class then the colortype is not yet set. Therefore, if one accesses the 'IsColorCool' property it will always return 'False'. Now for the sake of this example, I must keep the empty constructor as part of the class.Now I could add some code in the 'IsPropertyCool' to check and see if a ColorType has been defined, and throw an exception if it has not been set, but I don't really want to do that.I also could always move the logic OUT of the property and into a method on the class called 'DefineIfColorIsCool' or something, and make the owness on the caller to make sure the method was called if they want to use the property 'IsColorCool'?
Supose a base class
Public Class airplane
Private var_num_seats As Integer
Private var_num_engines As Integer
[code]....
Obviously, I don't wish that the class Glider has the method "start_engines" neither the property "num_engines". Otherwise, other child classes may have. How can I supress these property and method in child class, not just ignoring (if I can)?
I have procedure (Import) that calls a for a new instance of frmImportData. I also have a class name clsBatch that has a data table property called prpParametersTable.For some reason, I get an error (indicated below with ERROR>>>) when trying to assign prpParameterTable to cv_dtImport2. The error states "Object reference not set to an instance of an object.". Why does this error not happen when I assign dtBP to cv_dtImport1? Both cv_dtImport1 and cv_dtImport2 are equal to Nothing and in my Import procedure dtBP = prpParametersTable.
Public Sub Import(ByVal clsB As clsBatch)
Try
Me.cv_clsB = clsB
[code]....
This is a bit of a continuation from a previous post for which AtmaWeapon was very informative.
Problem:
A parent class has a sub class with various properties. A property of the parent class is a List(of T) with T = the sub class The issue is how to store data in the sub class of the instantiated parent
Some example code (hopefully formatted correctly):
Code:
'=========== Class Definitions =============
Public Class courseClass
Public Class timeTableClass
[Code].....
I'm looking for a tutorial on how to Adding a list(of Class) or Collection as another Class's Property.What I am after is something like the Columns Collection for the DatagridView control.I would like to add Items in the graphics screen. Where the item list is displayed in the left panel and the selected Item properties are displayed in the right panel.
View 4 RepliesI have an application written using Visual studio 2005 (in VB.Net). When I run it on any machine I get "unable to find a version of the runtime to run this application and this same application successfully some other PCs[code]...
View 2 Repliesi've built my first exe and when i try it, i got this message:
unable to find a version of the runtime to run this application.
i would be happy if it said what is the needed runtime.
can someone tell me what i miss to run it?
I have an application written using Visual studio 2005 (in VB.Net). When I run it on any machine I get "unable to find a version of the runtime to run this application" and this same application successfully some other PCs..[code]
View 7 RepliesI have a Form class with a property defined as[code]...
View 4 RepliesI'm accessing a router using Webbrowser, to get some information from it.After logging into the main page, you click on a link which runs a script to display the info you want. I can do this OK in Firefox or Internet Explorer.In my VB program, having navigated successfully to the router's main page, I try to do this by using InvokeMember ("click") on the appropriate link element in the document and get this error in the script that runs:
"Unable to set the value of the property 'location': value is null or undefined".I don't know how to see the source code of this script, so any ideas on what the error may mean?When I hover over the link in Firefox, the status bar shows it as: javascript:MainFunction('./cgi-bin/v2x00.cgi?fid=168')
We have a VB .Net application that is targeted to the .Net Framework version 2, over the past couple of days users have been reporting that they are getting the following error message when running the program?
View 8 Replies