Home > Software engineering >  VB fuzzy delete sheet
VB fuzzy delete sheet

Time:11-15

The code can be normal function
Outer loop execution next will wait for a long time still will be prompted to ole process takes
Click ok button after I will continue to the next times deleted
Question is why have to wait for a long time and I obviously did not use ole!

CodePudding user response:

Cell (1, 1) is a path (1, 2) is the file name
(1, 3) is retained sheet name is cycle times (1, 4)

CodePudding user response:

reference 1st floor qq_45756065 response:
cell (1, 1) is a path (1, 2) is the file name
(1, 3) is reserved sheet (1, 4) is the circulation of the number of page name

Has been resolved
Should have nothing book in nothing app

CodePudding user response:

Xlapp can put in circulation outside, each cycle and it is not necessary to create/close once;
This can improve efficiency;
  • Related