VBA Code in Project to Wake Up/Open Excel

		Microsoft Office Forums > Microsoft Excel > Excel Programming
VBA Code in Project to Wake Up/Open Excel

FAQ

Thread Tools

Display Modes

05-23-2011, 11:15 AM

Colin Legg Colin Legg is offline

Windows 7 32bit VBA Code in Project to Wake Up/Open Excel

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Microsoft Project 2010 taking up to 10mins to open file from network share.	BITS	Project	1	06-01-2011 09:37 AM
VB code from one document runs on other open documents	beav_35	Word VBA	0	11-10-2010 02:52 PM
Any tutorial same as to this excel sheet with code?	Learner7	Excel	1	05-18-2010 05:31 PM
VB Code in Excel Active worksheet	shakilhyd	Excel	2	05-17-2010 07:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:33 PM.