excel .net

  1. P

    How to Create installer for the excel add in and UDF created in c#?

    Hi Everyone,I have created the excel project with Ribbon & UDF in c#. It works perfect when I build the solution or debug from VS 2010. Now I need to create a installer for this project. I have created a installer using setup wizard in VS 2010. When I open Excel, the ribbon loaded successfully...
  2. S

    VB.NET Print Excel Sheet to Specific IP / Network Printer Name

    Hi All I have been looking for a long time for a solution for what I thought would be a simple issue..... In my program I am opening an Excel template via Interop populating the required information and then trying to send the file to print to a specific printer. After being unable to find a...
  3. S

    Macro to generate a c++ header file using excel

    Hi all, I am new to this foruma nd it looks great for me :) I am thinking to make a excel file which can generate a headre file for my c++ source file. Previoulsy we used to generate .h files using excel but i dont know the logic behind that(Hope some macros using for that). MY header file...
  4. T

    Excel Multiple Instances - (1) VB.NET API Excel Interface app (2) Excel VBA coded program app

    Hello All, My First Post but trust a freaking long time user. :) OK so this is a new one for me and I always seem to get the fun stuff. I have a simple Excel VBA Workbook program that has worked fine up till now just using its internal calculations. However, recently a rigorous program...
  5. J

    Lookup a value from a range of dates in excel

    I have two tables. A list of accounts and the other is a change log. I need to add a new column in table 1 where the value is the amount in table 2 for the correct account and correct validity period. Please help
  6. H

    Excel : SeriesCollection : Purpose and usage

    Hi there, how do you work with Excel.SeriesCollection ? What is the purpose of it ? Why there is only an Add() method, and no Delete() method ? Thanks in advance,
  7. S

    Get reference to Excel applications using .net and C#

    Hi, I have been trying to get a reference to Excel applications using oExcelApp = (Excel.Application)System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application"); in C#. This is so that I can use code to automatically save any open workbooks & close the first Excel application...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...