I have a VBA publishing macro in Excel which generates a published workbook based on a master configuration worksheet and a number of worksheets with the data. The published version is straight data, still formatted, but with no formulas and with certain notes and background information suppressed. Basically, the master configuration c...
I'm working on some VBA scripts for an Excel worksheet, and I've created a module that contains a whole listing of mostly strings that store the name of each of my database fields. That way, if anyone modifies the database, they can update the VBA variable in the module, and then all my scripts, which reference the global variable instea...
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... :) ...
In .NET C# I'm trying to open an Excel template, add some data and save it as a new document. I'm trying to use the OpenXML document format. I can't seem to find any guidance on how to do this. Seems like all the documentation talks about how to write various parts to the Package but I can't find anything on what to do when you're done...
hi i have a created an Excel Add in(which creates a new ribbon for excel 2007) using vs2008-vsto-c# and also created a setup project... i install the setup project on other machine, then go to the installed folder, where i see all .dll files, including my project name .dll, let's say ExcelAddIn.dll please can you tell me what should i d...
I've tried this: 'start Excel app Dim exApp As Microsoft.Office.Interop.Excel.Application exApp = CreateObject("Excel.Application") ' load excel document exApp.Workbooks.Open(fname) Dim exSheet As Microsoft.Office.Interop.Excel.Worksheet exSheet = exApp.Workbooks(1).Worksheets(1) and than, for example a...
I have a table with first column as primary key. Ex: id value1 value2 1 10 5 2 2 3 3 12 5 .. I also have a second list of id's I want to select, which can have repeated ids. Ex: selectId 1 2 2 2 5 10 .. How can I "merge" the two tables (something like INNER JOIN) to obtain: id value1 value2 1 ...
I am using ColdFusion 8. Doing something like this: <cfheader name="content-disposition" value="attachment; filename=abc.xlsx"> <cfcontent type="application/msexcel"> <html> But I get a file like abc.xlsx.XLS. The reason I'm trying to get an XLSX is because sometimes the XLS version is so large and Office 2007 gets stuck opening it o...
Hello, I'd like to initialize a ComboBox that exists on a Chart (a stand-alone chart, not a chart embedded in a sheet) to have two values, "Expenses" and "Income". I tried entering a literal list ('={"Expenses", "Income"}' or '=("Expenses", "Income")') but trying either of these gave me the error "Reference is not valid". (The place I...
Excel defines shared formulas and array formulas. What is the difference? My understanding is that array formulas are now obsolete. Is this true? Is it possible to transform array formulas into shared formulas? ...
Using Excel 2007, is it possible to change the transparency of chart grid lines using VBA or VB.NET? I have the following code, which throws an exception on the last line: Dim axis As Excel.Axis = chart.Axes(Excel.XlAxisType.xlCategory) axis.HasMajorGridlines = True axis.MajorGridlines.Border.Color = Color.Gray.ToArgb axis.MajorGridlin...
Is it possible to connect to an Analysis Services Database (2008) from Excel 2007 on Windows 7? I have installed the "Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider" but it's not possible to create a connection. It works on windows XP and on Windows Vista so I guess the problem is Windows 7? ...
I'm trying to open a series of Excel spreadsheets using an instance of Excel created inside of a module in an Access database. I can get the files to open properly; however, the actual call to make Excel start takes quite a while, and to open the files takes even longer. The location of the files doesn't matter (same time to open on a ...
aI have an Excel 2007 workbook with about 150+ worksheets and I want to select the data from the same same cell in all worksheets and copy the data (it is all text) from only those cells that contain data; to a separate worksheet with the data listed in a column. ...
I have a problem with an Excel Template in Excel 2007. I need to remove a row from a summary report but the developer who created this report has somehow managed to set it so that only certain number of rows & columns are visible (in case you are interested it is A1:G30) - no headers, no grid, just blue nothingness. Deleting the offendi...
Does anyone know a way to show duplicate values in an excel pivot table (i dont want to copy the values out and run formulas to fill in the blank rows). The default behavior seems to be to suppress duplicate values when grouping by a row label...I want to show them. Let me know if you need a screenshot of what I am talking about. Thank...
I have a c++ unmanaged project whose output is an .xll file which is an add-in loaded by excel at startup, this add-in can work with both versions, excel 2003 and excel 2007. Now, what I need to do is to obtain the version of the excel instance that the user is actually using for working with my add-in. Does anyone can suggest me how t...
I would like to work with internal .xlsx files (styles.xml). I was using <oXygen/> to navigate through internal structure, but now it is throwing an error. How to unpack xlsx files (and then pack them again)? ...
I developed a new office 2007 addin using VS 2008 and VSTO. after this i go to Office->Excel Options->AddIns->COM AddIns and GO.. If i select the .dll which i ve created i get an error that " not a valid Office Add In." If i run it using the visual studio 2008 at my development machine, it works fine and i see the addin. I searched s...
I need to combine several tab-separated value (TSV) files into an Excel 2007 (XLSX) spreadsheet, preferably using Python. There is not much cleverness needed in combining them - just copying each TSV file onto a separate sheet in Excel will do. Of course, the data needs to be split into columns and rows same as Excel does when I manually...