Hi,

This may seem as a repetitive post but instead of macro progg or even VBA progg I am using VB6 to print worksheets present in a workbook as a single file. Code for the same is posted below...

###############################

xlApp.Worksheets("Sheet1").Select Replace:=False
xlApp.Worksheets("Sheet2").Select Replace:=False
xlApp.ActiveWindow.SelectedSheets.PrintOut Copies:=1

###############################

Above code prints only the current sheet..

Any ideas..?

Thanks
Jade