Hi Experts,



Here are below codes for converting the the file from excel to pdf with the required name of the file. Can you please provide the macro with the present macro for protecting the pdf after conversion from editing in any manner.



Private Sub CommandButton2_Click()
'saves the file as PDF and adds a date parameter to the name of the file


aux1 = ""
If Month(Date) < 10 Then
aux1 = "0"
End If
aux2 = ""
If Day(Date) < 10 Then
aux2 = "0"
End If


fileN = "Salary Slip of " & Workbooks.Application.Sheets("Salary Slip").Cells(10, 5).Value
fileD = Format(Sheets("Salary Slip").Cells(6, 2).Value, "mmm-yy")




ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=ThisWorkbook.Path & "\" & fileN & " for " & fileD & ".pdf", _
Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=True


End Sub


Please help me out experts.

Regards,

Neilesh

Cross-posted at different forums without links. ( at least two)
Please add links to ALL your existing cross-posts. You have already been warned about this and asked to do so on different forums.
If you persist in ignoring forum rules, other steps will be taken. Thank you

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Dear Sir,

Please suggest sir then what should i do. I truly apologies to cross post in different forums but the matter is quite urgent and i have been keep chasing since last 2-3 days but no response i got.

I really apologies for the same but i tried my level best as well while searching on google but nothing has come yet positively.

Request to you please if you can help me out, I would be great obliged to you Sir.

Regards,

Neilesh

For the second and LAST time, please post links to ALL your existing cross-posts.
Otherwise I will be obliged to close this thread.
Thank you

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi Experts,

Below are the links where i requested on my threads:

http://www.mrexcel.com/forum/excel-q...ion-excel.html

http://www.ozgrid.com/forum/showthre...741#post775741

https://www.msofficeforums.com/excel/...tml#post103513

http://www.excelforum.com/excel-gene...rom-excel.html (Closed by me)

Request to you please provide the solution on the same.


Regards,

Neilesh

Thank you for the info
although you forgot http://www.excelguru.ca/forums/showt...ion-from-excel

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Dear Sir,

Can you please help me on my post? Request to you please help me on my thread.

Thank you for your precious phase and valuable cooperation.

Regards,


Neilesh

Hi Experts,

Can anyone please help me on my post? Request to you please help me on my thread.

https://www.msofficeforums.com/excel...ion-excel.html

Thank you for your precious phase and valuable cooperation.

Regards,


Neilesh