Access to Excel Printouts

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hello,
Please, can somebody help?

In my access database, I want to be able to print out an excel sheet - Is it
possible?

When I click the print button, depending on which product I have selected in
a combobox.
I want access to print the related sheet that's stored in excel.

I have 5 different worksheets in one spreadsheet, all labelled with
different names

Please help

Thanks
Mike
 
I answered this one on your second post, but let me add: If you want to
print a sheet other than the first one, change this line:

Set wks = wkb.Worksheets(1)

so that the worksheet index points to another sheet:

Set wks = wkb.Worksheets(2)

Make sure in your error handling that you cover the event of there not being
a sheet (2).
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top