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
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)
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....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks