Hi,

I have code which imports data from one sheet to another. I name them through the code by the following

HTML Code: 
Then

HTML Code: 
So I can call each wookbook when required using

DestWB
SrcWB

My question is, how on earth can I use these names in another subroutine. I've been looking for hours and can't get my head around it. I've tried passing it using the blow but it doesn't work. I'm really lost here so any help would be appreciated.

Sub NameOfNewSub(SrcWB as workbook, DestWB as workbook)

'code

end sub