Microsoft Office Forums - View Single Post - Save Filename based on Text Field

Thread: Save Filename based on Text Field

View Single Post

Old

10-02-2014, 09:45 PM

gmayor

gmayor is offline

gmayor uses Windows 7 64bit

Windows 7 64bit gmayor uses Office 2010 32bit

gmayor uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Aug 2014

Posts: 4,142

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

Default

You have embedded a sub within a sub

Private Sub CommandButton1_Click()
Sub Send_PDF_As_Attachment()

and similarly at the end you have

End Sub
End Sub

Remove one of the End Subs

and the line

Sub Send_PDF_As_Attachment()

and provided the code is associated with the button you should be getting somewhere.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Reply With Quote