Object required when closing a workbook

[jomili]

My code is erroring on the "Wkb.Close False" line with an "Object Required" error, and I can't figure out why. This is my attempt to condense a lot of previous code, so I'm sure I've done soemthing wrong, but it's not jumping out at me. I'd sure appreciate some wisdom on this one.

Please Login or Register  to view this content.

---------- Post added at 11:48 AM ---------- Previous post was at 11:03 AM ----------

Well, I figured it out. Instead of

Please Login or Register  to view this content.

I put

Please Login or Register  to view this content.

. That did the trick!

[tigeravatar]

jomili,

The issue is that the variable Wkb is used to loop through the array of filenames. That makes it a string type variable and not a workbook object. To close the workbook, you'll need to use:

Please Login or Register  to view this content.

---------- Post added at 10:50 AM ---------- Previous post was at 10:50 AM ----------

Looks like I posted a hair too late! Glad you got a working solution

[jomili]

Better late than never. Thanks for helping.