Category "excel"

Sum in a index/match formula

Could you help me solve the following? I want to return the total sum, not the first match that it finds. My first preference is have indexing and matching wi

Using OLEDB for uploading file with Excel 2016

my application basically accepts an excel file and uploads data to my database which used to work perfect with Excel 2010 with the below code. However we update

vba vlookup does not work in loop

I am working on a tool to analyse data. The data to be analyzed is manually copied into the first sheet, then I am planning to run a macro which analyzes the da

Using COM4J to create excel file

I am receiving a null pointer exception when trying to launch an instance of excel to export data to. I have tried adding the newest version of COM4J.jar to my

Spire When Pdf-ing an excel file it leaves some formulas as System.Object[][]

I have an excel template that has preset formulas, then have my wpf application fills in data in other sheets then the preset formulas takes the data from the o

Move worksheet within a workbook to the end [duplicate]

With xlwings, I am trying to move a worksheet within a workbook to the end. For example, a workbook contains a collection of the following she

Run macro automatically when cell value changed (not changed by user)

Is there a way to have a macro changed when the value is changed is changed, not necessarily when a user changes the value? For example, I have a check box th

Prompt user to select multiple files and perform the same action on all files

The user has hundreds of text files and requires making a change in the data before saving and closing them. Below is the code I have for a single file; how can

Excel - How to convert UTC date time

I would like to use this string as a date time in excel 2016-04-06T18:05:32.6550717+03:00 How can it be converted?

Excel XIRR Function returning invalid calculation

When running the XIRR function "=XIRR(G163:G168,F163:F168)" where the cashflow is in G163:G168 and my dates are in F163:F168, excel is returning a value of .000

Export data from R to Excel

I am writing codes to export database from R into Excel, I have been trying others codes including: write.table(ALBERTA1, "D:/ALBERTA1.txt", sep="\t") write.cs

Is it possible to step through a row of data and sum every n-th cell using a Lambda function?

I have a model that produces an array of values that can be several hundred columns wide. Every 25th column contains a number that I need to add to the total. I

Userform - Redirect focus on textbox after MsgBox

I hope this is not that stupid, but I really did not find a post that was working for me. Situation: I want someone to put a date into a textbox in a Userform.E

BSTR's and VARIANT's under... mac os x

Under mac os x I have office 2011 and its excel and VBA, and I have gcc-5.3.0's g++. I played a lot to passing arrays (of numerical built-in types) from VBA to

How to run a SQL query on an Excel table?

I'm trying to create a sub-table from another table of all the last name fields sorted A-Z which have a phone number field that isn't null. I could do this pret

excel/vba: count number of unique male and female students in list

I have a database of students with names and their gender, however the list contains repeats of students on different dates. How do I count the number of uniqu

OutOfMemoryException while saving/creating/exporting excel sheet

Develop environment : OS - Windows 7 64bit CPU - i5 460M RAM - 8GB .NET framework - 4.0 Excel-Interop - Microsoft Excel 14.0 Object Library

Invalid procedure call or argument applying Excel conditional formatting from Access vba

I have read numerous examples where this code works; however, when I try to execute it, it isn't working and I don't see why. Dim xl As Object Set xl = CreateO

Invalid procedure call or argument applying Excel conditional formatting from Access vba

I have read numerous examples where this code works; however, when I try to execute it, it isn't working and I don't see why. Dim xl As Object Set xl = CreateO

Excel Cell Coloring using xlsx

Initial code: Lets assume we're using this command to create the dummy data: Data <- data.frame( X = paste(c(sample(1:10),sample(1:10)), collapse=";")