Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    Terneuzen, Netherlands
    Posts
    895
    Thanks
    0
    Thanked 0 Times in 0 Posts

    HP7750 Plotter? (ExcelXP)

    Made a little sheet & VBA-code years back that controlled (amongst others) an HP7550 plotter. I needed some boxes to be drawn (not much more). Reason to use a plotter was that dimensions of the box were essential and the HPGL allowed me to control this nicely...

    Now we're years ahead and plotters are (sort of) out... how do I create -say- two squares on a printer (with some text in it) where the dimension of the square need to be exact (e.g. 3 inches).... Can I do something in Excel VBA?

    Erik Jan

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: HP7750 Plotter? (ExcelXP)

    Excel is not WYSIWYG (What You See Is What You Get). Therefore, it is not a good tool for doing what you describe. For example, if I use the Excel drawing tool to draw a square on the screen, and then use Format Autoshape to set the size to exactly 3.00"x3.00", and then print the sheet I get a box that is 3 1/8" x 2 7/8". You would be better using a tool that is designed to do this. I use DeltaCad.
    Legare Coleman

  3. #3
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    Terneuzen, Netherlands
    Posts
    895
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: HP7750 Plotter? (ExcelXP)

    I know WYSIWYG is not possible in most cases... the beauty was that by controlling a plotter it WAS (is) possible... because I was sending plotter-commands (HPGL) directly via a serial port.

    Anyway... maybe I can sort of try to calibrate Excel... so make the autoshape such that the printed output is 3 x 3??

    I'd need some coding to read user input, that's why I want e.g. Excel i.s.o. a drawing program....

    Erik Jan

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: HP7750 Plotter? (ExcelXP)

    You could experiment, but I don't know if you'll be successful - not only does Excel print graphic objects at a size different from what you specify on the worksheet, but it is very difficult to place them exactly where you want.

    Create a square and specify its dimensions exactly. Measure the printed output accurately, and calculate multiplication factors for width and height:

    Width factor = specified width / printed width
    Height factor = specified height / printed height

    Next, create a rectangle, and multiply the desired width and height with the calculated factors. See if it prints at the desired size.

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: HP7750 Plotter? (ExcelXP)

    Windows now blocks sending control language directly to printers and plotters. I had to rewrite a program I wrote in C for Windows 3.0 when they made that change.
    Legare Coleman

  6. #6
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    Terneuzen, Netherlands
    Posts
    895
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: HP7750 Plotter? (ExcelXP)

    It's solved... a bit... Creating a HPG-file and using a batch-file to copy the file to COM2: (where we still chose to keep the plotter connected in lieu of a better alternative - for now)

    Thanks for the tips and hints...

Posting Permissions

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