[excel] Forum Topics

Hi, I need to write a program to send data from a particular excel sheet in a workbook to a notepad. Say,I've an xl sheet with the following columns: "Name,Age,Salary" with values "john,24,1000" respectievely,Now I need a C# program to read the xl sheet and write the values onto the …

Hello All, I am in a roadblock right now and I really need some help on the code below. What I wanted to do is close all opened workbooks. This code does the work IF there is at least one or more opened workbooks. My problem is IF there is …

I have an Excel workbook containing named variables across several worksheets. In one of these worksheets I have a "run solver" button, which kicks off a VBA routine. The first thing this routine does is allocate values of variables picked up from the workbook to local variables inside the VBA …

Hi guys, i would like to ask that is there anyway to embedded an excel file into a vb.net project? i know the way to read an excel file from vb.net, but i would wanna know is there anyway i can include the excel file inside the vb.net program. This …

I want to assign a color to my excel column [CODE] currentRow.Interior.ColorIndex = 17; [/CODE] But I don't want to use one of the colors in the excel palette I do I add my own color. for instances: [CODE] currentRow.Interior.Color = Color.LightBlue; [/CODE] Thanks for the help

Hello, I'm trying to deploy an application. On my development machine, I have Office 2007, and using it to automate excel from c#. On the target machine, there's Office 2003, and I getting an error message when trying to installm that I should isntall Microsoft.Vbe.Interop version 12.0.0.0. I removed all …

Hi I'm currently stuck in an infinite loop because of the code I've written and i can't stop the code, close excel etc. Basically the code runs after a cell change, displays a msgbox and then causes itself to run again, and while this is happening i can't do anything …

Hi, i am new to python world my problem is that i am getting a output file from a software which is very messy first i just want to delete first 3 rows and the columns F onwards from the excel file and that i just want to change the …

The select case construct is moving to the Case Else line every time the programme loops, even though there are "Longvue" & "Roseleigh" entries in the worksheet.[code]Option Explicit Option Compare Text Sub Complete() Dim HOComplete As Range Dim Client As String Dim JobNumber As Range Dim workrange1 As Range Dim …

Hey guys, im new here and i was wondering if some people could help me out? ive recently been employed in an IT company, and although i am quite familiar with c++, i have been asked to work on making a custom Ribbon in Excel (creating a new tab for …

How do I Load an excel file to the PrintPreviewDialog? [CODE=vb] Imports Excel = Microsoft.Office.Interop.Excel Private Sub btnPrintPreview_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPrintPreview.Click Dim xlApp As Excel.Application Dim xlWorkBook As Excel.Workbook xlApp = New Excel.ApplicationClass xlWorkBook = xlApp.Workbooks.Open(Application.StartupPath & "report_summary.xlsx") MyPrintPreviewDialog.Document = xlWorkBook If MyPrintPreviewDialog.ShowDialog() = …

Hi , I'm getting the below error when i'm trying to create a excel boject in my ASP page. Please help me. Error Type: Server object, ASP 0178 (0x80070005) The call to Server.CreateObject failed while checking permissions. Access is denied to this object.

I have an Add-In for Excel 2007 (can't post the code here unfortunately) and in some instances, when the user makes a certain change within the Add-In then closes Excel 2007, they are prompted to enter the password for the VB code within the Add-In. The password prompt dialog can …

Hi Im composing a paid search campaign report and never done one before. What would you recommend me to do it on? Powerpoint or Excel? or even Word? Please advice. Thanks!

Hi guys, I am writing (trying to write) a program in VBA for Excel 2003 and I got stuck, I need your help, please. I have an excel range where the upmost cell is initially fixed and the downmost cell moves down as more data arrive. In other words I …

We all know most business users use Excel to track sales and metrics. Thus, which tricks on Excel do you use that you strongly recommend for others to use? Please do share.

Hi everybody I have've been asked to do something but I can get only to a point and I am now stuck. Please help. I have written a Sub in VBA for Excel 2003 (see below) in which the top cell of a range (WorkRange) is initially set at Cells(1,2), …

so I have a script that is taking input from a text file and using it to populate an excel spreadsheet. it keeps giving me a UnicodeDecodeError, dying on the ± symbol, I'm assuming its not in the codec that is being used: im using the xlwt package for writign …

Though PPC reports can be obtained in document format, you can also receive in csv format for data extrapolation. So if you do data analysis on your PPC results, which Excel plug-ins or data visualization tool do you use to make sense of this data?

Question1 : how to use c++ to read/write excel file without changing it into CSV file? Question2 : How to use CSV parser in c++? Are there any examples?

Hi Guys, i created an C# application, i need to read an excel spreadsheet called "Graduates.xlsx", i have to search for a specific row on a column called "ID number", once i get that column i must retrieve a record of that row on column "First name". Its been weeks …

Microsoft is betting that people would rather fork over $US20 a year for the legal right to use its Office application suite than install an old or pirated copy or use one of a growing number of free alternatives. Having been faced with that exact decision myself this week, I …

three lines of code to check MS Excel is installed on PC

I've created an Excel spreadsheet that I use to incorporate data into a Microsoft word document. (Word/Excel 2003) When I do the mail merge and bring in the data, Excel takes a few of the data cells and adds zeroes after the decimal. I've attached a .jpg image of the …