Open two workbooks simultaneously

HFB · #1 (**permalink**) 01-09-05, 21:56

How do I use VB to make a file (with a whole bunch of macros in it) open at the same time as opening another file?

DavidCoutts · #2 (**permalink**) 01-10-05, 03:53

you dont you have to open them sequentialy

i.e.

Code:

Sub test()
    Dim wkb1 As Workbook
    Dim wkb2 As Workbook
    
    Set wkb1 = Workbooks.Open("c:\myfile1.xls")
    Set wkb2 = Workbooks.Open("c:\myfile2.xls")
    
    
End Sub

HTH
Dave

tigrillomx · #3 (**permalink**) 02-03-05, 18:24

May be this could help you....

Sub SchedullingAJob()
Application.OnTime TimeValue("17:00:00"), "Procedure1"
Application.OnTime TimeValue("17:00:00"), "Procedure2"
End Sub
Sub Procedure2()
Dim wkb1 As Workbook
Set wkb1 = Workbooks.Open("c:\myfile1.xls")
End Sub

Sub Procedure1()
Dim wkb2 As Workbook
Set wkb2 = Workbooks.Open("c:\myfile2.xls")
End Sub

Internet Services

Web Development

Digital Marketing

Consumer Tech