I have a userform with a progress bar. Any ideas why the progress bar is showing the count, rather than % complete? In this instance there are 20 items, and as the progress bar runs, it starts at 1%, 2%, ending at 20%, rather than 100% (total count of the items is 20).
Please Login or Register to view this content.
Last edited by Leith Ross; 09-25-2017 at 03:57 PM. Reason: Added Code Tags
Maybe:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
That was it! Thank you, greatly appreciated.
Any ideas on saving as a .pdf rather than .docx? The code below will create 1 pdf, but for some reason the bookmarks are deleted in the template so it obviously won't continue.
' SAVE AS A PDF: START
doc.ExportAsFixedFormat OutputFileName:=FilePath & "Document " & DocumentCell.Value & ".pdf", _
ExportFormat:=wdExportFormatPDF
doc.Close
Set doc = Nothing
The following will create both Word and PDF, which will work fine. However, I am curious how to close Word without saving if anyone knows.
‘Save as Word
doc.SaveAs2 FilePath & "Document " & DocumentCell.Value & ".docx"
' Save as PDF
doc.ExportAsFixedFormat OutputFileName:=FilePath & "Document " & DocumentCell.Value & ".pdf", _
ExportFormat:=wdExportFormatPDF
doc.Close
Next DocumentCell
wd.Quit
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks