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

Поділитися
Вставка
  • Опубліковано 1 лис 2024

КОМЕНТАРІ • 77

  • @AhnafLive
    @AhnafLive Рік тому +1

    You are Really Expert In VBA Sir. I Believe it sir

    • @vbAFun
      @vbAFun  Рік тому

      Thank you ❤️ keep watching and sharing

  • @sengarms
    @sengarms 6 місяців тому +2

    Sir your are Great in Excel vba . Keep it up🙏🏻

    • @vbAFun
      @vbAFun  6 місяців тому

      Thank you

  • @MohAboAbdo
    @MohAboAbdo Рік тому +1

    Thank you very much, my dear teacher, for this wonderful video and this valuable informations

    • @vbAFun
      @vbAFun  Рік тому +1

      I appreciate and thank you for like and share

  • @aldurrtree
    @aldurrtree Рік тому +1

    you are genius
    Hats off to you

    • @vbAFun
      @vbAFun  Рік тому +1

      Thank you ❤️

  • @ashoksahu9546
    @ashoksahu9546 Рік тому +1

    Waooooo. Thank you so much sir. Very useful video. You are great.

    • @vbAFun
      @vbAFun  Рік тому

      Thank you ❤️

  • @rajatgupta180
    @rajatgupta180 Місяць тому

    Thankyou so much❤❤

  • @diya2909
    @diya2909 Рік тому +1

    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 😉

  • @dailyquranrecitationhd4509
    @dailyquranrecitationhd4509 Рік тому +1

    thanks alot sir....I need it in my school management system....

    • @vbAFun
      @vbAFun  Рік тому

      Thank you ❤️ keep watching and sharing

  • @abdulsalam935
    @abdulsalam935 Рік тому

    Sir simply SUPERB. Thank you.

  • @k.k.sabariraj6484
    @k.k.sabariraj6484 9 місяців тому +1

    Thanks lot ❤ bro frm madurai tamilnadu

    • @vbAFun
      @vbAFun  9 місяців тому

      Welcome

  • @aqeelahmad3652
    @aqeelahmad3652 Рік тому +1

    Thanks I'll see
    Hope it's also useful

  • @intakhabkhan9649
    @intakhabkhan9649 Рік тому +1

    You're great sir, superb video.

    • @vbAFun
      @vbAFun  Рік тому

      Thank you ❤️ keep watching and sharing

  • @excelshambhu
    @excelshambhu Рік тому +1

    Very nice trick 👍👍👍👍

    • @vbAFun
      @vbAFun  Рік тому

      Thank you ❤️

  • @larrychan1314
    @larrychan1314 5 місяців тому

    very useful, how about update objects from excel to word?

  • @gkornament
    @gkornament Рік тому +1

    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

  • @pradeepbeherag.3418
    @pradeepbeherag.3418 Рік тому +1

    Thanks sir, problem solve ho geia

  • @pintuchoyan9526
    @pintuchoyan9526 Рік тому +1

    Salute sir, great job

    • @vbAFun
      @vbAFun  Рік тому

      Thank you ❤️

  • @afrinsir7479
    @afrinsir7479 Рік тому +1

    very nce
    but when will you upload carry forward value of video

    • @vbAFun
      @vbAFun  Рік тому

      Keep watching will upload one by one

  • @praveenkumar-fz3er
    @praveenkumar-fz3er 3 місяці тому

    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

  • @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 Рік тому +1

    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  Рік тому +1

      Feb se kar raha hun, Saturday ko video me announce bhi karunga

  • @sabesana1314
    @sabesana1314 Рік тому

    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

  • @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 UA-cam. 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

  • @AzmatAliShah-y2s
    @AzmatAliShah-y2s 9 місяців тому +1

    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  9 місяців тому

      Yes you just change the cell format

    • @AzmatAliShah-y2s
      @AzmatAliShah-y2s 9 місяців тому

      @@vbAFun I meant, i want to export amount in MS Word with this format "$2,500.00".

    • @vbAFun
      @vbAFun  8 місяців тому

      Yes that can be done

    • @vbAFun
      @vbAFun  8 місяців тому

      @@AzmatAliShah-y2s hi that is why I said see I used standard format if you want with solar sign add in transfer value and do

  • @AhnafLive
    @AhnafLive Рік тому +2

    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 🙏

  • @blmo3389
    @blmo3389 Рік тому +1

    Hello Sir..how to contact with you..about small vba project.

    • @vbAFun
      @vbAFun  Рік тому

      Hi, please contact me on instagram

  • @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?

  • @shaileshsharma668
    @shaileshsharma668 Рік тому

    I want To send word file contents in outlook body with same format

  • @rahulvishwakarma2119
    @rahulvishwakarma2119 6 місяців тому

    you can add This vba in mail mege ?

  • @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  Рік тому +1

      Just change the formate in the loop with condition or don't use loop

    • @syedshahzaibali4729
      @syedshahzaibali4729 Рік тому

      @@vbAFun how to change the format

    • @vbAFun
      @vbAFun  Рік тому +1

      Hi see check the column now of row in word table and after column loop you set value with formate function

  • @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

  • @mathematicsclasseasyway9250
    @mathematicsclasseasyway9250 Рік тому +1

    सर इस पीडीएफ फाइल को सभी के मेल में भी
    सेंड हो जाता तो अच्छा 🙏🙏🙏🙏🙏🙏

    • @vbAFun
      @vbAFun  Рік тому

      Iske liye just outlook ko configure kar lijiye honjayega

  • @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 ?

  • @cggamer4779
    @cggamer4779 11 місяців тому

    Advance search kese kare sir

  • @rahulvishwakarma2119
    @rahulvishwakarma2119 6 місяців тому

    Sir ye sare latter sabhi ko mail ja sakta hai ek sath

  • @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

  • @sschannelbd7352
    @sschannelbd7352 11 місяців тому

    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  11 місяців тому +1

      Okay, so wait for some time in my previous video one code is missing will update soon

    • @sschannelbd7352
      @sschannelbd7352 11 місяців тому +1

      Thanks for reply sir. If possible please update soon.

  • @arjunspata1913
    @arjunspata1913 Рік тому

    🙏 sir
    Sir ye jo ap bolte hai n.
    Uska text display nahi hone digiye sir.

    • @vbAFun
      @vbAFun  Рік тому

      Matlab aap caption ke bare me bol rahe hai to aap caption off kar dijiye

  • @richardbrobbey2512
    @richardbrobbey2512 Рік тому +1

    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