Opening IE from Excel

Jun 26
2010

To open a web page in a seperate window, call this function with your URL – for example openbrowser(“http://www.e-ms.ie”)

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
2010

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

http://www.theofficesweep.co.uk/world-cup-spreadsheet.html

Date Difference in Excel

Jun 06
2010

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
2010

An MS guide to help you with the transition from 2003 to 2007
http://office.microsoft.com/en-us/access/HA102388991033.aspx

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