filmov
tv
how to export excel table into word file using vba code | #excel #macro #vba #technology #shorts
Показать описание
how to export excel table into word file using vba code
Sub ExportExcelTableinworddocument()
Dim wdapp As New Word.Application
On Error Resume Next
wdapp.Visible = True
wdapp.Activate
wdapp.Documents.Add
With wdapp.Selection
.ParagraphFormat.Alignment = wdAlignParagraphCenter
.BoldRun
.Font.Size = 15
.Font.ColorIndex = wdDarkRed
.TypeText "MIS Report"
End With
Sheet1.Range("A1").CurrentRegion.Copy
wdapp.Selection.Paste
Application.CutCopyMode = False
ActiveDocument.Tables(1).AllowAutoFit = True
ActiveDocument.Tables(1).AutoFitBehavior wdAutoFitContent
ActiveDocument.Close
wdapp.Quit
End Sub
Sub ExportExcelTableinworddocument()
Dim wdapp As New Word.Application
On Error Resume Next
wdapp.Visible = True
wdapp.Activate
wdapp.Documents.Add
With wdapp.Selection
.ParagraphFormat.Alignment = wdAlignParagraphCenter
.BoldRun
.Font.Size = 15
.Font.ColorIndex = wdDarkRed
.TypeText "MIS Report"
End With
Sheet1.Range("A1").CurrentRegion.Copy
wdapp.Selection.Paste
Application.CutCopyMode = False
ActiveDocument.Tables(1).AllowAutoFit = True
ActiveDocument.Tables(1).AutoFitBehavior wdAutoFitContent
ActiveDocument.Close
wdapp.Quit
End Sub
0:01:20
How to save excel sheet as pdf without cutting off
0:00:56
Import and export excel table into AutoCAD
0:00:25
How to convert data to Table format in excel tips #learnexcelfree
0:00:30
How to copy table from PDF to Excel File in 30seconds
0:00:19
Excel Table Convert Into Picture | TrickoWorld
0:06:18
How to Convert Excel spreadsheet data into a Table
0:00:57
Convert Image to Excel Table in Seconds! 🔥 Easy Trick You Must Try #excel
0:00:39
Excel sheet convert to PDF🔥🤓 #excel #viral #shorts #shortsvideo #computer #exceltips
0:02:19
How to Create an Automated Invoice Generator in Excel (Step-by-Step Tutorial) #excel
0:00:22
Paste Excel to Word WITHOUT gridlines
0:00:22
Format messy CSV data in 15 Seconds! #excel #exceltips #exceltricks
0:01:01
Don't Copy PDF Data in Excel‼️Instead Use Amazing Trick #exceltips #excel #exceltricks #shorts...
0:02:33
How to Convert Excel to Google Sheets (Quick and Easy)
0:00:42
Easy way to copy table from excel to word #excel #word #exceltutorial #shorts #short #wordtutorials
0:00:32
Export any table from Autocad to excel with one click
0:00:42
Convert an image to a Table on Excel #shorts #excel
0:00:52
PDF ka Data Excel me laao 5 Sec me🔥😲 #viral #excel #exceltips #computer
0:00:41
Excel trick to transfer data from paper to excel sheet in less than 10 seconds
0:02:17
How to Export Excel Table data to SharePoint Online List
0:00:34
How to make a Pivot Table in 3 Steps‼️ #excel
0:08:07
How to PROPERLY Convert Excel to PDF
0:00:50
Excel Pivot Table: How to convert to a Regular Table
0:00:40
MS Word text convert to excel short trick 🔥😲 #viral #excel #shortvideo #exceltips #computer
0:00:26
How to Sync Excel Data to Word file #excel #exceltips #msword #shorts #shortsfeed
Комментарии