![]() |
|
#2
|
||||
|
||||
|
Bearing in mind that not all PDF format files are editable in Word, and that this only works for Word versions 2013 and later, the following can be used to select and open one
Code:
Option Explicit
Sub Macro1()
Dim strFname As String
Dim oDoc As Document
strFname = BrowseForFile("Select the PDF file to open")
If strFname = vbNullString Then GoTo lbl_Exit
Set oDoc = Documents.Open(strFname)
'do stuff with odoc
lbl_Exit:
Exit Sub
End Sub
Function BrowseForFile(Optional strTitle As String) As String
'Graham Mayor - http://www.gmayor.com
'strTitle is the title of the dialog box
'Set bExcel value to True to filter the dialog to show Excel files
'The default is to show Word files
Dim fDialog As FileDialog
On Error GoTo err_handler
Set fDialog = Application.FileDialog(msoFileDialogFilePicker)
With fDialog
.Title = strTitle
.AllowMultiSelect = False
.Filters.Clear
.Filters.Add "Adobe PDF files", "*.pdf"
.InitialView = msoFileDialogViewList
If .Show <> -1 Then GoTo err_handler:
BrowseForFile = fDialog.SelectedItems.Item(1)
End With
lbl_Exit:
Exit Function
err_handler:
BrowseForFile = vbNullString
Resume lbl_Exit
End Function
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
How to use the icons for macros included in Word programmatically
|
dherr | Word VBA | 6 | 03-27-2015 01:05 AM |
| word 2003 slow saving passworded files windows 7 | dontdoslow | Word | 5 | 08-08-2014 04:12 AM |
programmatically inserting hidden text into a Word 2010 table
|
epid011 | Word VBA | 16 | 12-30-2013 11:29 AM |
| how to identify the word files created using Windows or Mac Operating System? | mariaprabudass | Word | 0 | 08-06-2010 05:52 AM |
| Programmatically get File Path for currently opened WORD document | franferns | Word | 1 | 11-26-2009 12:36 PM |