subalterne sub in parallel

  • Thread starter Thread starter pls123
  • Start date Start date
P

pls123

hello all..!!
at 19.43 my main sub launch a
close A sub that closes all the pages that begin with letter A.

the problem is that these pages are many, and the closing process takes
20-30 seconds... and the subalterne sub must be ended before the main sub can
prosecute... jumping many calculations cycles

is there a way to indicate to excel that the subalterne sub must be executed
in parallel ??? ty all
 
hello all..!!
at 19.43  my main sub launch a
close A   sub that closes all the pages that begin with letter A.

the problem is that these pages are many, and the closing process takes
20-30 seconds... and the subalterne sub must be ended before the main subcan
prosecute... jumping many  calculations cycles

is there a way to indicate to excel that the subalterne sub must be executed
in parallel   ???  ty all
Click to expand...

pls123,

In terms of "speed" you may want to consider setting ScreenUpdating to
FALSE and Calculation to xlCalculationManual (reset if necessary at
the end of the procedure). You can also set DisplayAlerts to FALSE to
avoid from having the sheet deletion dialog box from prompting the
user (reset after each sheet deletion). I'm not sure that I follow
your order of events, i.e. delete a sheet, run the second procedure,
go to the next sheet, delete the sheet, run the seond procedure, etc.

Best,

Matthew Herbert
 
hi matthew !! tx for your help..
screen updating =false and calculation is manual .

tthere is a for next...

for each page begginning with A,
save and close...

all this operation takes many seconds...
while the other pages are not calculated in real time as needed...

so the problem is that the sub should be executed "in parallel" with the
main sub..........
 
hi matthew !! tx for your help..
screen updating =false and calculation is manual .

tthere is a for    next...

for each page begginning with A,
save and close...

all this operation takes many seconds...
while the other pages are not calculated in real time as needed...

so the problem is that thesubshould be executed "inparallel" with the
mainsub..........





- Show quoted text -
Click to expand...

Pls123,

As far as I know, there is no way of executing two or more procedures
simultaneously. (I have never tried this, but I guess you could open
two instances of Excel and try executing one macro in the first
instance and the other macro in the second instance. Again, I have no
idea whether this may work).

Also, you can try changing your worksheet deletion For...Next to a For
Each...Next. This should give you some more speed, but if you are
doing a Save and Close after each page deletion then yes, the process
will be somewhat slow.

Best,

Matt
 
yes i will try putting the sub in a new page...that is opened.. at a desired
time.. and
its runned on opening..

that may be the right idea.. tx !!
 
Back
Top