Print Excel Sheet from Access

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

In access I created a form. From this form you can call a VBA code which
creates an Excel sheet from a query. The Excel sheet is made vissible using
the following code: xlApp.Visible = True

Which VBA code do I have to add to print the Excel sheet? And after the
sheet is printed, which code do I have to add to close the Excel application?

Thanks in advance,

JeroenM.

.

Relevant Pages

  • comapre 2 col.
    ... i want to know if there is any solution for this query. ... i want vba code to compare values of 2 column. ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Print Excel Sheet from Access
    ... > as a tip, when writing automation applications, go into the automated ... > application and record a macro, do the functions you are trying to automate, ... >> creates an Excel sheet from a query. ... >> Which VBA code do I have to add to print the Excel sheet? ...
    (microsoft.public.access.modulesdaovba)
  • Bypassing startup macros
    ... I've created an Excel sheet with lots of VBA code behind it. ... How can I retrieve the VBA modules so that I don't have to recreate the code ...
    (microsoft.public.excel.programming)
  • How to show the System Name
    ... What is the VBA code to show the system name of a pc. ... Or is it possible to show the system name immediately in a query. ... Simon van Beek ... Prev by Date: ...
    (comp.databases.ms-access)
  • Re: create a mdb databse and a table and add records from Excel VBA
    ... Accoring to your VBA code, I am able to open the database. ... updating from the excel sheet. ... The actual problem is its updating the ...
    (microsoft.public.excel.programming)