| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Mar | May » | |||||
| 1 | 2 | |||||
| 3 | 4 | 5 | 6 | 7 | 8 | 9 |
| 10 | 11 | 12 | 13 | 14 | 15 | 16 |
| 17 | 18 | 19 | 20 | 21 | 22 | 23 |
| 24 | 25 | 26 | 27 | 28 | 29 | 30 |
Today I have been I'r'een mostly messing about with Map Point.
The following code (called with the GetDistance sub) will return the distance between 2 post codes. To use this code as is, you'll need to select 2 adjacent cells (i.e. A1 and B1), the distance will be put in the 3rd column along (i.e C1). [...]
PDF Creator is a super little tool which lets you print out any documents to a .pdf file. Once it's installed all you have to do is select it from the print dialog and it will make you that PDF.
But what if you want to get hold of this functionally in your own code? [...]
From time to time i like to make Excel pause. A typical example is when a process has finished and I'm about to hide a userform. I may need/want to give some info to the user, for which i need to display the form for a little longer. a simple one line can do the [...]
Excel allows us to get hold of many builtin dialogs via it's object model. For example:
Sub OpenDialog()
Application.Dialogs(xlDialogOpen).Show
End Sub
Shows the open file dialog. More infomation can be found here:
http://support.microsoft.com/?kbid=213371#E6ACAAA
A lot of the time, what Excel is doing is using API layers to get hold of these diologs (i.e. the common dialogs), it then allows [...]
Sometime it can be useful to save files with custom file extensions, such as "MyWork.mie". This allows us to filter these files out when we used the OpenFile dialog for example. It also means that we can associate that file extension with a front loader, if we are using one.
It’s very simple to save out [...]
Dates, locations and prices for this years EUC!
Looks good.