View Single Post
 
Old 05-23-2011, 11:15 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hi,

Here's a starting point:
Code:
Sub foo()
    Dim xlApp As Object
    Dim xlWkb As Object
        
    Set xlApp = CreateObject("Excel.Application")
    Set xlWkb = xlApp.Workbooks.Open("C:\YourfilePathandName.xls")
    
    xlApp.Visible = True
    
    Set xlWkb = Nothing
    Set xlApp = Nothing
    
End Sub
__________________
Colin

RAD Excel Blog
Reply With Quote