VBA running slow

Hi and thanks for looking at my thread.

I have the following VBA which works to a point, however it is running slow.

It creates a New subfolder within a Folder based on cell value in column C.

I would like it to start from "C3" Down. (not quite sure how to get it there)

then it creates a word document and places that inside the newly created folder, then creates a hyperlink to the folder.

I have pieced the vba together more through trial and error.


Trial.xls

Please Login or Register  to view this content.

The 2nd part of the code is written by Jerry Beaucaire

and works fine (as you would expect)

Please Login or Register  to view this content.

I look forward to any help or direction

Why create a new instance of Word each time you loop?

Try creating one instance outside the loop and use that in the rest of the code.

You don't need a separate instance of Word for each document.

Use one instance of Word to create all the documents.

That's not what I'm suggesting.

I'm suggesting you move this line of code outside the loop.

Please Login or Register  to view this content.

This line creates a new instance of Word every time the loop loops.

So if it loops 10 times then you'll end up with 10 instances of Word.

That's not a good idea and since it take up time to create each of the instances of Word it's probably one of the reasons the code is running slow.

By the way, why is this code in a worksheet change event?

Do you want it to run every time anything is changed on the worksheet?