Does anyone know how I can include an existing dimensioned integer in VB code in a formula when using location indices (either R2C2 or R[2]C[2])?
I have integer Location set to the value 6 in some earlier programming steps, and now I'd like to be able to create other formulas and someimes use this Location integer into these formulas. More specifically at the RC and R[]C[] locations in formulas.[code]...
I have complex formula calculating the value of a cell and it calculates the value for me. I want to get rid of the formula from the cell and want to retain the calculated value.
I have :
Dim range As Excel.Range = getRange()
For Each cell in range
' What should do to retain the value and get rid of the formula in the cell.
Next cell
I'm inserting data into excel sheets and after i fill each sheet I want to sum a column so select the data and add a formula to a cell. However when the sheet is opened the cell contains the formula as text instead of the sumation value. I tired several ways but here are a few different meathods that both end up with the same undesired result.
Code:
'Meathod 1
oSheet.Range("H2:H" & (dtEntries.Rows.Count + 2).ToString).Select()
oSheet.Range("H" & (dtEntries.Rows.Count + 2).ToString).FormulaR1C1= "=SUM(R[-" & (dtEntries.Rows.Count).ToString & "]C:R[-1]C)"
[code]....
Has anyone created a regex that matches each of the cell references in a given Excel formula? I'm trying to extract a list of cell references into an ArrayList from a provided Excel formula. Ideally, the ArrayList would also preserve any cross-tab or cross-workbook reference information. The key is for the regex to be compatible with any potential Excel formula, as the formula will change with each use.This seems to capture cross-workbook references:
'[.+'!($?[A-Z]+$?[0-9]+(:$?[A-Z]+$?[0-9]+))
I want to create an algorithm or formula that gives me the following combinations below. I have manually printed out all the combinations for the example containing 4 tables with respective values.
This is not permutation because i need the combinations to always follow the unique format [code]...
I want to auto fill a range like this:
In Sheet1!A1 i have the formula "='Sheet2'!D1"
In Sheet1!A2 i have the formula "='Sheet2'!H1"
In Sheet1!A3 i have the formula "='Sheet2'!L1"
Now the Sheet1!Ax increments with +1 value; The Sheet2!D repeats again with D, H, L but only with a +4 to all 3 of them
[Code]...
I want to place two radio buttons in so I can select one of them to use one formula, and then select the other to use another formula. I want to use the I=P(1+r)^n formula and I=P(1-r)^n formula with the radio button text showing Appreciation and Depreciation.
Heres my copy of the original code.
Public Class Form1
Private Sub cmdExit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdExit.Click
End
End Sub
[CODE].......................
The redirect .NET uses to send users to my custom 404 page, wipes out the referringURL.[code]...
View 1 RepliesSee this example:
''//file1.vb
Sub Something()
''//...
Functions.LogInfo("some text")
''//...
End Sub
[Code]...
I am trying to do is get interoperability between my "mainwindow" and a class. As far as I know the way to do this is to create an instance of the class (in "mainwindow") for example and then use that instance to call the functions etc... This works. However I want to allow the class to call functions in the "mainwindow" The moment I declare the instance on the class as well it goes into an endless loop.
View 4 RepliesI need a string of code that refers to it's filename on the computer. Basically like how batch has %0% to refer to the batch file's name.
View 4 RepliesI�m using a loop to open up a number of forms in my app. The forms are named after dates from a db. They are "created" at runtime so to speak.
Everytime a form is opened, the name adds to a dropdown list in an mdi parent form. The first item in that dropdown is a "close all". I want that item to do just that - close all the forms corresponding to the names in the dropdown list. I�m thinking of looping with an integer, starting on 1 (since the "close all" is 0).
So I need something like:
forms(mdiparent.toolstripmenu.dropdownitems(i).close
I have a map of the us that is broken into an html image map. (not asp). What I'm wondering is it possible to get the title of the refering link on the map?
[Code]......
I want to create a function inside my class that will return a boolean on the existence of some data within any structures created with the class.
Public Class MyObject
Public Object1 as String
Public Object2 as String
[code]....
What I don't know how to do is refer to the object that called the function to get values, including the number of items in the referring objects array.
i got some issues with a app i want to create Okey i have this app, and it supposed to load a .xls excel worksheet.And in this worksheet i will have something of this structure [url]So i want A1 to create a folder with the name of what is in A1 cell, then create a sub directory in that folder with the name of B1 and a sub directory in that with C1 etc until there is a empty field in whatever comes next.then repeat the process for A2 and A3 and so on. Basically a creation of a lot of directories and sub directories through a excel worksheet.[url]Here is a overlay of how the app will look like.Top text box and browse button is for load of .xls file Second text box and browse button is for output of where we want all these folders to be placed.The additionally text boxes we have under that will be cause i want multiple sub directories created in the last folder created through the .xls file loaded.So in the example structure given earlier the first folder created would be Division AUnit 1Boss 1 and in [Boss 1] folder i want additionally sub folders created written in the those text boxes
View 18 RepliesI Imported 2 programs that I made into one solution. I made a "BIG" main menu (new windows form), put two buttons. I code one button to open up the first project (that works fine). I code the other button to open the project I imported, however it says that the name is not declared. Am I doing something wrong?
here is my code for the "BIG" main menu:
[Code]...
now only the "Original name of first project" appears to be not declared, if I delete "Original name of first project", then "the project I imported"is not declared and so forth. Note: These are not the exact names I called my forms. I'm just trying to explain it clearer.
I have added some classes to my project and now i want to define a variable as one of the classes, for example the class is called xml and i want to create a variable called XMLfile and have it as the class XML.
Can this be done? Or can variables only be declared as types (like Integer, string, etc)?If you're not living on the edge, you're taking up too much room
I'm working on a very basic VB.net frontend for an Access database and have stumbled upon a problem.
Dim ds As DataSet
MaxRows = ds.Tables("Course_assignmentsDataSet.tblCourse").Rows.Count
i = 0
Private Sub Navigate()
txtCourseReference.Text = ds.Tables("Course_assignmentsDataSet.tblCourse").Rows(i).Item(1)
txtCourseName.Text = ds.Tables("Course_assignmentsDataSet.tblCourse").Rows(i).Item(2)
End Sub
I get the error that Object Reference is not set to an instance of an Object. I think this is because I haven't defined the DataSet as "Course_assignmentsDataSet"- the one I want to use- but I'm not sure how to do this.
My LiveView Property is named lstView and is called by this line:
[Code]...
The first reference to objListItem gets this exception: I am referring to the object as new but obviously not in the right way. objListItem is not Null when this line executes.
Does a variable create a memory cell, or is it actually the memory cell, for example: Dim Answer As DialogResult
This is the explanation I have written for that line of "This line of code uses a Dim (Dimension) statement to declare a variable called Answer.
This variable creates an object to store the users answer to a dialog result." and this is the explanation that my friend said it was:
"This line of code uses a Dim (Dimension) statement to declare a variable called DialogResult. This variable is a memory cell to store the users answer to the dialog result."
[code]...It is a multiline textbox, and I want to be able to enter different pieces of information (info1, info2, info3) into each line.
View 16 RepliesI have an app that pulls up a webpage that has a button on it with the following ( I CANT change the webpages, but I can change anything in the App.)
[Code]...
I use the following code to get the shortcut files in a folder and to list them in a Listview control. But is there a way to extract the path of the EXE to which this shortcut is referring to ?
vb.net
Dim di As New IO.DirectoryInfo("C: est")
Dim aryFi As IO.FileInfo() = di.GetFiles()
Dim fi As IO.FileInfo
[Code]...
how can I create a grid with a cell with multiple data.I want to Display Product Name,ProductID and Price in one cell.How can this be done in VB2005. [URL]
View 2 RepliesI'm using an on key down event for my datagridviewer that fires every time a key is pressed while the datagridviewer is selected(Focused).I want the same thing to happen while in a cell, but there is no event for key down in a cell.
View 3 RepliesI am developing an application which created a series of labels using code such as this below[code]...
View 3 RepliesI am attempting to copy the value of the TimeStamp in cell A6 which has the NOW() formula into cell A5 Based on a change in Cell A4. The catch is I don't want it to update every time the sheet is recalculated due to updating links in other cells on the sheet. ONLY when Cell A4 Changes. What do I do?
View 2 RepliesWell, the title pretty much says it all. I have a user control that is a a collection of six label controls. three are used as visual color indicators, and the other three are used as the corresponding value for each color indicator. (It's sort of like a legend key on a chart or map.) I have created a custom class to store the three values, and the associated methods to interact with the values. (I can probably use a structure instead of a class, but right now, I don't want to discuss that.) My problem, is that I want to show my user control inside a cell of a DataGridView. I've looked at the examples that create a MaskedTextBox DataGridViewCell, but I can't seem to get it to work. Here is what I have:
[Code]....
I'm using VB.net 2005 and sql server 2000 i'm fetching the data into datagridview, but datagridview has several datasource depending on the "select case " Now can i export the data from datagridview without referring to dataset/datatable?
View 1 RepliesHow would one remove an item from a ListBox and then remove that line from the TextFile and repopulate the ListBox with new data in Visual Basic.Net?[cod]...
View 2 Replies