• 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. P0lar

    Pivot table calculation - % of different field subtotal

    I have been handed an excel sheet to fix which includes a pivot table: Location Time spent Time paid --Site A 1000 2000 ----Lunch 100 150 ----Break 200 150 ----Work 700 1700 --Site B ----etc. I...
  2. P0lar

    VB roundup to nearest integer isn't exact

    I have some times and need to know how many minutes there are to a 15 minute interval in vb. here's my code: stVal = (WorksheetFunction.RoundUp(CDate(tmFirst) * 96, 0)) - (CDate(tmFirst) * 96) where tmFirst is the time as a string, e.g. "07:00" the trouble is that although...
  3. P0lar

    Highlight line series selected on a simple chart

    I have a line chart with around 75 line series on it. They all follow a similar trend but each line is different. My first 3 lines are the average and standard deviation for that point on the x-axis. I have used worksheet.selectionchange and created a new series on the chart so that as I pick...
  4. P0lar

    Extract a file name from a full (variable) file path

    I have a list of xml command lines in excel (text fields) such as: -f /tv/ss/ex/dub/config/agedet_one2one_run.xml -s<s> -e<e> > /tv/ss/ex/dub/config/run_agedet.log 2>&1 -f /tv/ss/in/au/config/agedet_out_run.xml -s<s> -e<e> > /tv/ss/ex/dub/config/run_agedet.log 2>&1 -f...
  5. P0lar

    ODBC connector 64Bit Windows and Excel vba

    Hi, I had a lovely macro which extracted data from one of our systems via ODBC. I was then upgraded my laptop to 64 bit Windows but kept 32 bit Excel and the connections have broken. Our IT team refuse to back out the change as 64 bit is the future... I've set up a new ODBC driver in sysWOW32...
  6. P0lar

    VB array variable type for ascii string

    Hi, I have a formula which creates a string including a superscript 0,1,2 or 3 - represented by chr(185), 186, 179 and 178: ¹0800-1500¹ I would like to pass this into an array in VB but can only fill the array with the #N/A "error 2042" for some reason, I suspect this may be due to the...
  7. P0lar

    reducing rows in a .txt file when importing to excel

    I have a pipe delimited .txt file export from another system which is likely to run close to 1 million rows when in full use, so importing to excel is risky and likely to slow the calculations etc. Each line shows how long a person spent on an activity on a given day, and there are about a dozen...
  8. P0lar

    VB to reference open workbooks not appearing in the workbooks collection

    Hi, Hope someone can help, I have a program which can output daily reports to excel format, and I'm trying to automatically collate a weekly view from the 7 open files. I was hoping to use: For Each wb in Workbooks ...do the collating stuff... Next wb But the excel workbooks opened by the...
  9. P0lar

    Shorten some text strings from a list

    Hi, I have a list of about 6000 records which are a mixture of text and numbers. the string is either: Numbers, text, numbers, text or: Text, numbers, text or: Text, numbers. I need to write a formula (or UDF) to remove the last (right hand side) text from all the records which have it. Any...
  10. P0lar

    Hyperlink mouseover formula help!

    Hi, I've used the hyperlink formula trick from the (very nice) dashboards examples elsewhere on the site to run a user defined function when I put the mouse pointer over a cell =IFERROR(HYPERLINK(MyMouseOverEvent(),""),"Text"). I also have a macro which runs when I select the cell with the...
Back
Top