I have a job to enter survey results (in paper form) to excel. I've never written any macro in Office :( Here I what I basically need: I have predefined columns (|A|B|...|AG|AH|) All surveys are grouped into groups. All surveys from same group have few (like predefined) same columns. It's always same columns that 'define' group All ot...
I've been having a major issue... well maybe not major, but I've been trying to figure this out since yesterday lunchtime. I have the following code: Application.CutCopyMode = False ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _ "Data!R7C1:R5000C40").CreatePivotTable TableDestination:= _ "'[Master-File.xls...
Every time I create a new excel sheet, I have to go in and change it's cell reference mode to the familiar A1, B1, etc. I can't seem to find a way to permanently set it to A1 style. Is there a macro I can write or a way to use templates or something, so that I don't have to keep changing the R1C1 setting? ...
What are some of the major differences to be aware of when developing Addins or Document level customizations for excel 2003/2007? ...
I'm working on a sheet that accesses a legacy data source via MS Query. I'm trying to alias some of the ridiculously ugly column names but the data source doesn't support wrapping alias names with quotes. Since excel is automatically wrapping aliases in quotes the query errors/fails. I seem to be stuck. How do I stop this default behav...
Hi, I need a solution to export a dataset to an excel file without any asp code (HttpResonpsne...) but i did not find a good example to do this... Best thanks in advance ...
How to pass Form TextBox reference to method? Following code is issuing exception. Private Sub DoSmthWithTextBox(ByRef txtBox as TextBox) txtBox.BackColor = vbRed End Sub Private Sub TextBox1_Change() DoSmthWithTextBox Me.TextBox1 End Sub Problem appears when'DoSmthWithTextBox Me.TextBox1' passes string from TextBox1 insead ...
I have a tabbed series of grids on a data preview page. I now need to import the data from each grid into its own sheet in an Excel workbook. How could I do this? BTW, this is on a Mac or a PC. ...
I am retrieving Japanese characters from a data source and I want to return this data to Excel in an XLOPER. I am using a Japanese version of Excel 2003 (hence XLOPERs and not XLOPER12s). wchar_t* pszW = OLE2W(bstrResult); //I have the data I am trying to copy in a CComBSTR ULONG ulSize = ::WideCharToMultiByte( CP_THREAD_ACP, 0, pszW,...
I have a 3rd party XLL addin I'd like to wrap in my own custom vba function. How would I call the 3rd party function from my code? Thanks ...
I have an excel spreadsheet that I want to import select columns into my database table. the wiz didn't offer that option. any easy code options? Thanks newbie ...
I'd like to automate data entry into Excel spreadsheets. User data will exist on a web site, and when the user requests it, that data will need to be injected into an Excel spreadsheet. The complication is that the format of the Excel spreadsheet can vary significantly between users - it'll be user defined. I've been thinking of this as...
I am trying to send some data from a LINQ query in C# to an Excel speed sheet using OLE I have a query like this: Var data = from d in db.{MyTable} where d.Name = "Test" select d; I have the Excel OLE object working fine, I just can't figure out how to populate the cells in Excel with the data from the LINQ quer...
I need to be able to export Trac tickets from a report or custom query to Excel, including the ticket description. The catch is that the description must be formatted as defined by the wiki syntax rather than displaying the raw text. ...
Hi. I want to set the font color of a cell to a specific RGB value. If I use ActiveCell.Color = RGB(255,255,0) I do get yellow, but if I use a more exotic RGB value like: ActiveCell.Color = RGB(178, 150, 109) I just get a grey color back. How come can't I just use any RGB value? And do you know any workarounds? Thanks. ...
Exporting from c#.net I am getting a problem I have a form that when I export to excel as a result in excel Any ideas why is this happening I am including the ASP code below. <%@ Page Language="C#" MasterPageFile="~/masterpages/Admin.master" AutoEventWireup="true" CodeFile="members-search-adv.aspx.cs" Inherits="masteradmin_members_sear...
Hi all, I'm trying to convert an HTML table to Excel in Javascript using new ActiveXObject("Excel.application"). Bascially I loop through table cells and insert the value to the corresponding cell in excel: //for each table cell oSheet.Cells(x,y).value = cell.innerText; The problem is that when the cell is in date format of 'dd-mm-yy...
The title pretty much says it all. I'm using VBA in the Excel VBE, but c# or vb are fine. The concept should hold true across the languages. Thanks. ...
Below was a macro provided, but I need to know how to do some adjustments to save it to the file name fixed to a specific worksheet, and specific cell with dates( eg. worksheet name is: AA on cell "B2" with ZZ ). So the filename will be ZZ AA 23122008.csv Thanks in advance. Public Sub SaveWorksheetsAsCsv() Dim WS As Excel.Worksheet D...
Hi How do you transfer a worksheet from one excel app(1) to another(2) if you have two excel apps open using VBA? The problem is, the programmer uses javascript, and when you click on the button that transfers the web data to a xl workbook, it opens a new Excel app. I know part of the code would be: Workbooks.Add ActiveSheet.Paste ...