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?
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.
I have an Excel 2007 workbook chock full o' VBA macros that do various things, including one that jumps from chart to chart making PDFs of each using PDFCreator, based on some code I borrowed from Ken Puls (url...).However recently I and some users of the workbook started having problems where the PDFs would be created with either gray image artifacts over the charts,or the whole chart image would have a double of itself skewed slightly. It just happens the problems started after we did a global upgrade to Office 2007, though I had had 2007 installed on my computer for a while and tested and used the workbook extensively without issue up until then. Here is the part of the code that automates the printing:
Sub PDF_print_all() 'Author : Ken Puls (www.excelguru.ca) 'Macro Purpose: Print to PDF file using PDFCreator[code]...
The problem is not consistent either... sometimes it will print to PDF with an oddly shaped block of gray, and sometimes it will only have the whole chart image doubled. The only consistency I could find is that sometimes if an object is selected in a chart beforehand (a text box, chart line, axis numbers, etc) the gray artifact will partly mimic the shape of whatever object had been selected.I wish I could include example images to show exactly what's happening.I know it's not a problem inherent to PDFCreator because if I manually print to it in Excel, the PDF image looks perfect. It's only when I use the automated method that the problem occurs, so I thought maybe it was the code.
I'm trying to copy multiple excel source files into one excel file. My current code is working only for 3 source files..If more than 3 files are there, it doesn't copy the data but creates blank work sheet in the output excel file. Lets say I have a source folder with 5 excel files. Each workbook contains one worksheet with data. It copies upto 3 worksheets along with data into output excel file.
Lets say excel1 contains A as work sheet, excel2 contains B as work sheet ,excel3 contains C as work sheet ,excel4 contains D as work sheet ,excel5 contains E as work sheet .Now my output excel file should look like..OutputExcel with A, B, C, D, E along with respective data.But my current code is giving output as A,B,C worksheets along with respective data but its creating blank sheet1,sheet2 in place of D & E.
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
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
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?
My 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:
I have 3 tables: Customer, OrderHeader and OrderDetail. Customer and OrderHeader joined by CustomerId, OrderHeader and OrderDetail joined by OrderId.how to create an xml file that combines these 3 tables together having the following structure using ADO.net?
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:
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.
I have multiple forms and reports with different print area. Some are designed to print to a thermal label printer and others to department shared printers. Currently the user is able to change the printer in print dialog box and print to differernt printers. I want to be able to create a form where the user can assign different printers for different jobs and not have to worry about it.
The problem is, i have never worked with printing function and my collegues arent too smart so I was wondering if someone can throw me ideas on where to start so i can start googling for it.
I know how to create a control at runtime e.g.[code]Can anyone tell me how to create multiple instances using a for-next loop? e.g.[code]The part I can't work out is how to give each new button a new name... like button1, button2 etc
I have a form (form1) and I havea button on form1 (button1) that will start a second form (form2).How can I make it create multiple instances of form2 when button1 is clicked?i tried a process module that the studio comes as standard but it does not allow me to start multiple instances...how can i do this?
I'm creating a database installer where I have some code to create database, tables, stored procedures, etc.I don't have problems when creating the database, tables and inserting required data. My problem is when my code gets to the stored procedures section.
Here is what I do:I have different text files (database.txt, tables.txt, insertdata.txt, storeprocedures.txt) where my sql syntax is located.I execute every process/text file using the following:
ExecuteSql("master", GetSql("database.txt")) ' Creating 1 database. ExecuteSql("mynewdatabase", GetSql("tables.txt")) ' Creating 15 tables. ExecuteSql("mynewdatabase", GetSql("insertdata.txt")) ' Inserting data to many tables. ExecuteSql("mynewdatabase", GetSql("storeprocedures.txt")) ' Creating 6 stored procedures.
Here is part of the error:In exception handler: Incorrect syntax near the keyword 'PROCEDURE'. "This is the second stored procedure because the variables I get below belong to the second one"
Must declare the scalar variable "@intVariable1". Must declare the scalar variable "@intVariable1". Must declare the scalar variable "@intVariable1". Must declare the scalar variable "@intVariable1".
When trying to create 6 or even 2 stored procedures using the same file 'storeprocedures.txt' is not possible. If I leave just 1 it works but I really want to keep them together.
Creating 15 tables using the same file 'tables.txt' works, inserting data in different tables using the same file 'insertdata.txt' works.This is the general syntax I use:
Create Procedure sp_stored1 @intVariablex int As
Is is possible to create more than 1 stored procedure the way I'm trying to?Do I need to end every stored procedure with specific sql syntax, other than the 'end'?
I have a form which has a textbox named "textbox1", and a button named "Button 1". Button 1 is meant to be a submission for textbox1 (i.e. when button1 is pressed, the value of textbox1 is saved and remembered). I want the value of textbox1 to be remembered on any computer, but I need it to be update-able too. I tried using settings to do this like so:
Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Me.TextBox1.Text = My.Settings.TextBox1
but the problem in doing this is it only works for the current user. When the application is then put on another computer the value is blank.
I thought I'd give VB a go after developing with C# for the past few months. I'm using Visual Studio 2008 and have imported the VB IDE settings. I'm going through the same steps in VB as I've gone through in C# to create my solution for an n-tiered ASP.NET web application, but the results are unexpected. Here's the steps:
1. File > New Project > Other Project Types > Visual Studio Solutions > Blank Solution .... name the solution & choose the location ...
2. At this point, I want to proceed to add projects as follows by right-click on the solution in solution explorer
a. Add > Visual Basic > Web > ASP.NET Web Application ... name / location of the Web Client
b. Add > Visual Basic > Windows > Class Library.. name / location of the Business Layer
c. Add > VB > Windows > Class Library ... name / location of the Data Access Layer
BUT, as soon as I complete step 2a, the solution disappears from solution explorer. "Show all files" is selected. This happens regardless of the project I create first.
I have a requirement to create a multi level treeview in ASP.Net (with VB) but I am completely stuck on how to start this. Currently my treeview is a fixed 2 level approach but now I need to rewrite this to be more dynamic and support extra levels being added into our database tables.So this treeview needs to support as many levels as needed without having to rewrite any code each time we want to add new level, Ideally we will just insert the data at the database level.I think I have the database part designed correctly, I created 2 tables Menu and MenuItemsMenu has 2 columns ItemID and ChildIDMenuItems has 2 columns ItemID and Description Doing this query:
I'm trying to develop an application in VB 2010 that will monitor files in a directory that the user specifies. The problem is, this application is going to be installed in diferent computers with diferent Operative Systems (windows 2000 and XP).Is this possible? or should i change mi programming lenguage?Another thing that comes to my mind is that maybe i should use diferent frameworks (i'm afraid that framework 4.0 may not work in Windows 2000).I apologize if i'm posting in the wrong place, i'm new here.
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
I 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.
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:
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.
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.
I'm creating an Addin, specifically to MS Project 2007. This Addin create a toolbar with a button that will allow user to export his project to excel sheet in MS Excel 2003 or 2007. My problem is create workbook with worksheet. I already made toolbar and added the button. My button can open Excel Application but i can't add workbook and worksheet.