|
|
#4
12-30-2019, 06:11 AM
|
||||
|
||||
Add the option to 'OpenAfterPublish' i.e.
Code:
.ExportAsFixedFormat Type:=xlTypePDF, _
FileName:=sPath & sName, _
Quality:=xlQualityStandard, _
IgnorePrintAreas:=False, _
OpenAfterPublish:=True
__________________
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 |
 Code to change highlight on content control automatically
|
gsbpxw | Word VBA | 2 | 06-11-2018 03:05 AM |
|
vb code for updating file automatically
|
klpw | Excel Programming | 1 | 01-14-2016 08:05 PM |
|
Auto Save Every Page(s) as a separate file, and name each new file automatically by the first line?
|
commissarmo | Word VBA | 3 | 03-14-2015 12:53 AM |
|
How to convert a text file to an Excel file with the data format automatically?
|
mradmin | Excel | 6 | 10-16-2013 10:34 AM |
|
How to copy automatically data from Excel file to Word file?
|
fuchsd | Word | 6 | 10-25-2011 05:52 AM |
Windows 10 
Office 2016
Threaded Mode