Print a closed worksheet according to workbook and sheet name

[HaroonSid]

hello everyone

i want to print out of closed workbook according to workbook name and sheet name,

for example -

there are many workbooks in path = Z:\42766\Jan 2 Dec 2014\1.11.2016\
and every workbook has lots of sheets.


now i have a open workbook, here i choose file name "Master" and sheet name : "Bc"

then i want print out of file name "master" and sheet name "Bc" from the path of Z:\42766\Jan 2 Dec 2014\1.11.2016\


thanx in advance

[JBeaucaire]

Something like this:

Please Login or Register  to view this content.

[HaroonSid]

thanx, JBeaucaire

but i have a little problem in this code,
i want a msg box for input workbook name and sheet name instead of A1.value and B1.value

thanx

[JBeaucaire]

Perhaps something like this, you can adapt from here:

Please Login or Register  to view this content.