Passing Workbook between two subroutines

[mrsak87]

Hi,

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

Then

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.

Please Login or Register  to view this content.

[mjr veverka]

?

Please Login or Register  to view this content.

?