Quote Originally Posted by mdmackillop View Post
Paul's code above corrected to set variable
Set wb2 = Workbooks.Open (Filename:="X:\089872 - IPW - Framework\02 Admin\01 DocRegisters\" & sFilename)
@Mac -- Thanks - I was simplifying and goofed



@JKP - re. wb1 -- yes, you're 100% correct, but I figured it'd be clearer to emphasize the different WBs that way. wb1 is not really required, but my (very) personal preference when I have 2 or more WBs open is to be extremely specific, and esp NEVER rely on ActiveWorkbook or ActiveSheet