print one worksheet of an Excel workbook

[lmd2]

I can open a reference to an MS Excel file (workbook), open a particular worksheet, and populate cells. A macro does some magic and populates cells in another sheet. What I need to do now is print a particular worksheet. Is there an example around for printing a single worksheet of a workbook. Guess I can copy that sheet into a temporary report, print the report, and then delete it - is there a better way?

I am attaching the code that I am using to open and modify the workbook - probably besides the point but will illustrate the approach I am using

thanx

lmd2

[Scott_A · Accepted solution]

If you have access to the report generation toolkit you can use the following example Write to a Sheet other than Sheet1 of an Excel Spreadsheet (Report Gen) to print a specific worksheet.  Simply add a print report after the excel get worksheet and you should be all set.

Are you trying to make this without using the report generation toolkit?

[lmd2]

I have the toolkit on some machines, sometimes I feel more in control using low level active-X but I can go either way long as it works - thanx

lmd2