Jade
04-29-2010, 01:24 AM
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..? :doh:
Thanks
Jade
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..? :doh:
Thanks
Jade