I have a small .NET app that I'm running under Windows 2008 Server via the Task Scheduler. This application needs to open an excel file and then save it as csv. The task fails when I try to open the workbook. If I run it manually without the task scheduler running it, the app works fine. I have it set to "Run with highest privileges" a...
Hello, can anybody tell me, why the "...->{FormulaR1C1} = '=SUMME( "R[-3]C:R[-1]C" )';" doesn't work. In the Cell where should appear the result I get "#Wert!" ( maybe "Value" in English ). With the WENN(IF)-formula I get what I expect. #!C:\Perl\bin\perl.exe use warnings; use strict; use Win32::OLE qw; use Win32::OLE::Const 'Micro...
I need to count unique values in range (C2:C2080) in excel. Googled formula: =SUM(IF(FREQUENCY(MATCH(C2:C2080;C2:C2080;0);MATCH(C2:C280;C2:C2080;0))>0;1)) return incorrect value. UPD: Lame solution: Sub CountUnique() Dim i, count, j As Integer count = 1 For i = 1 To 470 flag = False If count > 1 Then For j = 1 To ...
Hello I ve been asked to look at what can be used for running a macro from within excel I ve seen snippets of code on various forums but is there any library (open source preferably) that will help me with this in a robust manner?? Apache / Sourceforge dont have much !! ...
I use DataGridView control to manage a simple dictionary (several columns and a few hundred rows). DataGridView functionality is almost sufficient. I can add new rows, modify values and copy data from it to Excel. One thing I cannot do is to copy data from Excel to my control. Is it possible with some properties? Or is some code required...
So I have this global mapping scheme, and each country on it are individual shapes. I learned how to manipulate colors/fill based on certain criteria. So the way I do this, or the way I know how is one shape/object at a time. For example USA is "C_USA", Canada is "C_CAN", etc. So is there a way I can define countries into groups?? ie. ...
I'm trying to make it possible for the user to download an Excel spreadsheet from our site, by having a button that redirect through this: Response.Redirect(string.Format("../excel/ExcelForm.aspx?pathName=&fileNameDisplay={0}&fileNameUnique={1}", "spreadsheet.xls", fileName)); The aspx page just sends back the file through the Respons...
I make a index of a list of sheets in a workbook, i will like to print some of then (list in column A, a mark in column B the ones i would like to print) Do you have some code for it, in VBA Excel??? I Will really thanks ...
The following VBA subroutine will run most queries just fine. (ie: SELECT * FROM DUAL) Sub DisplayQuery(QueryString As String) Dim rs As New ADODB.Recordset Dim connStr As String connStr = _ "Provider=MSDAORA.1;" _ & "User ID=abc;Password=123;" _ & "Data Source=xxx/xxx;" out QueryString rs.Open QueryString, connStr, ...
Hi guys, I'm trying to run the excel solver in Coldfusion. However i'm running into issues like, the page hangs as if loading forever, similar to this. Is it possible to run excel solver thru Coldfusion? If not, are there other alternatives for Coldfusion? Thanks in advance. ...
I'm trying to write an import function for getting data out of an excel file. How I currently do it is as follows: Private Sub ReadExcel(ByVal childform As PhoneDiag.frmData, ByVal FileName As String) Dim xlApp As Excel.Application Dim xlWorkBook As Excel.Workbook Dim xlWorkSheet As Excel.Worksheet xlA...
Hi, I have a problem for reading data from Excel sheet using connection string. I am getting data. But problem is blank rows also coming. I don't want to get blank row. Can any body help me. Thanks in Advance. Mehar ...
my requirement as follows: if a5 = 'a' then b5 = 1 if a5 = 'b' then b5 = 2 if a5 = 'c' then b5 = 3 if a5 = 'd' then b5 = 4 if a5 = 'e' then b5 = 5 else enter correct letter total no. of conditions are more than 5 as of now and then i need to put default msg for this like 'ENTER CORRECT LETTER ' ...
Excel problem: User clicks a button and VBA parses an input file, putting data into cells in the spreadsheet. Then she mails copies of the spreadsheet to people who do work with the data. I am to replace this with SSRS or ASP or Sharepoint displaying the data from SQL Server. In order to work on this without interrupting the current ...
This is for Excel: I've been tasked with counting distinct records after I have filtered the data. I have 330 rows with column A containing the 'name' and in Column B I have the name of a test that was done for each 'name', which each 'name' could have taken several iterations of the same test. The test results are in Column C. Col...
I´m trying to rename an Access Table using VBA from Excel... any help? ...
How can I 'read' an excel 2003 document stored as a sharepoint spfile? I can retrieve the document from the library with no problems using the SPFile.OpenBinary() and then putting that into a MemoryStream. The original idea was to use OpenXML to interrogate the document (which will take this object type as a constructor), but the Excel ...
Heres mine problem If cell H of worksheet A = cell E of worksheet B (contain words) and If cell J of worksheet A = Cell H of worksheet B (contain numbers) and If cell K of worksheet A = cell I of worksheet B (contain numbers) then copy cell O of worksheet A to cell L of worksheet B (contain numbers) (put in ot...
I am using DSOFile.OleDocumentPropertiesClass for getting the page count for office documents without automation. This works fine for docx and pptx files but returns always 0 for xlsx files. DSOFile.OleDocumentPropertiesClass oleDocument = new DSOFile.OleDocumentPropertiesClass(); oleDocument.Open(documentFilePath, true, DSOFile.dsoFile...
In my workbook, I copy the current sheet to keep as a record of a sale. Eventually, the workbook fills up with sales and at some point throws an error when I try to copy another sheet. After saving, then completely exiting Excel, then reloading the file, I can continue without problems. I'm guessing it's a memory issue, but I'm not qu...