Results 1 to 8 of 8
  1. #1
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Borders on paragraphs do not print using VBA 6.0

    What happens when you reapply the border to one of these footers then try the VBA print?

    I am also wondering by what method the documents were converted?
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  2. #2
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts

    Re: Borders on paragraphs do not print using VBA 6.0

    Hi,

    I couldn't reproduce the problem, but was wondering as a workaround whether trying a different print method might help. For example, if you're using:
    ActiveDocument.PrintOut
    instead try:
    Dialogs(wdDialogFilePrint).Execute

    Kind of grasping at straws, but worth a try..

    Gary

  3. #3
    D Storms
    Guest

    Re: Borders on paragraphs do not print using VBA 6.0

    I've tried to reapply the borders, even changed the line thickness and there is no difference. The lines will not print when the report is printed using VBA.

    The 6.0 documents were openned in Word 2000 and saved as a Word 2000 format. A test print of each document was then done to ensure that all formatting was maintained.

    Thanks, Denise

  4. #4
    D Storms
    Guest

    Re: Borders on paragraphs do not print using VBA 6.0

    VBA opens the existing document adds text then prints directly to the default printer as follows.

    Documents.Open FileName:={doc_nm}, ConfirmConversions:= _
    False, ReadOnly:=True, AddToRecentFiles:=False,
    PasswordDocument:="", _
    PasswordTemplate:="", Revert:=False,
    WritePasswordDocument:="", _
    WritePasswordTemplate:="", Format:=wdOpenFormatAuto

    ActivePrinter = "SSPROD01Prod5si" 'Default Printer

    Application.PrintOut PrintToFile:=False, FileName:="", copies:=1

    Thanks, Denise

  5. #5
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Borders on paragraphs do not print using VBA 6.0

    Humor me. Do this with either the original Word 6 doc or one of the already "converted" docs: Open the doc, select all the text (ctrl-a) and ctrl-c, open a new blank doc -- now this should preferably be one with your company styles already defined, but a naked Normal.dot doc will do. Now paste the text into the new blank doc. Save the new doc and run your code against it. How does it print?
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  6. #6
    D Storms
    Guest

    Re: Borders on paragraphs do not print using VBA 6.0

    I copied the text into a new normal.dot document and tried running the code. The result is the same - the lines do not print.

    Any other suggestions?

    Thanks, Denise

  7. #7
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Borders on paragraphs do not print using VBA 6.0

    Tre mal.

    What style is applied to the paragraph in question? You could try this: remove the direct formatting (the borders and anything else). Create a style with the exact formatting you want. Apply it the lines in the footer. Test print.

    Now.......... I'm out of ideas.[img]/w3timages/icons/crazy.gif[/img]
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  8. #8
    D Storms
    Guest

    Borders on paragraphs do not print using VBA 6.0

    I converted over 100 Word 6.0 documents to Word 2000. Each document contains paragraphs with borders in the footers. These were created by selecting a line of text and using the Format-Border option to add a border to the bottom or top of the current text line. I have tested this in the body of the report and in footers.

    The lines print fine if I send the document to print directly from Word or create a PDF file directly from Word. However, once I open the document using a Macro (VBA) and print the file from VBA the lines no longer appear. It does save the document with the line in it and if I reopen it after VBA is done, it prints just fine through Word. Also, if I create a PDF file using VBA, the lines does not appear.

    I have searched the internet for help on this but have not been successful. Any work arounds which would resolve this would be greatly appreciated.

    UPDATE TO PROBLEM: ------------------------
    If have found that if I turn "Background Printing" ON in Word 2000, it will print correctly. However, because of the way my program interfaces with another program, I am not able to do "Background Printing" when running my programs. If it is turned on, the program aborts when it grabs the next request and it has not finished printing the previous request.

    Thank you for any assistance.
    Denise

Posting Permissions

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