it seems that every Excel workbook I create in Vb, Excel automatically creates a ghost book with the name Bookn.xls where the n is incremental. After a lot of processing, I could have 20+ blank books open and running in taskmanager!
View 7 Replies
while creating Excel files in vb.net, all is fine, except when I want to close my PC and there are many popups to save or delete "bookx.xls". How do I prevent these blank books from being made??
View 2 RepliesI have a USB interface connected to my PC which is used to control DC motors (robotics). Supplied with the interface is a VB program that produces a form with text inputs (motor speed) and tick boxes (motor on/off). This program calls upon a supplied .dll for the interface. I have played around with this program and have added extra buttons to 'stop all' or 'run two motors simultaneously' etc.What I really want to do is run a sequence of events, for example:
-Motor 1 on, speed 50, run time 5 seconds
-Motor 1 off for 2 seconds
-Motor 2 on etc, etc
i am new to vb.net programming i am trying to access excel worksheet pre defined with name Books.xlsx through vb.net i have taken a form with one command button i wrote below code in that:Imports Microsoft.Office.Interop Imports System.Runtime.InteropServices
[Code]...
i am new to vb.net programming i am trying to access excel worksheet pre defined with name Books.xlsx through vb.net i have taken a form with one command button i wrote below code in that:
[Code]...
I am exporting a sql data table to excel using VB 2008. The export works fine but when I open the excel spreadsheet and click on individual cells, I see an apostrophe at the beginning of the string. Is there a way to keep this from happening in the export?
Here is my code:
Dim strfileall = "C: estdata.xls"
Dim SQL1
As String =
[code]....
I am Creating a sales voucher.i have 2 labels Namely lblHilight0 and lblCount0 and also 6 textbox namely txtNameOfItem0, txtActualQuantity0, txt BilledQuantity0, txtRate0, txtAmount0 and txtRemarks0..All these Controls are in a Panel named PanelItems..The AutoScroll Property of PanelItems is set to True..when any key is pressed in txtremarks0 the new objects are created as follows [code]when i scroll down and up and then if i press a key on txtremarks(i) then it leaves spaces..
View 10 RepliesI'm creating a hierarcy of folders where we have a standard group that have modify access on root and level 1 that is set to apply on this folder, files and subfolders. When I create a special set of folders in level 2 I don't want the default group to be inherited (only administrators). The new folder wil get new access from a new group in AD.My chalange is to stop inheretage on the new folders on level 2 in VB.NET.
View 6 Repliesi am trying to run the following code :
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
[code].....
I was having problems creating a DLL and using it in my Excel application. Here's what I've found which has worked for me immensely: [URL]
View 1 Replieswhen I'm creating a new property in Visual Basic .NET in Visual Studio 2010, the rest of the Property (template?) doesn't complete the basic framework of the property in the code editor. It is now treating a statement like:
Public Property Length() As Integer
Instead of completing the property as it used to (code follows), it simply goes to the next line:
Public Property Length() As Integer
Get[code].....
What happens now is that, if I type in the 'End Property' code, the name of the property will now be highlighted as an error since it doesn't have a 'Get' or 'Set' portion.However, when I THEN type the 'Get' on the line following the 'Public Property Length() As Integer', then the balance of the property is created in the code automatically.I don't know how this got changed, but would love to change it back.Does anyone know if there's a setting in VS2010 that addresses this, or if it's something with the basic templates that visual studio uses for creating the basic code components?The weird thing is that for everything else, from class declarations, structures, functions and subs, the IDE still creates the balance of the code structure correctly. The only area where it doesn't is for Property declarations.
how I can stop the datagridview from creating a new row when I click on the "Add new" icon? The reason for doing this is because I want a form which consists of data details view.
I would like it to be like this. When I click on "Add new" icon, a new form appears instead - no row is created for datagridview.
I'm starting a new project to handle info from some text files, a kind of sorting module so I'd like to give it a try using LINQ but looking for a book I realized that there are more c# books than vb, so I wonder if c# have better support or if it is more suitable than vb.
You think there is some advance on use c# or vb.
I'm creating a macro in excel using vb?What the macro is doing is checking if the row and column headers are same, and if it is then I want it to save the row header (the date in this case) AND the value (a number) into an array, and this is done in a for loop and goes on.... I dont know if I should use 2-D array or a 1-D array that stores 2 values....Not sure at all !Then after the outer most FOR LOOP is done, I want to print those values stored in the array.
Here is what I have so far, this works actually however i'm using 2 seperate arrays, one to store the row header (the date) and another array to store the value. But really I want to make it simpler, shorter and use only one array that stores both of these values as we go through the for loop and at the end of the for loop, all the values from beginning which are stored can be printed out.
Here is my code :
Sub Test ()
Dim sys_arr() As String ' declaring the array to store the values
Dim sys_date_arr() As String 'declaring the array to store the dates
[code]....
This totally works but with 2 different arrays, all I want is just 1 single array (not sure if it is 2-dimensions or still stays as 1 dimension but with 2 different variables)... and then the array can store the date and variable correspondant to the date, and goes to the next row, and do same thing... So the output results should be like for eg :
2/12/2010 37
2/13/2010 41
2/14/2010 66
and so forth
I have this peace of code, where I want to make an excel file:
Dim filename As String = ""
Dim sheetname As String = ""
Dim xlApp As Excel.Application
[Code]....
The problem is that this only works if the file and sheet already exists. How do I create a new Excel file?
Using VB.NET I created an excel sheet with list of items in dropdownlist.[code]But i can able to view the listbox upto "testing", rest of the items are not diplayed in the listbox why?Is there any limit for dropdown list items, If so how to increase the limit?
View 1 Repliesit is possible to enter values using vb.net and sending it to excel and displaying graphical representation of the values from excel to my vb form?
View 1 RepliesMy program exports a datatable to excel and then selects the cells in excel that have been populated with the data. I need to create a pivotable using those cells (not the datatable). The below is the code I have so far, but I cannot get the pivotcache section to work. I have looked to the VBA forums for help as well, but I don't think those are helpful since I'm creating this as VB program. Other threads I've been using as reference are:
[Code]...
Creating/Working with Excel fro .NET?
View 2 RepliesI have an Access 2007 database connected to SQL Server 2005. I want to use VB to create an application that will retrieve and manipulate data in our SQL database. I'm familiar with VB and I'm familiar with Access. What I don't know is how to get started creating forms in VB that's accessible through Access. Are there any books out there that will help me get started?
View 3 RepliesWhat would you recommend as the "best" VB.NET and C# books for learning Design Patterns?eferably books that actually give examples of when to use the patterns. I need torecommend some books to a group of C# and VB.NET developers.
View 19 RepliesI am attempting to create a worksheet in an existing excel spreadsheet from visual basic 2008 but it does not create it. My code is below.
Dim strFilename = "C: est.xls"
Dim SQL2 = "CREATE TABLE" & _
" [" & strFileName &
";].[Sheet2] ;"
[code]....
I have a pet project of mine that I'm working on; basically, it's for scouts during FIRST FRC matches and allows them to enter data about teams into an Excel sheet. I'm having a problem creating said sheet, however. I want the program to create a new sheet, with the filename being whatever the user puts in a textbox I have. the interface takes data about teams one team at a time; when user wants to add a new team, they press "Enter Data" (which puts whatever is in the interface on Row x, then the user will be able to add new data to Row x+1 each time they press said button, etc). The main issue is that when I have the code as follows:
[Code]...
I've narrowed the problem to the "filename" and "filepath" variables. I've Googled around for answers, but the articles that I found about the error above are too vague to help me. Does anyone know why VB.NET is giving me this error? Also, how can I reuse the same Excel sheet for the entire duration that my VB.NET application is running? As in, I want to be able to add ~50 or so teams to the same Excel document (for example, all of it going into "MyRegional.xls").
Sorry if this is an obvious problem to solve or anything; I'm fairly new to programming in general, so I'm clueless as to what's going on with this. Up until this point, my program runs fine and when I comment out "Dim filename..." and "Dim filepath...", the program will run normally. If it helps, I'm running VB.NET Express 2010 in Windows 7 Home.
to create excel workbook dynamically where data will be input and manipulated by user. i want graph as well to be created using the data i manipulated and entered.i want as many as work sheets to be added in workbook once it is created.
View 2 RepliesI'm trying to create multiple Excel charts, in one work sheet using VB.net.This is the code:
Code:
'creating the chart
Dim chartPage As Excel.Chart
Dim xlPump1Charts As Excel.ChartObjects
[code]....
I'm trying to use the System.Windows.Forms.MonthCalendar control within a VSTO Excel workbook. I want the MonthCalendar to pop up when I click a button in the ribbon, but so far I can't get the control to display at all.
Private Sub DeliveryDateFromCalendarButton_Click(ByVal sender As System.Object, ByVal e As Microsoft.Office.Tools.Ribbon.RibbonControlEventArgs) Handles DeliveryDateFromCalendarButton.Click
[Code].....
Does anyone know of any good tutorials for creating Excel Addins?
View 1 RepliesI am creating an excel file in my vb app. Below is the code I am using to do this. But when the application is closed, I still have an instance of Excel running in the background. How do i close it? I can do it with the xlWBook but not the xlApp.
'create empty excel file
xlApp = CType(CreateObject("Excel.Application"), Microsoft.Office.Interop.Excel.Application)
[Code].....
I've created a User-form in excel and I need help in the coding part of it.Currently I have coded the User form, as shown below:
Option Explicit
Private Sub cmdAdd_Click()
Dim ws As Worksheet
Dim r As Integer[code].....
The section which says 'Find first free row from A21' up to'Cells(r, 4).Value = Me.txtQty2.Value' (highlighted in bold) is where I need help. I currently have 3 combo-boxes called 'cboProduct, cboProduct2 andcboproduct3' and next to each one of them I have a textbox called 'txtQty1,txtQty2 and txtQty3'. I am trying to get the first combo-box to find the first free row starting from A21 and go to cell B21 and the first textbox to go to D21. For the second combo-box to find a free row from A21 and go to B22 if B21 is used and the same applies to the textbox , if D21 is used to go D22.This also applies for the third combo-box and text box. However my coding doesn't work.
I am looking for a way that on the form I am designing , there will be a section that displays an excel type spreadsheet that stores rows of similar information as show below.
length(mtr) width(mtr) height(mtr) cubic weight(kg) physical weight(kg)
eg. 0.15m 0.25m 0.35m 3.38kg 5kg I need the spreadsheet to allow the user to select rows and the form can have command buttons to allow then to delete selected row, etc. But I dont want to have it that the system this program eventually runs on to need to have excel actually installed on the system.
