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
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
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
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
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
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
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
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
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?
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
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
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
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
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
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
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
Develop environment : OS - Windows 7 64bit CPU - i5 460M RAM - 8GB .NET framework - 4.0 Excel-Interop - Microsoft Excel 14.0 Object Library
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
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
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=";")