- 91
- 33 308
VBA Learning tutorials
India
Приєднався 20 гру 2011
Hi Friends,
Thank you for visiting my you tube channel.👍
Welcome to my UA-cam channel where you can learn advance excel, Macro and VBA automation from basic to advance level. and start your career in Excel & VBA automation.
This channel may be very helpful to improve your Excel VBA Knowledge and friends
Please like & subscribe my channel to get more updates related to VBA videos.
👉 bit.ly/3DYZm0e
Please reach out to me for Excel, VBA, MS Access, SQL Server & Power BI for online classes and project enquiry.
👉WhatsApp Number +91-8585995463 , Email Id-akasht20kr@gmail.com
Thank you for visiting my you tube channel.👍
Welcome to my UA-cam channel where you can learn advance excel, Macro and VBA automation from basic to advance level. and start your career in Excel & VBA automation.
This channel may be very helpful to improve your Excel VBA Knowledge and friends
Please like & subscribe my channel to get more updates related to VBA videos.
👉 bit.ly/3DYZm0e
Please reach out to me for Excel, VBA, MS Access, SQL Server & Power BI for online classes and project enquiry.
👉WhatsApp Number +91-8585995463 , Email Id-akasht20kr@gmail.com
Excel to PDF converter using vba code |#excel #vba #technology
#excel #vba #technology
Excel VBA Syllabus
Basic VBA
👉 Lesson 1 Excel Macro Tutorial - How to Write Macros in Excel & Use
👉 Lesson 2 VBA in Excel - What is Visual Basic for Applications, How to Use
👉 Lesson 3 VBA Variables, Data Types Definition & Explanation
👉 Lesson 4 VBA Comparison Operators - Not equal, Less than or Equal to
👉 Lesson 5 VBA Logical Operators - AND, OR, NOT
👉 Lesson 6 VBA IF else condition
👉 Lesson 7 VBA Loop
👉 Lesson 8 VBA custom filter
👉 Lesson 9 VBA file dialog
👉 Lesson 10 VBA worksheet function
👉 Lesson 11 VBA Projects
👉 Lesson 12 VBA Split function
👉 Lesson 13 VBA Active x and form controls
👉 Lesson 14 VBA Userform
👉 Lesson 15 VBA Text function (Example-Replace/Trim/Left/Right/mid/find etc)
👉 Lesson 16 VBA with external data base(Ms Access & SQL Server)
👉 Lesson 17 VBA with Microsoft Outlook
👉 Lesson 18 VBA with Microsoft Power point
👉 Lesson 19 VBA with Microsoft Word
👉 Lesson 20 VBA with Pivot tables
👉 Lesson 21 VBA Interview questions.
Advance VBA
👉 Lesson 22 VBA Array
👉 Lesson 23 VBA UDF function
👉 Lesson 24 VBA Dictonary
👉 Lesson 25 VBA Collection
👉 Lesson 26 VBA Error Handling
👉 Lesson 27 VBA Events
👉 Lesson 28 VBA crawling
👉 Lesson 29 VBA Projects
👉 Lesson 30 VBA Interview questions.
how to convert excel table into pdf file
Sub BrowseFile()
Dim fd As FileDialog
Dim strpath As String
Set fd = Application.FileDialog(msoFileDialogFilePicker)
With fd
.Title = "Select Excel file"
.Filters.Add "Excel File", "*.xlsx"
If .Show = True Then
strpath = .SelectedItems(1)
End If
End With
Sheet1.Range("E5").Value = strpath
End Sub
Sub CopyData()
Dim wkb As Workbook
Dim varData As Variant
Set wkb = Workbooks.Open(Sheet1.Range("E5").Value, ReadOnly:=True)
varData = wkb.Sheets(1).Range("A1").CurrentRegion.Value
Sheet2.Range("A1").Offset(1, 0).ClearContents
Sheet2.Range("A1").Resize(UBound(varData, 1), UBound(varData, 2)) = varData
wkb.Close savechanges:=False
Call ConvertDataInto_PDF
End Sub
Sub ConvertDataInto_PDF()
Dim path As String
Dim sh As Worksheet
Dim flpath As String
Set sh = ThisWorkbook.Sheets("data")
flpath = "pdf-" & Format(Date, "dd-mm-yy") & ".pdf"
path = ThisWorkbook.path & "\"
sh.ExportAsFixedFormat xlTypePDF, path & flpath, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintareas:=False, openAfterPublish:=False
MsgBox "PDF has been exported", vbInformation
End Sub
Excel VBA Syllabus
Basic VBA
👉 Lesson 1 Excel Macro Tutorial - How to Write Macros in Excel & Use
👉 Lesson 2 VBA in Excel - What is Visual Basic for Applications, How to Use
👉 Lesson 3 VBA Variables, Data Types Definition & Explanation
👉 Lesson 4 VBA Comparison Operators - Not equal, Less than or Equal to
👉 Lesson 5 VBA Logical Operators - AND, OR, NOT
👉 Lesson 6 VBA IF else condition
👉 Lesson 7 VBA Loop
👉 Lesson 8 VBA custom filter
👉 Lesson 9 VBA file dialog
👉 Lesson 10 VBA worksheet function
👉 Lesson 11 VBA Projects
👉 Lesson 12 VBA Split function
👉 Lesson 13 VBA Active x and form controls
👉 Lesson 14 VBA Userform
👉 Lesson 15 VBA Text function (Example-Replace/Trim/Left/Right/mid/find etc)
👉 Lesson 16 VBA with external data base(Ms Access & SQL Server)
👉 Lesson 17 VBA with Microsoft Outlook
👉 Lesson 18 VBA with Microsoft Power point
👉 Lesson 19 VBA with Microsoft Word
👉 Lesson 20 VBA with Pivot tables
👉 Lesson 21 VBA Interview questions.
Advance VBA
👉 Lesson 22 VBA Array
👉 Lesson 23 VBA UDF function
👉 Lesson 24 VBA Dictonary
👉 Lesson 25 VBA Collection
👉 Lesson 26 VBA Error Handling
👉 Lesson 27 VBA Events
👉 Lesson 28 VBA crawling
👉 Lesson 29 VBA Projects
👉 Lesson 30 VBA Interview questions.
how to convert excel table into pdf file
Sub BrowseFile()
Dim fd As FileDialog
Dim strpath As String
Set fd = Application.FileDialog(msoFileDialogFilePicker)
With fd
.Title = "Select Excel file"
.Filters.Add "Excel File", "*.xlsx"
If .Show = True Then
strpath = .SelectedItems(1)
End If
End With
Sheet1.Range("E5").Value = strpath
End Sub
Sub CopyData()
Dim wkb As Workbook
Dim varData As Variant
Set wkb = Workbooks.Open(Sheet1.Range("E5").Value, ReadOnly:=True)
varData = wkb.Sheets(1).Range("A1").CurrentRegion.Value
Sheet2.Range("A1").Offset(1, 0).ClearContents
Sheet2.Range("A1").Resize(UBound(varData, 1), UBound(varData, 2)) = varData
wkb.Close savechanges:=False
Call ConvertDataInto_PDF
End Sub
Sub ConvertDataInto_PDF()
Dim path As String
Dim sh As Worksheet
Dim flpath As String
Set sh = ThisWorkbook.Sheets("data")
flpath = "pdf-" & Format(Date, "dd-mm-yy") & ".pdf"
path = ThisWorkbook.path & "\"
sh.ExportAsFixedFormat xlTypePDF, path & flpath, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintareas:=False, openAfterPublish:=False
MsgBox "PDF has been exported", vbInformation
End Sub
Переглядів: 93
Відео
How to insert rows dynamically using vba code
Переглядів 912 роки тому
How to insert rows dynamically using vba code.
How to extract unique record using vba array#vba #excel #technology
Переглядів 1352 роки тому
How to extract unique record using vba array
How to create the master sheet from multiple workbooks using VBA #vba #vba #macro
Переглядів 592 роки тому
How to create the master sheet from multiple workbooks using VBA
How to fill unique record in combo & list box using collection VBA
Переглядів 292 роки тому
How to fill unique record in combo & list box using collection VBA
How to add unique record in list box using array dictionary
Переглядів 502 роки тому
How to add unique record in list box using array dictionary
How to fill active x combo box using vba dictionary
Переглядів 862 роки тому
How to fill combo box using vba dictionary
Split filter data within the workbook with separate sheets
Переглядів 772 роки тому
Split filter data within the workbook with separate sheets
SQL Insert Query
Переглядів 162 роки тому
The INSERT INTO statement is used to insert new records in a table
SQL Create DB Table using query Part2
Переглядів 142 роки тому
How to create the database and table using SQL Queries.
SQL Introduction Part1
Переглядів 222 роки тому
SQL is a standard language for storing, manipulating and retrieving data in databases.
How to extract the all review details of hotels from google maps using vba
Переглядів 2564 роки тому
web scraping project for google maps using vba code
How to extract html text from website using vba web scraping. #excel #vba #shorts
Переглядів 2,6 тис.4 роки тому
How to extract html text from website using vba
How to do web scraping or crawling using vba
Переглядів 1004 роки тому
How to do web scraping or crawling using vba
How to add unique record in combobox using vba dictionary
Переглядів 3534 роки тому
How to add unique record in combobox using vba dictionary
How to extract unique record using vba dictionary
Переглядів 6114 роки тому
How to extract unique record using vba dictionary
How to use do while an do until loop using vba
Переглядів 364 роки тому
How to use do while an do until loop using vba
How to use for next and for each loop in vba
Переглядів 594 роки тому
How to use for next and for each loop in vba
How to create pivot table using vba code
Переглядів 1884 роки тому
How to create pivot table using vba code
How to works with loop using excel vba
Переглядів 394 роки тому
How to works with loop using excel vba
How to create hyperlinks for all sheets using vba
Переглядів 984 роки тому
How to create hyperlinks for all sheets using vba
How to rename the multiple sheets name using vba
Переглядів 1814 роки тому
How to rename the multiple sheets name using vba
How to highlight the all duplicate cells using excel vba
Переглядів 584 роки тому
How to highlight the all duplicate cells using excel vba
How to get unique record using advance filter in vba
Переглядів 344 роки тому
How to get unique record using advance filter in vba
How to remove the duplicates values using excel vba
Переглядів 204 роки тому
How to remove the duplicates values using excel vba
How to highlight blank cell using excel vba
Переглядів 6084 роки тому
How to highlight blank cell using excel vba
How to create data validation using vba code
Переглядів 8774 роки тому
How to create data validation using vba code
very helpful thank you
BTW! do you have a short and precise way just to update things (Charts) from excel into powerpoint?
Yes, please
why this line "pptpress.Slides(1).Shapes("Table 3").Table.Cell(r, c).Shape.TextFrame.TextRange.Text = Sheet1.Cells(r, c).Text" give me this error: "wrong number of arguments or valid property assigment" an then will selected "Shpaes" on "pptpress.Slides(1).Shapes..............."
Its amazing thanks
This is amazing way to compile the sheets
Nicely done and thanks for sharing. FYI, I saved a copy of your code but added + 1 to the row resize as it doesn't account for zero based indexing (wasn't writing the last item in the array to the range starting in D2). Sub Split_Cell() Dim dst As Variant dst = VBA.Split(Sheet1.Range("A1").Value, Chr(10)) Sheet1.Range("D2").Resize(UBound(dst, 1) + 1, 1) = Application.Transpose(dst) End Sub
🙏 Thanks !
Thanks 👍
this works
Hi there, Would you also be able to code and remove blanks and or duplicates from the list? Thanks!
GIVING ERROR USER DEFINED TYPE NOT DEFINED PLZ HELP
Hi, please make a session on searchable and uniqie combobox .
Already uploaded friend
please make it as searchable also
Hi, what about sorting the Date from Excel first then exporting the report to Word and then renaming the new Word report to a format of that same date. can you help?
can you help me how to ignore blanck cell in list for unique record it is not count data after blank cell
Yes you can apply if condition after for loop to ignore the blank cell.
Super duper tutorial 😍😍😍
Thank you so much 😀
Thank you so much
I am facing error in 6th line sir. Please help.
Sorry bro i did see your query. How can i help you now
After many hours searching this simple solution is the only one that works - would suggest sharing on some forums to answer others who had similar issues as mine. Thank you, Akash!
how do I do it by name instead of class name?
Thanks its nice but you can use collection it's very easy and hastle free.
I am getting an issue " shp = pptpress.Slides(3).Shapes(pptpress.Slides(3).Shapes.Count).Name" how to fix this? Please help
Very good tutorial. Would you like to send the file to me, please? Here is my email: tulistulus19@gmail.com
Great job. please make a video to extract companies data from Google map like that reviews you extracted. Thanks. looking forward to next video
Good keep it up..
Useful video...tnx
Thank you
Amazing and very useful Wait for next video🙏🙏🙏
Yes you can mentioned this project in your resume...
Gud video
Nyc
🙏🙏🙏🙏
Nyc
This video very useful for me
Thank you.
Very helpful video ...
Nice video sir
Thank you Ritesh.
Gud
Very gud
Gud
Thank you
Keep it up
Gud
Thanks
Nice job 👍👍 bro
Thank you bro
Gud
Good..keep it up👍👍👍
Thanks
Good keep it up bro...👍👍👍
Very gud video
Nyc
Gud h
Doing well
Gud
Voice is not clear sir ji....
Hlo sir
yes tell me