I have an XSLT template that gets applied to an XML file of data. The template generates an Excel Spreadsheet XML file. Everything works wonderful except for one minor issue.... When I open the spreadsheet in Excel, it treats it as an XML import and asks me whether the stylesheet should be applied. I would like to have it so it autom...
Hi, I've inherited some VBA code (non-.NET, Excel 2003) I have to modify. I want to obtain a handle on a cell range but VBA doesn't like my syntax, saying 'Run-time error 424: Object required'. When running this code it highlights the line assigning streamsTotal. Private Sub totalStreams() Dim streams, streamsTotal As Range ...
I have a Pivot Chart with data used as row labels. When an option is deselected, the option disappears from the filter list and has to be readded back, which is non ideal since it has been relabelled and the relabelling is lost when that data field is added back in. Before deselection: http://farm4.static.flickr.com/3364/3661401099_c76...
As the title explains, I have an Excel 2003 workbook and I'm copying a number of columns of one sheet to another in VBA. Unknown to me, someone has hidden a few columns on the source sheet and it has messed up how I process the cells in the destination sheet. How can I programmically determine: IF there are hidden columns WHICH colum...
Sample Modified and self-produced (d) Food packages (d,d,d,d,e,e,d,d,e,d,d) Other country’s food labels (d) Using food labels to choose foods for Healthy eating (d) Measuring cups food models (d) Food labelling exercise – custom (e) Food product promotional pamphlet (d) It pays to read your grocery label (d) Old food labels (d)...
How do I replace the formula in a cell with the output of the formula? I simply need "=RIGHT(E86,LEN(E86)+1-FIND("(",E86,1))" to become "(e)" Is there a way to do this to the whole sheet? Replace all the cells with formulas with the text they are displaying? I am using version 2003. ...
1) hi i just wanted to know why excel-2007 record macro does not write anything for example when i do the following: i insert a rectangle on the sheet and change its backcolor... (on the other hand, if i do the same thing in excel-2003 i get some code) 2) also is it possible to using vb to ask excel to put the rectangle on specified p...
hi is it possible to write something like zoom-in and zoom-out button... for example i will have a userform on which i will have two buttons one for each zoom in and out... whenever the user clicks on one of the buttons plus user clicks the cells (or selects the range) that cell or range will be increased or decreased using the ActiveWi...
I have an Excel workbook with a number of features: One main user-facing sheet One summary sheet based on the user-facing sheet's data A number of graphs based on the user-facing sheet's data (as in, the type of graphs with a separate tab for them, rather than objects within a worksheet - I'm not sure if they have a special name or spe...
hi can you show a vb code for excel-2007 format->recolor->set transparent color on an a image inserted... by the way, forgot to mention that excel-2007 record macro does not record this stuff otherwise i would not ask it here... :) ...
Hi, I am trying to execute a SSIS 2008 package on a 64-bit OS and import Excel 2003 files to SQL Server 2008. I have created an OLEDB Connection to the Excel file with a Connection String that retrieves the Excel file from a variable, inside the ForEach Loop Container. The Run64BitRunTime is set to false. I am not able to edit the SQL ...
I'm trying to get a handle to the worksheet that was created by a copy operation. following code used to work: Dim wsTempl As Worksheet, pageCount as Long Set wsTempl = Sheets("Template") For pageCount = 1 To 5 wsTempl.Copy After:=Sheets(Sheets.Count) Set ws = Sheets(Sheets.Count) ws.Name = "p" & pageCount Next But stopped w...
I have made an SSIS package that uses the Excel source to extract data from an Excel 2003 file and inserts it into SQL Server. When executed on production machine it gives and error of 'productleveltoolow'. Excel is not installed on the server. Can this error be due to this reason? ...
Hi there, I'm wanting to SUM a number of rows in Excel, based on a value. In the picture below, you can see the table. I want to put a value in F1, containing the sum of the values for Jan -> (month # specified in C2) where the Status is the value in C1. If you do =SUMIF(B5:B11,"open",INDIRECT(CONCATENATE("C5:",ADDRESS(11,2+C2)))) ...
Good Afternoon, A customer has provided me with a spreadsheet file his team uses to provide quotes for a product. The spreadsheet has extensive data in underlying sheets and calls those sheets as part of the numerous formulas on the quote sheet. I've been tasked with web-enabling this tool such that the quotes can be generated on the ...
For many reasons, I have installed on my laptop MSExcel 2003 and MSExcel 2007. I need both versions to develop specific projects for each version (Document level projects and Application level projects). Now I need to do a WinForm project that opens an Excel file, read a CustomXMLParts and write a new Excel file. I'm using a reference t...
This is one of those things that I'm sure there's a built-in function for (and I may well have been told it in the past), but I'm scratching my head to remember it. How do I loop through each row of a multi-column range using Excel VBA? All the tutorials I've been searching up seem only to mention working through a one-dimensional ran...
In Excel 2003, I have a macro that accidentally tried selecting a page field item (New York) that didn't exist. This renamed the currently selected page field (Alabama) to the value I tried to select (New York). I now have 3 or 4 values that are now wrong. Is there a way to refresh these pivot table values to the correct values without ...
I have an Excel 2003 sheets being used by clients. I need to update a Delphi application that extracts data from these cells, but the cells are not named at all, they are just j3 and j55. Can the data from cells still be sent across to other applications? Can Delphi application take these values? ...
Excel Pivot Tables can display a grand total row that, by default, sum each column's data. I would like to display multiple grand total rows that display each column's count, average, standard deviation, and standard error. Does anyone know how to do this? ...