April 2006
M T W T F S S
« Mar   May »
 12
3456789
10111213141516
17181920212223
24252627282930

Archives

Archive for April, 2006

Map Point from Excel

( General )

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). [...]

Printing PDF files with VBA

( General )

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? [...]

Pausing Excel

( General )

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 and Windows Dialogs

( General )

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 [...]

Custom File Extensions

( General )

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 [...]

UK Excel User Conference

( General )

Dates, locations and prices for this years EUC!
Looks good.