Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Location
    belgium
    Posts
    290

    Unanswered: setting fonts in vba in case of directly printing to printer

    hello all,

    i can't figure out how i can set the font i needed for the printer to use.

    there must be any ascii string for it

    i am using the command :

    Open "LPT1" For Output As intfile

    print #intfile, .....................

    anyone who can help me with that ?

    if possible some VBA Coding

    thanks in advance

  2. #2
    Join Date
    Mar 2004
    Location
    belgium
    Posts
    290

    Talking

    reading and reading ........

    maybe there an activeX module object that can help me ?

    thanks for the info

    emiel

  3. #3
    Join Date
    Nov 2003
    Posts
    1,487
    Check your Printer manual (usually near the back). There they will explain the use of Control and Escape codes that you can use within your VB (or VBA) code to access the built in printer fonts and other features. If you don't have the manual....find one.


  4. #4
    Join Date
    Mar 2004
    Location
    belgium
    Posts
    290

    Wink

    i didnot find the esc sequences there but there is een nice pda file, around 350 pages, at www.brother.com who explains quit a lot, but in that file there is some information what (like a font description block) to send, but there is nothing written about the its contenance en that is probably what i need.

    if you look at the some toolbars there is a font selector, i am convinced that such a font selector is an object with properties, probably i can use that, but where can i find that object ?

    thanks anyway for your suggestion

    emiel

  5. #5
    Join Date
    Mar 2004
    Location
    belgium
    Posts
    290
    found the solution on this page

    http://www5.software.rockwell.com/ap...2567400058f228

    including downloads

    don´t forget to set the preferences (tool in VBA)

    this DLL gives you another printer object "ActivePrinter" and it is globally set, so it can be activated with in each function or sub

Posting Permissions

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