danderson2692, great work with the charts mate. Loved the initiative. And yes, thanks for sharing it here.
Type: Posts; User: S M C
danderson2692, great work with the charts mate. Loved the initiative. And yes, thanks for sharing it here.
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....
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...
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(" &...
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
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...
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))
...
Nice one
Well, I'll be
Option Explicit
Private Declare Function WNetGetConnection Lib "mpr.dll" Alias "WNetGetConnectionA" (ByVal lpszLocalName As String, ByVal lpszRemoteName As String, cbRemoteName...
For Excel 2007 connections strings, try Connection strings for Excel 2007
For other connection strings, visit http://www.connectionstrings.com/
Happy birthday pjotrsk. Have a great new year.
Just remove
.Specialcells(2)
Dim wksTarget As Worksheet
Dim rngDate As Range
Dim rngData As Range
Dim c As Long
Dim LastRow As Long
Dim...
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...
Ah, solution already suggested by Admin :)
cheers
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...
To find the number of Alpha characters (A-Z) in a text, you could use the following formula, where A1 contains your text
...
know_ware, could you post a working sample here?
thanks a lot know_ware....glad it help..
Felt the same way about the charts in your site too..... interesting methodology....
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...
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...
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...
If A1 contains text in YYYYMMDD format, use
=DATEVALUE(TEXT(A1,"0000\/00\/00"))