Hi, I have an Excel 2007 Worksheet with many buttons and labels that act as menu options (i.e. user clicks the buttons, labels with images) and is presented with forms, or some thing else. These images / icons for the buttons and labels are loaded in VBA by assigning the Picture property of the Control and calling LoadPicture() method...
I want to query the table (Named range) from vba using SQL. name id Alpha 1 Beta 2 Gamma 3 I want to query like, "select Name from table1 where id =3" in VBA can someone help with the connection string that needs to be used. thanks! Srin ...
Using Excel 2007 VBA Have a sheet "Dashboard", have other sheets but some special task sheets that can be anywhere in the book, but will always be found between Sheets "TaskNew" and "TaskEnd". These special task sheets will vary in count. Upon dashboard activation, want to populate the listbox with the names of all special task sheets,...
Hello, I have two groups of data sets, A and B. I would like to know weither the average value of A significantly differs then B's average. How to do that in Excel 2007? (I know there's a TTEST formula in excel, I also know I don't need to use the paired version of it, what other parameters do I need to set and how to interpert the re...
I have a VSTO 4 (Visual Studio 2010) document-level Excel 2007 add-in where I use a ListObject to display data I retrieve from a WCF web service, which uses EF to fetch the data from the database. Some of the columns are Nullable<int> (as the database column is defined with NULL, and EF maps DBNull to null), and those that have null are ...
Hi, I was working on reporting and analysis using the Data Mining Add ins for Excel 2007 using SQL Server 2008. Does any one have any idea if there is something comparable/similar which can be used for data analysis and reporting provided by Oracle?? Let me know if you do and a link would be very helpful :) Thank you, J ...
In Excel VBA, I am using Excel as datasource for some queries. I am using the query as SQL = "Select * from [NameRange1]" - This works But, I want to use a table name instead of Namerange(Excel 2007 Tables). How do I use that? I tried "select * from [Table1]" and I also tried creating a Namerange for this table1 and it didn't wor...
I have Excel 2007 and Windows XP When this code runs: Columns("A:G").Select ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Clear ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Add Key:=Range("B2:B20000") _ , SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal ActiveWorkbook.Worksheets("Shee...
While using Microsoft Excel 2007, something weird happened and all the names after the nth row change to ABCD and I saved the file by mistake. How do I bring back the old names which have changed to ABCD? ...
I have an excel worksheet with columns A, B, C...columns A and B have some matching values. Column B and C are grouped together meaning the cells correspond to each other and now I want to assign whatever is in C where A matches B. I hope this makes sense. I could do it in sql i guess but i do not want to export all the data. for exampl...
Hello. I haven't had any luck finding an eval-type function to use in a cell for Excel. Let's say I have a cell A1 that contains string "C4". I'd like to be able to write an in-cell function similar to this IF(EVAL(A1)>10,"TOO BIG","TOO SMALL"). That would then effectively be C4>10 for the expression. Is this possible without VBA? ...
I want to replace a #NUM! result with a blank if {=SUM(LARGE(C2:I2,{1;2;3;4}))} returns a #NUM! (because 4 or more cells are blank) how do I replace the #NUM! with a BLANK? the reason for this is because i would like to RANK the cells that contain a numeric value eg: in the cell K2: =RANK(J2,$J2:J52,0) ...
I'm using the Excel.Application COM object from a Python program to open a CSV file and save it as an Excel workbook. If the target file already exists, then I am prompted with this message: "A file named '...' already exists in this location. Do you want to replace it?" That message comes up despite the fact that I have set the XlSav...
How Can I open and read all data in excel file to perform some operations on say write them to a database ... ...
I have a workbook developed in Excel 2003 that uses a parameterized query. The parameter is linked to a cell on another worksheet and is set to Refresh automatically when the cell value changes. The linked cell contains a dropdown list, but when the user chooses a value, the refresh does not work. This worked fine in 2003 and still ...
I have an excel csv file that i am uploading to sql server table using sqlbulkcopy,data in excel looks like this 121 **ABCDEFG** 138.00 141 XYZ **HIJKLMN** **OPQRSTUV** So basically this 3 line make a single record in table,how should i merge these 3 line comments in one ? ...
In Excel 2007, have a button that triggers a macro, which selects a few sheets out of many and sends to Application.Dialogs(xlDialogPrint).Show. As part of selecting the few sheets there are other macros triggered like showing certain rows, password protecting and unprotect-ing, etc. It prints and cancels fine, except when users click ...
I have the following VBA code in a module of one of my .xlt files: Public Sub SetShapeTop(ByVal shapeName As String, ByVal topValue As Single) ThisWorkbook.ActiveSheet.Shapes(shapeName).Top = topValue End Sub In my VSTO add-in, I have the following C# code which tries to call that VBA function: m_worksheet.Application.Run("SetShape...
I have an Excel sheet with various data entries that are in date order going down the page, with the dates in column A. I need a formula that will take a text string from an adjacent cell, then look back up a neighbouring column for the most recent match then return the date from column A. Currently I have this formula in cell H100: =LO...
I have this piece of c# code in my Excel 2003 add-in: var leafPoint = m_worksheet.Shapes.Item("aPoint").Duplicate(); leafPoint.Name = "Shape" + (m_shapesNameIndex++).ToString(); leafPoint.OnAction = m_worksheet.CodeName + ".PointClicked"; leafPoint.AlternativeText = string.Format("Correlation Value: {0}", item.PointData.Corr...