Hi,
I'm struggling mightily to wrap my head around this one. I've got ideas, but every time I sit down to do it I end up going down a rabbit hole. I've got a bunch of numbers like:
1
2
3
9
14
15
16
19
I want to parse them as a FROM and a TO like:
From To
1 3
9 9
14...
So---I've got a coding problem. I've got a solution. I'm looking for a second opinion if this is the right way to handle it, or if there's a better way:
The set up:
-It's access. The code lives in a class.
-The overall process is:
1) Feed the class a bunch of parameters
2) A...
Hi,
This is all an Access based project, but this really more about the VBA side.
Here's what I've got:
-Class that manages a series of reports out of access.
-A Class that emails the files exported to a bunch of users.
General program flow:
A header procedure loops through a table...
Hi,
This one is vexing me.
Class property:
Public Property Get avInputs() As Variant()
m_avInputs = Me.InputRange.value
avInputs = m_avInputs
End Property
Inputrange.value is a valid assignment set in class initialize.
The precursors seem to be ok:
Sub test()
Dim OPR As New...
Hello Chandoo.org! Long time, no talk.
I bring a random question that I can't - for the life of me - figure out.
The set up. I have table like so:
Name, Message
FriendlyNameA, "This is a string of text"
FriendlyNameB, "this is another string of text"
I make an email call to insert...
I can't believe I'm having this trouble!
I've got a series of time stamps. They're just time. IE: 2:35:00 PM. There's a date in the output, but it's wrong. If I change the formatting it's like 1/1/2001 2:35:00 PM.
I need to do two things:
1) With a formula, change the date to the...
Hi,
I just realized something: I totally suck at conditional formatting.
I have a report with fields:
[Part] [Type] [Sales]
1 A 1000
2 B 2000
3 A 1000
I want to highlight the entire row when the type is equal to A. I know it's setting up a
Hi,
I'm working on a userform. It's actually there to configure some functionality. It's got some dynamic listboxes.
Anyway, so
step 1: uses a refedit to get a range. User selects a range, presses a button. The range is passed to a array. The headers of the selected range are put into...
I'm just curious here:
Does anybody have any experience building excel stuff in studio?
I don't have a specific question, I'm just curious if anybody has any good/bad experiences writing automation like that?
This is probably me being new to arrays:
Dim MyArray(1 To 1000, 2) As Long
Dim rSourceRange As Range
Dim rTargetRange As Range
Set rSourceRange = Range("B1:b1000")
Set rTargetRange = Range("g1:g1000")
MyArray = Range("b1:b1000")
So ideally I want to set a range, have the array store...
This may be simple. Here's the set up:
I've 4 dynamic charts in a 'dashboard' kind of layout. The sources for the charts change based on vba. Each chart has it's own "display" flag to deal with a bunch of conditions where I won't want ot display the chart.
So, no data to display, some...
One of my olap gadgets drops out date series calendar week. I need to return the month associated with that week using vba. It's actually part of a vba driven automation routine, so I could probably insert a formula wit hvba, I"m just having trouble cooking up the vba to do it.
40.2012...
So this UDF returns a date as a serial. Every time I run it over my data set, I just right click and format the cells as date, and go on with my pivot tables. That's fine, but I wonder if it's possible to return the value as a formatted date.
I tried format([serial],"MMDDYYYY"), but that...
So, I've got some really noisy, messy, bad data that I have to 'make useful'. I've been able to do most of it with a combination of a handful of UDF's, standard excel functions, and a CSV editor. One part still has me a little worried. So I've got cells that look like this:
Product...
Can somebody peek in excel 2013 and tell me what directory the power pivot and excel addin are supposed to be in? I'm told that they come 'out of the box' available, but I can't seem to locate them anywhere.
It might be because I used the lame web install to do this.....
I forget how I did this before.
I've got a couple of dynamic named ranges. They're interchangeable for a particular dynamic chart. Cell A2 contains text that matches a named range.
I want to =sum(indirect(a2)) but it keeps returning #ref. I looked up the last time I did something like...
I don't think I've had call to use this before, but I've got a little project:
Basically, I want an alert to pop every hour. I'm testing application on time, but the results are being a little fuzzy.
Here's the code:
Sub time()
Application.OnTime Now + TimeValue("00:01:00")...
http://deadspin.com/5902760/finance-guy-keeps-incredibly-detailed-incredibly-creepy-spreadsheet-of-his-matchcom-prospects
http://dealbreaker.com/2012/04/financial-services-employees-excel-spreadsheet-of-dating-prospects-allows-for-18-year-olds-has-no-room-for-jappy-girls/
I, for one, think...
Here's the problem:
I've got a list. There are two columns, one is states the other is transit routes. So:
[State] [Route]
Illinois A100
Indiana B50
Iowa A100
Illinois A100
Wisconsin A190
Illinois D35
What I need is to be able to specify a state and get the number of...