Opening IE from Excel

Jun 26

To open a web page in a seperate window, call this function with your URL – for example openbrowser(“”)

Function OpenBrowser(tmpURL)
   Dim Browser As Object
    Set Browser = CreateObject("InternetExplorer.Application")
    Browser.Navigate (tmpURL)
    Browser.StatusBar = False
    Browser.Toolbar = False
    Browser.Visible = True
    Browser.Resizable = False
    Browser.AddressBar = False
End Sub

World Cup Excel Template

Jun 09

This is a link to a good Excel template – you have to suffer the advertising on the right

Date Difference in Excel

Jun 06

I have used datediff in access and vba but didnt not know that excel had the function DateDif which is very useful function in pay budgeting models.

See the link here for details

2003 to 2007 Commandbars

Jun 01

An MS guide to help you with the transition from 2003 to 2007

If you need some help on a project drop leave a comment on the post and I will reply.