How To Send Email Using Excel VBA
This tutorial show how to send email with VBA
How to send email in excel vba?
How to send email with attachments?
2
views
How To Convert CSV, TEXT Files To/From Excel
How to convert csv files to excel?
How to convert text files to excel?
5
views
How To Convert XML To Excel
This tutorial demonstrates how to import xml data into Excel spreadsheet
Subs, likes, comments, questions welcome
6
views
How to Convert Excel Spreatsheet to XML data
This tutorial will show how easy it is to export excel data to xml data
6
views
How To Create Barcodes That Work? How To Print Barcodes ?
This tutorial shows how to create barcodes in a few easy steps within minutes.. the same method can be used with other office applications as well..
How to create barcodes in excel?
How to add barcodes to excel?
How to print barcodes?
Follow on Twitter/X @tuts4dummi90788
Also available on Rumble
12
views
Excel | VBA | PDF | Convert PDF To Excel | Part 3
Excel | VBA | PDF | How To Convert PDF To Excel | Part 3
This tutorials shows how to convert pdf files to Excel spreadsheets. The first thing we need is the Word Application on our computer. Next, we need to add 2 new references described in this tutorial.. and the code of course
How to extract from PDF and paste to Excel?
How to convert PDF files?
#vbatutorial , #excelvba ,#excelcharts ,#pdftoexcel
Subs, Likes. Comments and Questions welcome below
Code is available on Twitter/X @Tuts4dummi90788
37
views
Excel | VBA | PDF | Convert Excel To PDF Using ExportAsFixedFormat Method | Part2
Excel | VBA | PDF | Conver Excel To PDF Using ExportAsFixedFormat Method | Part2
Here, we're going to use a method called ExportAsFixedFormat to convert excel files to PDF files. This gives you more options than printout method for conversion and can be used to convert to XPS format as well.
Code available on Twitter/X @tuts4dummi90788
Questions and comments welcome below
2
views
Excel | VBA | PDF | Convert Excel to PDF | Part 1 | VBA PrintOut Method
Excel | VBA | PDF | Convert Excel to PDF | Part 1 | VBA PrintOut Method
This is the first part of a tutorial series on How To Convert Excel workbooks, spreadsheets to PDF files. This tutorial contains 5 examples demonstrating what you can do in matter of a few minutes with a few lines of VBA code.
How to convert excel workbook to PDF?
How to convert excel spreadsheet to PDF?
How to convert a selection to PDF?
How to convert a range to PDF?
How to convert selected sheets to PDF?
#vbatutorial , #ConvertExcelToPDF, #excelvba, #microsoftexcel
Code is available on Twitter/X @tuts4dummi90788
4
views
Excel | VBA | Delete From XML File | Part 5
Excel | VBA | Delete From XML File | Part 5
This part is going to show how to delete from XML file using a few lines of VBA code.
How to delete a record from XML file?
How to delete data from XML file?
How to delete from XML file using VBA?
#excelvba ,#xmlCrudOperations, #vbatutorial ,#exceltutorial
code available on twitter @tuts4dummi90788
6
views
Excel | VBA | Read From XML File | Part 3
Excel | VBA | Read From XML File | Part 3
In this part, we're going to see how to read an xml file using VBA with a few lines of code.
How to read xml data using VBA?
How get data from xml file using VBA?
How to copy data from excel sheet and add data to xml file ?
#vbatutorial , #vba-xmltutorial, #crudoperations
Code can be seen and copied from twitter @tuts4dummi90788
Likes, comments and questions welcome
8
views
Excel | VBA | XML | Add Data To XML File | Part 2
Excel | VBA | XML | Add Data To XML File | Part 2
In this part, we're going to see how to add data to XML file we've created in part 1. Any questions? Drop in comments section please
Follow on Twitter @tuts4dummi90788 to see the code
8
views
Excel | VBA | XML | Create XML File | Part 1
Excel | VBA | XML | Create XML File | Part 1
In this part, we're going to see how to create an xml file using VBA within a few minutes.
#vbaxml, #vbaxmlcrud, #vbatutorial, #crudoperations , #excelvba
Like, shares, comments and questions welcome
Follow on Twitter @tuts4dummi90788
Also available on Youtube
And https://crudzone.wordpress.com/vba-crud-operations/
7
views
Excel | VBA | Printing | How to Print Using VBA
Excel | VBA | Printing | How to Print Using VBA
In this video tutorial we look at a few different ways of printing using vba in excel. The Sub can be tied to a button as well - see previous tutorials if you're not sure how to create a button
#vbatutorial #excelvba, #vbaprinting
Follow on Twitter @tutsfordummi90788
6
views
Excel | VBA | PrintPreview | How To Use PrintPreview in VBA
Excel | VBA | PrintPreview | How To Use PrintPreview in VBA
This short tutorial demonstrates how to print preview the current active excel sheet or any other spreatsheet other than activesheet or a selected range..
#visualbasicforapplications , #excelvba, #PintPreview, #vbatutorial , #exceltutorial
Comments, likes and shares welcome
Follow on Twitter @tuts4dummi90788 to see the code used
2
views
Excel | VBA | How To Delete A Chart | Part 4
Excel | VBA | How To Delete A Chart | Part 4
In this part, we're going to see how to easily delete a chart, chartobject using VBA.
Any questions, suggestions, comments? down below please
Make sure to see Parts 1, 2 and 3 to have a better understanding..
#visualbasicforapplications , #excel, #exceltutorial , #vbatutorial , #vbacharts, #excelcharts
Follow on Twitter @tuts4dummies
4
views
Excel | VBA | How To Add, Embed Charts | Part 3
Excel | VBA | How To Add, Embed Charts | Part 3
How to add a chart to an existing spreadsheet using vba : How to embed a chart
In this part, we are going to improve upon what we have seen in part 1 & 2. This time around, we're going to use a table (listobject) as datasource and more..
#vba, #excel
#charts , #excelcharts
#excelvbatutorial
Learn_
comments and likes welcome
Part 1: https://youtu.be/V6XsN3nLuyw
Part 2: https://youtu.be/ByuOdBVi3zM
Follow on Twitter @Tuts4Dummies
9
views
Excel | VBA | How to add chart | part 2
Excel | VBA | Adding, Embedding Charts | Part 2
In part 1, we have seen how to add a chart as a separate sheet whereas in this part we're going to add to an existing excel spreadsheet using VBA code.
#excelvba
#excelcharts
#excelvbatutorial
Learn_
Like, Share and Comment..
follow on twitter @tuts4dummi90788 to see the code
10
views
Excel | VBA | How to Add Chart
Excel | VBA | How To Add Charts | Part 1
This short 5 mins tutorials demonstrates how to add a chart to excel workbook with a few lines of VBA code.
#MicrosoftExcel
#ExcelCharts
#ChartsInExcel
#ExcelTutorial
#vbaTutorial
#VisualBasicForApplications
Learn_
Check Out Part 2 for more:
https://youtu.be/ByuOdBVi3zM
follow on twitter @tuts4dummies
286
views