Search:

Type: Posts; User: S M C

Search: Search took 0.00 seconds; generated 24 minute(s) ago.

  1. Replies
    12
    Views
    21,836

    danderson2692, great work with the charts mate....

    danderson2692, great work with the charts mate. Loved the initiative. And yes, thanks for sharing it here.
  2. Replies
    12
    Views
    21,836

    I have been getting PMs from members who were...

    I have been getting PMs from members who were interested in the World Map Chart. One of the recent queries I received seemed like one that is generic, and a lot of members may be interested to know....
  3. Excel 2007 OfficeMenu Addin For Recent Files and Folders Using DynamicMenu

    243

    Ever wished you could have all your recent Office files' MRU / Most Recently Used / Recent link from Word, PowerPoint and Access in the same place? Office 2010 has the recent folders list in...
  4. Replies
    3
    Views
    2,857

    Minimum Value Excluding Zero In Excel Range

    Here's a way to find the minimum value in a range of cells, after excluding zero



    Dim rng as range
    Set rng = Range("SomeRangeWhichAlsoHasZeroesInIt")
    dbl = Evaluate("MIN(IF(" &...
  5. Replies
    7
    Views
    7,347

    Sure. Here's a link which can give more info on...

    Sure. Here's a link which can give more info on DML and DDL (some of them are relevant for MS-Access, although the site is mostly for Oracle)

    What is DML and DDL
  6. Replies
    7
    Views
    7,347

    Rahul, 1. DROP is a DDL command and DELETE is...

    Rahul,

    1. DROP is a DDL command and DELETE is a DML command
    2. DROP is faster than DELETE

    Explanation: The delete command first stores the data that is going to be deleted. In a more advanced...
  7. Replies
    0
    Views
    1,666

    Unique Large Values From Duplicate List

    If your data is from A1 to A30, try this formula

    =IF(ROW($A$1:$A$30)=ROW(),LARGE($A$1:$A$30,1),LARGE($A$1:$A$30,ROWS($A$1:$A$30)-COUNTIF($A$1:$A$30,"<"&INDIRECT(ADDRESS(ROW()-1,COLUMN())))+1))

    ...
  8. Thread: Password Holder

    by S M C
    Replies
    3
    Views
    6,591

    Nice one

    Nice one
  9. Replies
    6
    Views
    37,839

    Well, I'll be Option Explicit Private...

    Well, I'll be


    Option Explicit

    Private Declare Function WNetGetConnection Lib "mpr.dll" Alias "WNetGetConnectionA" (ByVal lpszLocalName As String, ByVal lpszRemoteName As String, cbRemoteName...
  10. Replies
    8
    Views
    13,370

    For Excel 2007 connections strings, try...

    For Excel 2007 connections strings, try Connection strings for Excel 2007

    For other connection strings, visit http://www.connectionstrings.com/
  11. Replies
    12
    Views
    111,325

    Happy birthday ‎pjotrsk. Have a great new year.

    Happy birthday ‎pjotrsk. Have a great new year.
  12. Replies
    22
    Views
    6,766

    Just remove .Specialcells(2)

    Just remove
    .Specialcells(2)
  13. Replies
    22
    Views
    6,766

    Dim wksTarget As Worksheet Dim...

    Dim wksTarget As Worksheet
    Dim rngDate As Range
    Dim rngData As Range
    Dim c As Long
    Dim LastRow As Long
    Dim...
  14. Replies
    0
    Views
    1,738

    Allign Waterfall Chart Label

    All, was wondering if anybody could help with a macro that can allign the data labels of the waterfall charts in the attached file. You can add or remove more data from the table on the top left.
    In...
  15. Replies
    10
    Views
    4,422

    Ah, solution already suggested by Admin :) ...

    Ah, solution already suggested by Admin :)

    cheers
  16. Replies
    10
    Views
    4,422

    Could you attach a sample of the expected output?...

    Could you attach a sample of the expected output? How do you want the cells to be merged? Yes, weekends could be excluded, but you need to tell how you want the output to look like, given a sample of...
  17. Replies
    1
    Views
    1,912

    Count Alpha In AlphaNumeric Text

    To find the number of Alpha characters (A-Z) in a text, you could use the following formula, where A1 contains your text
    ...
  18. Replies
    12
    Views
    21,836

    know_ware, could you post a working sample here?

    know_ware, could you post a working sample here?
  19. Replies
    12
    Views
    21,836

    thanks a lot know_ware....glad it help.. Felt...

    thanks a lot know_ware....glad it help..

    Felt the same way about the charts in your site too..... interesting methodology....
  20. Replies
    12
    Views
    21,836

    Thanks for the interest Obed. Here's attached the...

    Thanks for the interest Obed. Here's attached the working version. I don't think anything beyond a bubble chart or a scatter chart would be used. So I have coded for the macro to work on both the...
  21. Replies
    1
    Views
    4,953

    How To Create An Add-In

    Here's a simple way to create your own add-in. Basically, an add-in has two broad steps.

    So the first step to create an add-in would be to create your sub-procedure or routine that you want to run...
  22. Replies
    12
    Views
    21,836

    World Map Excel Chart

    Alright, I have been working on this assignment, and came up with a nice looking Chart representing all the countries of the globe. Pretty fascinating and intriguing at the same time. Thought this...
  23. Replies
    1
    Views
    11,141

    Convert Text In YYYYMMDD Format To Date Format

    If A1 contains text in YYYYMMDD format, use

    =DATEVALUE(TEXT(A1,"0000\/00\/00"))
Results 1 to 23 of 23