I have an Excel form that uses vba to generate a pdf file, and display it.
However for some users I want to place this form/dashboard file in a Read/Only environment and have the button on the form pull up the relevant pdf files (in a loop) that have already been created.
My current code includes:
Application.DisplayAlerts = False
'ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=FullName _
, Quality:=xlQualityMedium, IncludeDocProperties:=False, _
IgnorePrintAreas:=False, OpenAfterPublish:=True
Application.DisplayAlerts = True
Thus, the file fulfilling the criteria "FullName.pdf" is the one I want the code to pull up, as opposed to Export as a pdf, since such a pdf file with that name already exists.
Is there not some simple code I can replace the above with that will pull up what I need?
T.Y.
However for some users I want to place this form/dashboard file in a Read/Only environment and have the button on the form pull up the relevant pdf files (in a loop) that have already been created.
My current code includes:
Application.DisplayAlerts = False
'ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=FullName _
, Quality:=xlQualityMedium, IncludeDocProperties:=False, _
IgnorePrintAreas:=False, OpenAfterPublish:=True
Application.DisplayAlerts = True
Thus, the file fulfilling the criteria "FullName.pdf" is the one I want the code to pull up, as opposed to Export as a pdf, since such a pdf file with that name already exists.
Is there not some simple code I can replace the above with that will pull up what I need?
T.Y.