You can find here Excel tricks and tips like excel formula, advanced Excel, Excel VBA guide
Showing posts with label Videos. Show all posts
Showing posts with label Videos. Show all posts
Sunday, 5 December 2021
Thursday, 2 September 2021
Friday, 16 July 2021
Thursday, 8 July 2021
Saturday, 29 May 2021
Wednesday, 26 May 2021
Sunday, 9 May 2021
Monday, 8 March 2021
Tuesday, 15 December 2020
Sunday, 4 October 2020
Monday, 31 August 2020
Sunday, 2 August 2020
Monday, 27 July 2020
Thursday, 23 July 2020
Monday, 20 July 2020
Sunday, 28 June 2020
Saturday, 20 June 2020
Friday, 19 June 2020
Friday, 12 June 2020
Save as PDF in Excel using VBA || Export As PDF from Excel || Excel to P...
VBA CODE
Sub saveaspdf()
Dim sh As Worksheet
Set sh = Sheets("Sheet1")
Dim myfile As String
myfile = "C:\New folder\" & sh.Range("D4") & ".pdf"
sh.Range("B3:J23").ExportAsFixedFormat xlTypePDF, myfile, , , , , , openafterpublish:=True
End Sub
Click here to download this file..