Daniel2001
02-05-2008, 01:05 AM
I have one "Master" Excel file which opens/activates other 4 excel files at specific time.(using ontime). The other 4 files are wriiten to acutally get date inside them updated when they are open (by workbook_open() ). When I run the 4 files seperately,they are fine. But using this master file, ONLY one file out of 4 can be updated! only one specific file..idon't know why?? and the other 3 files are open and activated(i can see screen updating),but they don't actually get updated!!how come?
the code in Master file is like:
dim wrkbook1 as workbook
dim wrkbook2 as workbook
dim wrkbook3 as workbook
dim wrkbook4 as workbook
set wrkbook1 = workbooks.open( path of file 1)
wrkbook1.activate
set wrkbook2 = workbooks.open( path of file 1)
wrkbook1.activate
set wrkbook3 = workbooks.open( path of file 1)
wrkbook1.activate
set wrkboo4 = workbooks.open( path of file 1)
wrkbook1.activate
end sub
Thanks for any help!!!!!!!
the code in Master file is like:
dim wrkbook1 as workbook
dim wrkbook2 as workbook
dim wrkbook3 as workbook
dim wrkbook4 as workbook
set wrkbook1 = workbooks.open( path of file 1)
wrkbook1.activate
set wrkbook2 = workbooks.open( path of file 1)
wrkbook1.activate
set wrkbook3 = workbooks.open( path of file 1)
wrkbook1.activate
set wrkboo4 = workbooks.open( path of file 1)
wrkbook1.activate
end sub
Thanks for any help!!!!!!!