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=";")
How to stop OutLook Security Message : A program is trying to access e-mail addresses, Allow access for 1 Minutes I want to stop this a
I am trying to get a cell drop-down values in Excel from a SQL Server. I don't want to use the method of putting all the data to another sheet and the use data
we are developing an Excel 2016 Workbook using VBA. I descrivbe the error from my side, but it occurs at several independent Computers - even at the customer's
It seems pretty easy, but not able to find workaround. Excel 2010. Aim: adding 22 empty columns starting from B Error: Run-time error '1004': Insert method o
I pull the Subject, received date and sender's name with the following code: Set InboxSelect = GetObject("", "Outlook.Application").GetNamespace("MAPI").PickFo
I had similar question (link below), but it just lets say "add-on" to my issue that I found on the way. Find all code combinations using text string in Power Qu