+ Reply to Thread
Results 1 to 3 of 3

Thread: Word(.doc) to TIFF conversion macro.....

  1. #1
    Registered User
    Join Date
    09-13-2009
    Location
    bangalore
    MS-Off Ver
    Excel 2007
    Posts
    7

    Post Word(.doc) to TIFF conversion macro.....


    Hello everyone, I need help creating a macro file converstion.


    I have nearly 200 files/day in .DOC format and finaly I need to convert to .TIFF format.
    currently I'm converting manually, but it consuming lot of my work hours.
    Please help me out how to convert file f by macro.

    Thanks,
    Karun

  2. #2
    Forum Guru, retired Admin royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    25,647

    Re: Word(.doc) to TIFF convertion macro.....

    This might work
    Option Explicit
    
    
    Sub CreateTiff()
    Dim sActivePrinter As String
    Dim sTifPath As String
    Dim sTifFolder As String
    Dim sTifFile As String
    
    'Save current printer
    sActivePrinter = Application.ActivePrinter
    sTifFolder = "C:\My Documents\"
    sTifFile = "TestTiff.tif"
    
    'Use dialog so we do not change the system wide default printer
    With Dialogs(wdDialogFilePrintSetup)
    .Printer = "Microsoft Office Document Image Writer"
    .DoNotSetAsSysDefault = True
    '.Show
    .Execute
    
    End With
    
    'Set tif file path and name
    sTifPath = sTifFolder & sTifFile
    
    'Create tif file
    Application.PrintOut Background:=False, Append:=False, _
    Range:=wdPrintAllDocument, OutputFileName:=sTifPath, _
    Item:=wdPrintDocumentContent, Copies:=1, _
    PageType:=wdPrintAllPages, PrintToFile:=True
    
    'Reset printer
    With Dialogs(wdDialogFilePrintSetup)
    .Printer = sActivePrinter
    .DoNotSetAsSysDefault = True
    .Execute
    End With
    End Sub
    Hope that helps.

    RoyUK
    --------
    If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need

    For Excel Tips & Solutions, free examples and tutorials why not check out my downloads

    New members please read & follow the Forum Rules

    Remember to mark your questions Solved and rate the answer(s)

  3. #3
    Registered User
    Join Date
    09-13-2009
    Location
    bangalore
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Word(.doc) to TIFF convertion macro.....

    Hi RoyUK,

    Thank you for u r suggestion,,, however when try execute I'm getting runtime error as "\variable not defined", Please help me out on this error....

+ 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.2.0