Тёмный

How to Generate Dynamic Letter in Word when excel vba use? | Saveas in Word and PDF File 

vbA Fun
Подписаться 20 тыс.
Просмотров 8 тыс.
50% 1

How to Generate Dynamic Letter in Word when excel vba use? | Saveas in Word and PDF File
Today video is very important who want to word automation using vba where excel vba using. You can also learn how to use word vba in microsoft word as well as how to close word file, open word file and saveas without overwrite prompt in excel vba.
Hightlight of this video :
Add Table Row in word using excel vba
Add Data in Table row using excel vba
Save as word file with client name
Generate PDF File from Word with Excel vba
Download Free Practice File : drive.google.com/file/d/1VUvu...
Our Aim to Develop Skill in Excel :
=============================
Excel Userform Development
Excel Vba Projects
Advance Excel vba
Advance Excel Userform
Advance Microsoft Excel
Excel Software Development
Excel vba UDF (User defined function)
=============================
Join this channel to get access to perks:
===============================
/ @vbafun
===============================
About Excel vba
=================================
Excel VBA is a very useful programming language where you can do your work very smartly and this language is very simple to use. From this channel, you will learn how to simplify your code in excel VBA to automate your sheet for daily routine work as well as will teach you how to create an application in excel VBA to make automate the excel sheet like data entry, invoice, keeping a record of data. Maintain Stock and inventory, Student Management, School Managment and many more excel application which uses in each and every offices and school.
=================================
Never Seen Before Playlist in Excel Vba :
==================================
• Never Seen Before Tricks
==================================
Other excel vba training Video :
==================================
School Manager - Student Admission, Student Receipt, School Software
• School Manager Pt 1 | ...
Small Business Applications - sale/purchase/inventory
• Small Business Applica...
Employee Manager
• Employee Manager
School manager in excel
• School Manager
DatePicker in excel
• DatePicker
Advance Data Entry Software in excel
• Advance Data Entry App...
PoS in Excel with Image Control
• PoS with Image Control
PoS in Excel
• PoS ( Point of Sale) i...
===================================
Our Social Media Contact :
===================================
Facebook : profile.php?...
Instagram : / vbafun.ajay
Facebook Group : / 264521978273573
Facebook Page : / excelapplicationvbafun
Twitter : / ajaypreetam
====================================
Disclaimer :
=====================================
Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'Fair Use' for purposes such as criticism, comment, news reporting, teaching, scholarship, and research, Fair use is a permitted by copyright statute that might otherwise be infringing, Non-profit, educational or personal use tips the balance in favor of fair use
=====================================
#ExcelApplication #excelvba #userform #MSAccess #MsExcel

Опубликовано:

 

17 янв 2023

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 76   
@sengarms
@sengarms 3 месяца назад
Sir your are Great in Excel vba . Keep it up🙏🏻
@vbAFun
@vbAFun 3 месяца назад
Thank you
@MohAboAbdo
@MohAboAbdo Год назад
Thank you very much, my dear teacher, for this wonderful video and this valuable informations
@vbAFun
@vbAFun Год назад
I appreciate and thank you for like and share
@ashoksahu9546
@ashoksahu9546 Год назад
Waooooo. Thank you so much sir. Very useful video. You are great.
@vbAFun
@vbAFun Год назад
Thank you ❤️
@diya2909
@diya2909 Год назад
Again Very Awesome video sir, I am very thankful that you made this video on my demand. Thanks sir
@vbAFun
@vbAFun Год назад
Thank you very much please like and share and i also create new thing if some one demand 😉
@aqeelahmad3652
@aqeelahmad3652 Год назад
Thanks I'll see Hope it's also useful
@abdulsalam935
@abdulsalam935 Год назад
Sir simply SUPERB. Thank you.
@vbAFun
@vbAFun Год назад
Thank you
@intakhabkhan9649
@intakhabkhan9649 Год назад
You're great sir, superb video.
@vbAFun
@vbAFun Год назад
Thank you ❤️ keep watching and sharing
@gkornament
@gkornament Год назад
Sir apka jo graphic design coding Kiya muje bahoti acha laga, Keya sir aapne mere liye jewellery GST invoice software customise karke bana sakte he,
@vbAFun
@vbAFun Год назад
Yes, please contact me on instagram
@k.k.sabariraj6484
@k.k.sabariraj6484 6 месяцев назад
Thanks lot ❤ bro frm madurai tamilnadu
@vbAFun
@vbAFun 6 месяцев назад
Welcome
@excelshambhu
@excelshambhu Год назад
Very nice trick 👍👍👍👍
@vbAFun
@vbAFun Год назад
Thank you ❤️
@pintuchoyan9526
@pintuchoyan9526 Год назад
Salute sir, great job
@vbAFun
@vbAFun Год назад
Thank you ❤️
@aldurrtree
@aldurrtree Год назад
you are genius Hats off to you
@vbAFun
@vbAFun Год назад
Thank you ❤️
@larrychan1314
@larrychan1314 2 месяца назад
very useful, how about update objects from excel to word?
@praveenkumar-fz3er
@praveenkumar-fz3er 16 дней назад
Agr muje apne excel se hi table copy kr k word file m ek specific jgh pe paste krna ho autofit to window k sath so usko kaise use krenge vba code
@pradeepbeherag.3418
@pradeepbeherag.3418 Год назад
Thanks sir, problem solve ho geia
@vbAFun
@vbAFun Год назад
Thank you
@dailyquranrecitationhd4509
@dailyquranrecitationhd4509 Год назад
thanks alot sir....I need it in my school management system....
@vbAFun
@vbAFun Год назад
Thank you ❤️ keep watching and sharing
@afrinsir7479
@afrinsir7479 Год назад
very nce but when will you upload carry forward value of video
@vbAFun
@vbAFun Год назад
Keep watching will upload one by one
@fingercross4313
@fingercross4313 Год назад
Sir Pranam, Very nice video. Per kal se wait kr raha tha ki meri request pr video upload karenge aaj aap. Aapne bola tha jaisa Regards
@vbAFun
@vbAFun Год назад
Table me data save karne bala right yad hai jald upload karunga
@AhnafLive
@AhnafLive Год назад
Kon Kon VBA Series Sikhna Chata he Sir Se? Ham Sir Request Karte He ke please step by step Ham Ko VBA Coding Sikha Ye. Please 🙏
@AhnafLive
@AhnafLive Год назад
Hello Sir Aap Ham Ko Bata Dijiye Ke Kab Se Aap VBA Coding Ka Course Shuru Kar Ne Vale He. Please Sir I'm Interested in your teaching us.
@vbAFun
@vbAFun Год назад
Feb se kar raha hun, Saturday ko video me announce bhi karunga
@sabesana1314
@sabesana1314 11 месяцев назад
Sir, while this is working. Need all the generated document as a single file instead of each single document. Thanks to help in the present coding itself
@shaileshsharma668
@shaileshsharma668 11 месяцев назад
I want To send word file contents in outlook body with same format
@AhnafLive
@AhnafLive Год назад
You are Really Expert In VBA Sir. I Believe it sir
@vbAFun
@vbAFun Год назад
Thank you ❤️ keep watching and sharing
@nassimgaming4948
@nassimgaming4948 Год назад
Hello sir . When i write dim x as word. The (. application) don't appear. Even i write manuamly it says object error. Even in activate the office extension. How to fix plz?
@cggamer4779
@cggamer4779 8 месяцев назад
Advance search kese kare sir
@sharadmore2302
@sharadmore2302 Год назад
Hello, Sir! Your video is fantastic!! However, I have a somewhat different requirement. In my case, we need to copy multiple tables (table1, table2, table3, and so on) from excel into a specific location in the word template (e.g. table1 on page 10, table2 on page 12, and so on) without pre-deining table structure in word file and it directly copy table available in excel along with selection and paste location. Also, if I want to exclude any table, i should be able to do it. I couldn't find a similar video on RU-vid. It would be fantastic if you could create something on it. Thank you in advance.
@vbAFun
@vbAFun Год назад
I understand your query but for better understanding can you share some template image on instagram because this is some interesting question.
@sharadmore2302
@sharadmore2302 Год назад
@@vbAFun I appreciate your response, Sir, but because I don't use Instagram, I won't be able to share it with you, but I will email you my requirements along with a template because the requirements include a few permutations and combinations. I hope this will work for your.
@sabesana1314
@sabesana1314 Год назад
Sir I just did same example .am getting error stating object variable not found error91. Thanks to help
@rahulvishwakarma2119
@rahulvishwakarma2119 3 месяца назад
you can add This vba in mail mege ?
@mathematicsclasseasyway9250
सर इस पीडीएफ फाइल को सभी के मेल में भी सेंड हो जाता तो अच्छा 🙏🙏🙏🙏🙏🙏
@vbAFun
@vbAFun Год назад
Iske liye just outlook ko configure kar lijiye honjayega
@HeartTouchingrs
@HeartTouchingrs Год назад
Sir...esi me continued image add Krna ho to koun se code lagana hoga plss continued....
@vbAFun
@vbAFun Год назад
Matlab ke last column me picture add karna hai
@mshahneelsajid147
@mshahneelsajid147 Год назад
Sir i have month and year picker form in access now i want to create procedure in form to transfer selected month and year in called textbox via vba code Plz help I will wait for your reply.
@vbAFun
@vbAFun Год назад
As i understand you want transfer data from file as per your month and year right, ? But i could not understand what data you want transfer ?
@blmo3389
@blmo3389 Год назад
Hello Sir..how to contact with you..about small vba project.
@vbAFun
@vbAFun Год назад
Hi, please contact me on instagram
@user-xm9yw5lq3t
@user-xm9yw5lq3t 6 месяцев назад
Sir, is there any way to format the 'Amount' column with a $ sign and ',' separator in Word so that I get results like this, e.g., $2,500.00?
@vbAFun
@vbAFun 6 месяцев назад
Yes you just change the cell format
@user-xm9yw5lq3t
@user-xm9yw5lq3t 6 месяцев назад
@@vbAFun I meant, i want to export amount in MS Word with this format "$2,500.00".
@vbAFun
@vbAFun 6 месяцев назад
Yes that can be done
@vbAFun
@vbAFun 6 месяцев назад
@@user-xm9yw5lq3t hi that is why I said see I used standard format if you want with solar sign add in transfer value and do
@syedshahzaibali4729
@syedshahzaibali4729 Год назад
Good technique sir, lekin data word main export hone ke baad number formating kaise hogi. I mean amount has to be like 45,000.00 not like 45000 and date format also.
@vbAFun
@vbAFun Год назад
Just change the formate in the loop with condition or don't use loop
@syedshahzaibali4729
@syedshahzaibali4729 Год назад
@@vbAFun how to change the format
@vbAFun
@vbAFun Год назад
Hi see check the column now of row in word table and after column loop you set value with formate function
@sschannelbd7352
@sschannelbd7352 8 месяцев назад
Sir, when i have run the after set Wdoc an error massage has occurred run time error 5174, how can i solve this?
@vbAFun
@vbAFun 8 месяцев назад
Okay, so wait for some time in my previous video one code is missing will update soon
@sschannelbd7352
@sschannelbd7352 8 месяцев назад
Thanks for reply sir. If possible please update soon.
@pradeepbeherag.3418
@pradeepbeherag.3418 Год назад
Sir Namaskar, mee coding kia but hua nehi. How to solve the problem. Data transfer hota nehi
@vbAFun
@vbAFun Год назад
Jarur hoga thoda carefully code ko dekhiye kahi koi spelling mistake to nahi hai variable me ya code to nahi chhutha hua hai
@rahulvishwakarma2119
@rahulvishwakarma2119 3 месяца назад
Sir ye sare latter sabhi ko mail ja sakta hai ek sath
@vbAFun
@vbAFun 3 месяца назад
Yes
@arjunspata1913
@arjunspata1913 11 месяцев назад
🙏 sir Sir ye jo ap bolte hai n. Uska text display nahi hone digiye sir.
@vbAFun
@vbAFun 11 месяцев назад
Matlab aap caption ke bare me bol rahe hai to aap caption off kar dijiye
@richardbrobbey2512
@richardbrobbey2512 Год назад
Can please speak English so l can also follow
@vbAFun
@vbAFun Год назад
Oh so sorry i thinkni forgot to enable subtitle, i will enable today
@pradeepbeherag.3418
@pradeepbeherag.3418 Год назад
Sir naskar. Sume error arrise in this coding. Please give me whatapp no. For sending my files. I hope please help me
Далее
ПОМОГЛА НАЗЫВАЕТСЯ😂
00:20
Просмотров 2,5 млн
Редакция. News: 128-я неделя
57:33
Просмотров 2 млн
LINKING DATA FROM EXCEL TO WORD || EXCEL
4:13
Просмотров 22 тыс.
ПОМОГЛА НАЗЫВАЕТСЯ😂
00:20
Просмотров 2,5 млн