I have 2 forms (e.g Form1, Form2) which have multiple labels drawn on them (e.g Form1 has Label2,Label3 and Form2 has Label5,Label8).How can I fetch into an excel (or notepad etc) sheet the total number of labels and their names that I have in my forms?
View 8 RepliesI have an excel sheet with image names in column A. I have a directory (with subfolders) on my network with all the images in there plus some.I need to copy only specific files from one location to another.
View 1 RepliesI have a function in my WinForms app that needs to retrieve the user's default user agent. To do this, I've created a web page (ASP.NET) that displays the user agent in a Label in the Page_Load. The problem that I'm having is that when I fetch the HTML from that page, the result includes all of the HTML except what should be displayed in the LabelHere's my
Private Function GetUserAgent(ByVal theUrl As String) As String
Dim proc As New Process
proc.StartInfo.CreateNoWindow = True[code].......
However, when viewing the page's source in a browser, it contains the following .Your user agent is: <span id="Label1">(user agent string here)</span></p>.why GetString is not picking up the Label contents?
Note: For reasons beyond my control, this app is coded using .NET 1.1. Otherwise, I'd be doing things a bit differently.
I want the coding for next and previous button and its given on my form. I want to fetch the records from my database and display it on my form.
View 6 RepliesI have a series of labels to modify through a loop. here's an example of the code i need to modify
lbl1.forecolor = color.black
lbl2.forecolor = ...
I need to iterate the lbl number each time through the loop as the color value will change from label to label.Clueless on how to do so with a loop vs the "long" way of doing code for each separate label. I have 169 to modify each time I change input so I'd rather not unless I have to
im trying to create smarter more efficient code in my project by having all lables change to their desired states by use of a for loop. currently my labels are all something like lblB1. can i do anthing like the following?
[Code]...
In form 1 a user enters there name and if they enter =>3 letters then form 2 shows up. I want it so when form2 shows up, I want the name that was entered to display in a label in this form.
lblname.label = username
I am looking for a way to make my code shorter, how can I implement a for loop to do this:
Public Class frmWhatevs
Dim arrOne(8) As Label
Dim ArrTwo(8) As TextBox
Private Sub frmb_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
SetaArray()
SetbArray()
End Sub
[Code] .....
How can I sort label names on buttons within a form. Automatically sort the names and put into the correct place within the form. A-Z order sort can be left to right. Want some sensibility to the form not all mixed up.
View 4 RepliesI would like to use checkboxes to determine the names of multiple labels, but seems like a lot of code.
[Code]...
i have 4 different excel files of different names.each excel file has 8 columns and 15 sheets.All excel files has same columns and same number of sheets (same sheet names and column names)i have to merge these 4 files into one.that file must be identical to the individual files.i.e same column names,and same number of sheets.
View 12 RepliesI am trying to get excel sheet name here is my code but it throws an exception "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index"
[Code]...
I have a datagrid which i manually entered value into. is there a way to get the value of the datagrid to a datatable or dataset
View 3 RepliesMy application searches for a specific worksheet in an open workbook. The code to find the worksheet is:
If Amendaction = True Then
If oBook IsNot Nothing Then
For Each ws As Excel.Worksheet In oBook.Sheets
If ws.Name = SheetToFetch Then
SheetFind = ws.Name
[code]....
When I execute the code, depending on the worksheet name, the result found in ws.name has one or more spaces in front of the text. e.g. "Bour001" used in creating the worksheet name becomes " Bour001" when returned by ws.name.
Trying to get names of all visible open excel workbooks. I found code online, that is below.I suspect the code is not working for me because either: I didn't include a reference (in addition to the MS Excel 12.0 Object reference and in addition to the Microsoft Office Interop reference, both were made) or something else basic being missed. i have been using the "early-bound" code below that is recognizing oExcelApp as visible...however, the open excel workbooks that I have open, are not being recognized.
I am using Windows XP and VB in Visual Studio 2010.Here is what I found online; disregard the late-bound if doesn't apply:
[Code]...
I am writing a program for my A-level coursework But for some reason I got this build error this has never occurred to me before, I have no idea why I can't use string for the name of my form.
View 8 RepliesHow 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]...
How to Display Excel Sheet names in ListView.
I however did for Access tables but Excel Sheet names don't know.
I need to populate a Combo Box with sheet names in an Excel File. I Have an openfiledialog that i search for the excel file and put the dirPath to a textbox, now i need to populate the ComboBox with the sheets in that file, the idea is so when i select sheet3 in the ComboBox, i can pass that sheet name to the string for processing.
View 4 RepliesI'm creating an application that will export several datatables into a single Excelspreadsheet, but on different sheet names. How can I do that?
View 2 RepliesI'm totally new to the programming area. I'm using VB 2008 and I'm trying to save three textboxes in a text format. I have tried some code but my problem is that I don't want to save always at the same name (test.txt). How can I do it.
Here is the code that I'm using (and probably has lot of mistakes :'( )
Public Class Form1
Const mForm1Name As String = "c:est.txt"
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim Form1 As System.IO.StreamWriter
[Code] .....
I understand that the problem is on the top where I've placed Const mForm1Name As String = "c:est.txt", but when I'm taking it out gives back a mistake. Also my form doesn't close when I save.
I'd want to get names of all controls of of all forms of my application. How can I do it?
View 2 RepliesI have a List box that I would like to populate with the Windows Font Names, how can I do this?
View 2 RepliesI think it was Joshdbr) a long time ago a directory rename program. However, I need help changing this to a file rename program. Our work directory will have a root folder, subfolder and .tif images:
Root
subfolder
22_38839283_939393939.tif
33_23343423_432232434.tif
subfolder
34_34342343_234245252.tif
[Code]...
I'm trying to setup a form to search for data within an existing DataTable.
FilterColumnsComboBox.DataSource = WOTable.Columns?
FilterColumnsComboBox.DisplayMember = ???
FilterColumnsComboBox.ValueMember = ???
[Code]....
I could hard-code in the column names ("WO_Number",WO_CustID","CustLastName", etc...), but would prefer to pick this up dynamically (partly because I want to reuse this code later).
i just got it in the internet and edited it..
Dim xlApp As Microsoft.Office.Interop.Excel.Application
Dim xlWorkBook As Microsoft.Office.Interop.Excel.Workbook
Dim xlWorkSheet As Microsoft.Office.Interop.Excel.Worksheet[code]....
what I want to do is have a column name in the excel worksheet which is not included in the code..i'm getting the data from a datagridview but it only shows the data in the excel.. i also want the field name of these data to be shown..another, as you can see in the code given, the directory is fixed.. what do i have to do to choose a directory to save my work? and also, i have many gridviews and whenever i'm exporting my work to the excel worksheet, it always overwrites my work.. i want to choose the directory to save, also show the field names, and make a separate worksheet for every gridview..
I entered in the A1 cell in excel column
I would like to see the form in the label1
Which code should write to label1?
So im currently making a program, basicly i want the user to put in a certain code into a text box, then when they hit the button, visual basic opens the excel spreadsheet, and seaches for the code the put it, so i have this excel sheet that has like a billioncodes and the names of the codes, so the names of the codes are in column a, and the codes are in column b, i want vb to open the spreadsheet, search through column b from top to bottom, then close the spreadsheet, and put the name of the code from column a into a label so the user can see. and possibly pop up with an error box if it doesnt find the code.
View 2 RepliesI'm new to Visual Basic and I am trying to set up a currency converter. I have converted a currency to UK Sterling on the first form and on the second form I want to have the same label with the same amount of UK Sterling as on the first form on the second form.
View 4 Replieshow do i read excel file at VB.net & display the result in a label or something..e.g i know cell A2 is a string of text - e.g Hello this is the P/L for the month i want grab that and put in a label etc.
View 11 Replies