+ Reply to Thread
Results 1 to 2 of 2

automatic printing

  1. #1
    Registered User
    Join Date
    06-20-2005
    Posts
    18

    automatic printing

    HELP!!!!!

    I want to be able to automatically print a label from excel when i input data.

    the data will be sent to excel automatically from a software package called winwedge.

    once this data arrives in excel i need excel to do three things with it.

    firstly, i need it to log this data with all the other data to form graphs - this isnt a problem.

    secondly, i need excel to take a copy of this data and paste it into a pre defined area ready to print.

    and thirdly, once the information is inpuuted into the predefined area, i need it to print automatically.

    this seems unlikely to me, but im sure there is someone out there who can tell me if it is possible or not??????

    many thanks

    neil

  2. #2
    Forum Contributor
    Join Date
    02-23-2005
    Location
    England
    Posts
    110
    I assume you have written some macros in the past. If you have some basic macro and VBA experience you could write a procedure using the SheetChange Event to trigger printing using the PrintOut Method.
    Last edited by PeterB; 06-23-2005 at 08:31 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1