How to Convert Multiple Sheets to Multiple PDF Files| अब Single Click से कई PDF फाइलें बनाये|
In this Video all Viewers will learn about How to convert multiple sheets to multiple PDF files with Single Click
VBA Coding of this Function as given below:
Sub exporttopdf()
Dim sheet As Worksheet
Dim mysheetname As String
For Each sheet In Worksheets
sheet.Select
mysheetname = sheet.Name
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:="c:\All pdf\" & mysheetname & ".pdf", _
openafterpublish:=False
Next sheet
MsgBox "File exported Successfully"
End Sub
This Grip Excel Channel will enhance your knowledge in Excel, Google Sheet and MS Office tools with new method or some windows tricks too. Concept behind this channel to make everyone easy to operate formula or function with shortcut methods as well as to operate Computer in easy manners. I hope you will learn basic to advance excel in this channel
Click on Following Link to Subscribe my Channel and Watch Previous Videos https://tinyurl.com/y7htaj52
Basic to Advanced Full Course:
Introduction to Excel Chapter: 1 • Microsoft Excel Tutorial| Beginners to Adv...
Data Entering and Formatting Chapter: 2 • Microsoft Excel Tutorial| Beginners to Adv...
Basic Formulas and Functions Chapter: 3 • Microsoft Excel Tutorial| Beginners to Adv...
Facebook Link of My Channel Grip Excel
https://www.facebook.com/profile.php?...
Instagram Link of My channel given below:
/ gripexcel
Click on Following Link to follow my videos on Telegram
https://t.me/gripexel
Email ID- [email protected]
#gripexcel
#excelformula
#Excel
#Excelsolution
#youtube
#youtubeshorts
Welcome to GRIP EXCEL Youtube Channel Create By: Rahul Kumar, Computer Faculty, District. Sri Muktsar Sahib, (Punjab) For Further Information Contact me on *9501599255*