រៀនពីរបៀប Export Excel to PDF Reports ក្នុងមួយចុចជាមួយ Excel VBA

Описание: រៀនពីរបៀប Export Excel to PDF Reports ចុចតែមួយ Click ជាមួយ Excel VBA
ររៀប Save ឬ Save As ឬ Save a Copy
ជាចំាបាច់ដែលត្រូវ Save or Save As Excel file ទៅជា Excel Macro-Enabled Workbook ដើម្បីអាចដំណើរការនៅ VBA (Visual Basic for Applications) ដែលអាចជួយឱ្យការងារបានលឿនជាងមុននៅពេលដែលមានការរបៀបចំរួច។
Excel to PDF with VBA - The Easy Way!
Expert Excel to PDF using VBA (Automate PDF Creation)
স্প্রেডশীটে ডেটা ম্যানেজমেন্টের সেরা কৌশলগুলি শিখুন

****
SUBSCRIBE FOR MORE Videos:    / @rss.civilengineers  

****
Join with my Channel:
Telegram ➡︎ https://t.me/rsscivilengineers
ទាញយកឯកសារ File: https://t.me/rsscivilengineers/17

****
Save, Save As, Save A Copy, Developer, Code, VBA, Visual Basic for Application, Button Box

****
Code VBA:
Sub Export_To_PDF_General_Daily_Working()

Dim wb As Workbook
Dim ws As Worksheet
Dim rng As Range
Dim Path As String
Dim FName As String

Set wb = ThisWorkbook
Set ws = wb.Worksheets("General Daily Working")
Set rng = ws.Range("Print_Area")
Path = CreateObject("wscript.shell").specialfolders("desktop") & "\"
FName = Format(Now(), "YYYYMMDD") & "_" & ws.Range("A3").Value & ".pdf"

rng.ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:=Path & FName, _
IgnorePrintAreas:=True


End Sub

****
Timestamps:
0:00 សេចក្ដីណែនាំ
01:20 Save, Save As, Save A Copy
03:23 Add Developer, Button Box
07:31 លម្អិតចំណង់ជើង Export To PDF
08:24 Visual Basic for Applications, Code Export to PDF
17:51 បាទ! អរគុណ

****
រៀនពីរបៀបប្រើប្រាស់ Excel Function ងាយៗក្នុងរយៈពេល១០នាទី
   • [01] ការរៀបចំរបាយការណ៍កម្លាំងប្រចាំថ្ងៃ នៅ...  
   • ការប្រើប្រាស់ Function Excel ដែលងាយស្រួលក្...  

****
សូមចុច Subscribe ដើម្បីទទួលបាន Videos ថ្មីៗពីការចែករំលែកនៅវិស័យសំណង់។
Click "Subscribe" to receive new video updates from RSS Civil Engineers on YouTube. Stay connected for the latest civil engineering projects, insights, and innovations.
Advance thank you for your support!

#excel #code #pdf #save #export #vba #microsoft365