Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-10-2018, 01:11 PM
mgl_8 mgl_8 is offline open custon files, convert to Word, print/save to PDF Windows 10 open custon files, convert to Word, print/save to PDF Office 2016
Novice
open custon files, convert to Word, print/save to PDF
 
Join Date: Apr 2018
Posts: 4
mgl_8 is on a distinguished road
Smile open custon files, convert to Word, print/save to PDF

Hi. I have a software program that creates custom files, let's say BBB. I have a Word 2016 add-in which opens these BBB files in Word. I have 1,500 of these files and am looking for the best way to save these files as PDF.

I've tried opening Word and selecting the files, which opens them for viewing in Word but in Compatibility mode. To save from there, it seems like I have to save one at a time. Is there a way to open/convert to Word/save in one fell swoop?



From there, I could convert to PDF.

Thank you for any and all advice!
Reply With Quote
  #2  
Old 04-10-2018, 10:04 PM
macropod's Avatar
macropod macropod is offline open custon files, convert to Word, print/save to PDF Windows 7 64bit open custon files, convert to Word, print/save to PDF Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Each file would have to be opened and saved individually, though this could be automated with a macro.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 04-10-2018, 11:08 PM
eNGiNe eNGiNe is offline open custon files, convert to Word, print/save to PDF Windows 7 32bit open custon files, convert to Word, print/save to PDF Office 2010 64bit
Expert
 
Join Date: Jan 2012
Location: Brussels [BE]
Posts: 746
eNGiNe is on a distinguished road
Default

Acrobat Pro provides bulk conversion, though this will of course depend on whether it recognises the format of your .bbb files … and on your having Acrobat Pro ;-} There may well be other tools that will do the same job, but I'm lucky enough not to have needed to find out.
Reply With Quote
  #4  
Old 04-11-2018, 08:19 AM
mgl_8 mgl_8 is offline open custon files, convert to Word, print/save to PDF Windows 10 open custon files, convert to Word, print/save to PDF Office 2016
Novice
open custon files, convert to Word, print/save to PDF
 
Join Date: Apr 2018
Posts: 4
mgl_8 is on a distinguished road
Default thanks

I will have to find someone who knows macros - which would not be me!
Reply With Quote
  #5  
Old 04-11-2018, 03:04 PM
macropod's Avatar
macropod macropod is offline open custon files, convert to Word, print/save to PDF Windows 7 64bit open custon files, convert to Word, print/save to PDF Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

A macro is easy enough to write, but you'll need to at least tell us what the extension is for the filenames concerned.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 04-13-2018, 09:23 AM
mgl_8 mgl_8 is offline open custon files, convert to Word, print/save to PDF Windows 10 open custon files, convert to Word, print/save to PDF Office 2016
Novice
open custon files, convert to Word, print/save to PDF
 
Join Date: Apr 2018
Posts: 4
mgl_8 is on a distinguished road
Default macros

I wasn't even expecting that kind of help here! They are .BIL (and .TXT) files.
Reply With Quote
  #7  
Old 04-13-2018, 03:38 PM
macropod's Avatar
macropod macropod is offline open custon files, convert to Word, print/save to PDF Windows 7 64bit open custon files, convert to Word, print/save to PDF Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Try the following macro:
Code:
Sub GeneratePDFs()
Application.ScreenUpdating = False
Dim strFolder As String, strFile As String, strDocNm As String, wdDoc As Document, i As Long, ArrExt, StrExt As String
ArrExt = Array(".bil", ".txt")
strDocNm = ActiveDocument.FullName
strFolder = GetFolder
If strFolder = "" Then Exit Sub
strFolder = strFolder & "\"
For i = 0 To 1
  StrExt = ArrExt(i)
  strFile = Dir(strFolder & "*" & StrExt, vbNormal)
  While strFile <> ""
    Set wdDoc = Documents.Open(FileName:=strFolder & strFile, ConfirmConversions:=False, _
      ReadOnly:=True, AddToRecentFiles:=False, Visible:=False)
    With wdDoc
      .SaveAs FileName:=strFolder & Split(strFile, StrExt, , vbTextCompare)(0) & ".pdf", _
        FileFormat:=wdFormatPDF, AddToRecentFiles:=False
      .Close SaveChanges:=False
    End With
    strFile = Dir()
  Wend
Next
Set wdDoc = Nothing
Application.ScreenUpdating = True
End Sub

Function GetFolder() As String
Dim oFolder As Object
GetFolder = ""
Set oFolder = CreateObject("Shell.Application").BrowseForFolder(0, "Choose a folder", 0)
If (Not oFolder Is Nothing) Then GetFolder = oFolder.Items.Item.Path
Set oFolder = Nothing
End Function
Simply select the folder to process and the macro should convert all .BIL and .TXT files in that folder to PDFs.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
After Windows 10 Creator update I cant open or save files from within Office programs papapaul Office 1 06-05-2017 07:07 AM
open custon files, convert to Word, print/save to PDF Convert handwriting to text and save to word tigris OneNote 1 10-30-2014 01:14 PM
open custon files, convert to Word, print/save to PDF Cannot open Outlook but want to save Outlook files timm@bicyclegermany.com Outlook 1 08-03-2014 10:59 AM
Open and save Word files mbesspiata Word VBA 3 05-23-2014 07:15 PM
Convert old PowerPC file to Intel-based files in Word? walmar Word 0 06-12-2013 07:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:06 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft