Spreadsheets And Charts In VB2010?
Apr 6, 2011
My project that I had built used spreadsheets and charts within the forms to provide the user with the necessary data. This worked fine for VB2008 as it had all of the ActiveX office web components built into it. It seems that VB2010 has a different set of base components and emphasis office 14.0. I was wondering how people have gotten around this or if they can. I tried using DataGridView, but it doesn't seem to be able to do what I want to do. I need the ability to have users enter data into a table and then use that information to be able to build graphs real-time based on their data.
View 2 Replies
ADVERTISEMENT
Jan 24, 2011
I am trying to write code that will compare the information in all row(one column) in the two spreadsheets and if they are not the same update another column on the row with a difference with Updated. but i am getting this error
countExcel = xlsSheet.UsedRange.Count
first_index = 1
last_index = countExcel
[code]....
View 1 Replies
Apr 11, 2011
I have a directory with 1600+ excel spreadsheets, all of which have one row of data located in row 2 which I need to get into a single spreadsheet for importing into Access.
View 1 Replies
Apr 20, 2010
What is the easiest way to deploy VB code to the personal.xls spreadsheets of other PCs on the network? This is a server network, not peer-to-peer.
View 2 Replies
Jan 27, 2012
Has anyone successfully transferred data into Excel with multiple spreadsheets?
View 2 Replies
Mar 18, 2010
I'm trying to use the ComboBox items to reference specific spreadsheets at location 1 and copy them to one singular spreadsheet as location 2.
oExcel = CreateObject("Excel.Application")
myDirM = "L:DC Productivity ReportTA Temp"
oBook2 = oExcel.Workbooks.Open("C:TestBook1.xlsx")
[Code]......
View 5 Replies
Aug 15, 2011
I have produced some VBA in Access that creates a spreadsheet.I have also created an SQL query that retrieves records from an Access table.I have 48 tables (each table for a specific institution centre).I have created another bit of VBA code that creates a spreadsheet and loads the records from the query in to the spreadsheet.Each centre has a unique Sequence Number (Indent Number)At the moment though, all I can do is import one table (records for one institution) in to a spreadsheet. I want to end up with calling the function and having an output of 48 spreadsheets being saved to my desktop, each spreadsheet containing records of a different center.I have thought about putting a loop in, but not sure how I would quite go about it.
Here is my code to create the spreadsheet:
Public Sub ExcelExport(lngIndentNumber As Long, strFolder As String, strCrit As String, strReport As String)
', ctlLabel As Label,
DoCmd.SetWarnings False
[code]....
View 2 Replies
Jan 12, 2009
I am trying to write a simple program which will simply have buttons to open spreadsheets, and a search facilities to look for spreadsheets with a title which is an invoice number. I have my basic forms layed out, all a need now is help with the code.
I am using Visual Basic 2008 Express, and just need a line of code for a button to open an application/spreadsheet. Also, is it possible to have a search box open a file automatically?
View 9 Replies
Apr 1, 2010
How can we add charts in VB.Net?
View 1 Replies
Jun 29, 2010
setting up a Bar chart and a Pie chart... The Barchart repsent how many people have that and the piechart is how much of what that person has bought.. i need to be able to change that?
View 2 Replies
Mar 30, 2009
How to create org charts in vb.net?
View 6 Replies
Apr 15, 2012
currently i m workin on Ms CHarts wid VB.NET nd create a chart sucessfully bt nw i wnt to click on that particular bar of that chart nd want to get that particular axis label of that bar ..
View 2 Replies
Sep 16, 2011
I am new to Visual 2010 and cannot seem to find any information about using Charts.I have an array, call it PressureOutputs(1000), which I wish to plot against a second array,e(1000).Can anyone please explain how I would add these two arrays to create a series on an x-y scatter graph (which is already present on the Windows Form Application), or point me to a source of information about how to do this?
View 2 Replies
Sep 10, 2009
I'm trying to get my head around excel charts. I've poured over these posts for the last couple of days now and i'm coming up dry. I've got a xl file thats got some data in the first 2 columns. I want to put the data in an XY scatter plot. Column A is the x coordinates and b is the Y.[code]...
View 6 Replies
Apr 20, 2011
Under VB2 I could create a form with many charts (One form had 12 graphs). You could define the chart once and cut and paste it the required number of times on the form. Each chart had an index and the code used the index to create and update the desired chart with the appropriate x,y data. Is it possible to do this in VB2010?
View 5 Replies
Jun 12, 2009
I am writing an ASP.Net VB2005 application, and I want to give my users the ability to create custom reports and charts on the fly, based on parameters defined in a wizard control. The data source is SQL 2008. This is also on my own dime, so I am looking for something that will not require a second mortgage.
View 2 Replies
Apr 29, 2011
How to create Charts in vb.net. Is it possible to have a chart like this without any additional components
View 1 Replies
Nov 16, 2011
I have a MVC application, which creates a Chart in the business logic like this:
StatisticsModel.Chart.Width = 150
StatisticsModel.Chart.Height = 300
StatisticsModel.Chart.Attributes.Add("align", "left")
StatisticsModel.Chart.Titles.Add("Statistics for: " + StatisticsModel.ProductNumbers)
StatisticsModel.Chart.ChartAreas.Add(New ChartArea)
[Code]...
View 1 Replies
May 11, 2011
i am working on a vb.net windows application. i want to incorporate the dynamic graphs and charts in the application.
View 1 Replies
Feb 9, 2011
i am trying to use an arraylist to build a graph using fusionfree however i cant get it to work, it keeps showing the same item from the array list
[code]...
View 2 Replies
Jun 22, 2010
I have a form with two seperate charts placed on top of each other.I am trying to set up a toggle button that works in sequence i.e. loads second graph over first on click. When clicked the second time it loads the first one and so on.I realise i can do this by making one visible then making it not visible but i am having troubles with the circular click requirement.
View 3 Replies
Mar 4, 2009
Is there a way to conditionally format an Excel Chart? For example I have a bar graph. Currently I have the bars a purple color. I would like to turn a certain bar red if it meets certain criteria. Is there anyway to do this?
View 1 Replies
Oct 18, 2010
i want to create excel charts in vb.net with data fetched from my database server in which records are selected at run time through vb.net form.
View 5 Replies
Jan 31, 2012
I would like to create several pie charts at form load. I have a database and I'm able to populate the pie chart dynamically but what I want to know is that is it possible for the system to create multiple pie charts? The pie chart represents the amount of free and used disk space.. obviously a server has multiple drives. I would like each pie chart to represent each drive.. but I don't want to drag and drop a chart control each time.
[Code]...
View 2 Replies
Mar 23, 2010
Can i create a connection which will give the next registered user a user ID (a number) from the .csv?
II tried something with Sum and +1 every time an "add" button is clicked, so it would count the number of registered users but when i clear the .csv file i will have a number that ain't connected with the amount of users.
if i Ex. have twenty people registered in my .cvs file the next one will show the number 21 in a label in the "add form". Excel have the numbers from the 1 to infinity in the side if i could call the next empty line number into a label or something like that the user ID will follow the numbers of registered users.[code]....
View 12 Replies
Feb 26, 2012
I'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]....
View 1 Replies
Aug 19, 2011
how to create data charts in Access / VB ?
View 2 Replies
May 5, 2009
Probably a silly question but is it possible in Excel or VB to drag a charts point(s) ?I had a quick look at the object "Points"(part of Series Collection object) methods and saw there was a "Select" function.
View 4 Replies
Aug 10, 2010
I am creating a data analysis program (using Visual Studio 2010) having several functions. One of the functions is to create graphs (scatter plots) of my data. Now occasionally, I may collect a data point that appears good when I take it, but when I plot it on my graph, I find that it's bad data and needs to be deleted.
My problem is that I would like to have a button called, say, "Delete Points". I hit that button and then choose the point directly from the scatter plot. The data source for the plot is then updated removing the offending point. I would then also have a button called "Restore Points" to bring back deleted points.
I have been thinking of doing this in Excel, but only because I don't have much experience with any other plotting program. Using the Excel approach will have its shortcomings, like needing to push the "Delete Points" button on a GUI separate from the Excel window (and thus needing to activate the Excel window).
View 3 Replies
Jun 10, 2010
I'm using Dundas Chart Profession within my VB program to generate a chart based on my data. Right now I have my charts opening fine but I am unsure how to add the functionality to let the user choose to print (and export) the chart once the program is running.
View 1 Replies
