Willow Talk

Re: Re: multiple workbooks in excel -

Posted By:

Email:

Date:

Time:

Comments:

Ted,

Thanks for the reply, the issue is that the workbook is open but not active, so I had to tell the timer in excel exactly where the macro resides . I should have sent some code which should have made my question clearer.

I did the following,


sub starttimer()

crunwhat = Thisworkbookname.name & "!modName" & ".the_sub"

runwhen = now +timeserial(0,0,crunintervals)

application.ontime earliesttime:=runwhen, procedure:=crunwhat, schedule:=true

end sub

----

Thanks for the help
Regards