• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. dan_l

    Parsing Numeric Ranges....

    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...
  2. dan_l

    Code Optimization - How would you do this?

    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...
  3. dan_l

    Code Organization Advice

    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...
  4. dan_l

    Where class property is an array, looping through values

    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...
  5. dan_l

    Storing a String to be interpreted by VBA

    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...
  6. dan_l

    time stamps...

    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...
  7. dan_l

    Conditional Formatting: highlight row based on cell value

    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
  8. dan_l

    Persistent variable in a userform...

    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...
  9. dan_l

    vsto

    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?
  10. dan_l

    outlook vba?

    I'm trying to ninja something together in outlook. Does anybody know of a good outlook vba resource?
  11. dan_l

    assigning range values to an array

    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...
  12. dan_l

    vba: hide chart

    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...
  13. dan_l

    Returning month number from calendar week....

    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...
  14. dan_l

    ....another silly udf question....

    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...
  15. dan_l

    udf to extract numeric value [SOLVED]

    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...
  16. dan_l

    Excel Spreadsheet Art

    http://www.spoon-tamago.com/2013/05/28/tatsuo-horiuchi-excel-spreadsheet-artist/
  17. dan_l

    wow

    http://gizmodo.com/5992533/awesome-accountant-made-an-rpg-inside-microsoft-excel
  18. dan_l

    Powerpivot in Excel 2013

    http://www.powerpivotpro.com/2013/02/hey-who-moved-my-powerpivot-2013-cheese/ The snark in the comments is delicious.
  19. dan_l

    Enabling Powerpivot in Excel 2013...

    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.....
  20. dan_l

    Passing a named range to a formula with indirect....

    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...
  21. dan_l

    application.ontime

    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")...
  22. dan_l

    help this dude fix his spreadsheet

    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...
  23. dan_l

    TED video on data visualization

    http://www.ted.com/talks/jer_thorp_make_data_more_human.html
  24. dan_l

    Cool charting article

    http://queue.acm.org/detail.cfm?id=2146416 It's going to load slow because it's front page on slashdot.
  25. dan_l

    countif for distinct values....

    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...
Top