VBA Macro Closing Doc

[dandavis1]

Hi guys,

I have a large macro where it looks into 50 documents and pulls out a value from a specific cell.

I dont have any problem with the coding for this but was wondering if it is possible to add another line of coding so that once it has copied the cell value the documents then close. Currently when I run the macro, it leaves all 50 documents open once it has taken all the cell values and pasted them into my "Master Document".

Any help on this will be great, Thanks!!!!

[broro183]

hi,

I don't know how you are opening the 50 files but hopefully one of the below techniques will help you close them...

Please Login or Register  to view this content.

hth
Rob

[dandavis1]

broro183,

Thanks very much, this is now working!!!!

[broro183]

Thanks for the feedback - I'm pleased I could help :-)

Rob