629 Topics
 | |
| | Hi, i need to export a listbox data to an xls file, how i can do this? thanks |
| | greetings, on my xp / ofc 2007 system, i have copied several documents in to a single doc. on the far right hand side / past the right hand margin, there appears a great deal of white space... to what appears to be a page width of ~10". i have … |
| | Okay, I know this is really really simple, but for the life of me, my brother and I cannot get this to work properly. [LIST] [*]We have a number in Cell D4(and down). [*]In E5 is the binary conversion of D4. [*][*]In F2-N2 we want to have the individual numbers … |
 | I had a problem at work which I solved, but that raised me another question. I wanted to export a page to excel, so I used this: [CODE] response.setContentType("application/vnd.ms-excel;charset=iso-8859-7"); [/CODE] It worked but while I was searching for an answer I found 3 possible content types for the excel: > … |
| | Hello All, I need some help to convert the macro I recorded in Excel into a working Vb.Net application. It involves attaching a file into a Excel cell. The file is a Word document named "File.doc". Here's the recorded macro: Sub DemoAttachFile() Workbooks("Book1").Activate Sheets("Sheet1").Select Range("B2").Select ActiveSheet.OLEObjects.Add(Filename:= _ "C:\Documents and Settings\File.doc", … |
| | 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 … |
 | Office 2010 awaits us later this year, and I've been wondering what it could possibly offer customers that would compel us to buy or upgrade to this software. Office software in general progressed about as far as most of us needed it to go somewhere in the 90s. Since then … |
| | 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 |
| | Yesterday, the [URL="http://www.businessweek.com/technology/content/dec2009/tc20091222_416170.htm"]Federal Appeals Court ruled[/URL] in what appears at first blush to be a shocking decision, that Microsoft must stop selling Word 2007 by January 11, 2010. But a closer look at the decision suggests that this isn't as big a deal as it first seems. Sure, Microsoft has … |
| | 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 … |
| | Oh dear, now I do not believe that was meant to happen. It appears that users of Office 2003 who also protect their documents with the Microsoft Rights Management Service (RMS) have found them so well protected that nobody can open them - not even the person who created the … |
| | 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 … |
| | Hi all I'm in a situation where i have 6-8 PC's presently used for sending & receiving emails & internet works, for this we me and my colleges are using individual dial up data card, now we want to switch to a Broad band Leased line ( ILP or Dedicated … |
| | 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 … |
 | The Los Angeles City Council voted unanimously earlier this week to outsource its e-mail system to Google Inc., according to an [URL="http://latimesblogs.latimes.com/technology/2009/10/city-council-votes-to-adopt-google-email-system-for-30000-city-employees.html"]article[/URL] in the Los Angeles [I]Times[/I]. The contract is worth $7.25 million and covers 30,000 employees. In June, Washington, D.C. made a similar decision, signing a contract worth almost …  |
| | 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? |
The End.