Sir can you please make a video for same automation but the result must be in excel i.e excel sheet(workbook) to excel result(.eslx) files ....' This video with your best logic is awesome in whole youtube Thanks alot
Thanks so much for this resourceful video. I however a little query. What if you want to populate all data in one document just like what mailmerge does.
Thankyou very much its very useful, here is my query,is it possible if i dont want to save different ms word file ,i want add page like mail merge if yes then pls share video on this.
Awesome. This makes me think about using your method to prepare my marksheet. Please bear with me. If I have any problems I might ask for your help. I s that okay with you?
Really very Help full. But have a Question Please. I am very thankful to you if you help me. If we want to create all the records in a Single Sheet. How i can create all the result cards of a Class in Single sheets, Thanks
Once the marksheet has been generated, is there a way the marks can be changed automatically if i change the value in the excel file. Thank you for the video, great presentation and delivery.
Hello Sir Your information was very good. I want to ask you is there a way to transfer data or text stores in Excel to Word automatically. For example, if I want to automatically paste some text on ms word using some code like abc or 123 Nd hit enter then that text stored in Excel wil auto populate in ms word. If yes, then can u explain me by giving steps and any referencing videos r there related to my inquiry please do provide them. Please reply to my message
Thx for the unconditional share of skills! However, just a little question , is it possible to input VB codes in a word document to open an excel file to extract data from the excel? Since I have a word template that needs to grab data from several excels, will it be a good idea to have the doc as the main control point? Thanks very much for the reply !
Hi! Thankyou for the templates of the excel, specially the "Automated Data Entry User form". I have a question, I have been encountering a problem with "Automated Student Mark Sheet". Every time I press "Prepare Marksheet", it always shows an error "Run-time error '91' (Object Variable or With block variable not set). Whenever I debug it, it highlights this line of code "wd.Selection.GoTo What:=wdGoToBookmark = 1, Name:="SQL_Result". Any tips/solution with this one?
hello brother it is showing error [ runtime error 91 object variable or with block variable not set] on line [ wd.Selection.GoTo what:=wdGoToBookmark, Name:="Prezracevanje"] any suggestion? it would really help. thanks in advance
Hello everyone I used the exact same code but when I try to run the code returns Run time error 91 at the section of adding the bookmarks. Does anyone know what is happening? thank you very much!
Hi, where you have you subject headings I have the names and where you have the names of students I have the subjects. How would the coding change for that?
Great Video and thanks a lot first of all. I followed your instructions and after click on the 'Generate' button i get an message 'MS Excel is waiting for another application to complete an OLE action.' and the letters are not created. can you help?
Hi, I am getting an error when I send the workbook to a different location. I created three different documents (i.e. 3 different modules from 3 different excel sheets/tables) using your above codes. Any idea why this might be happening? It says that the file is corrupted when I open it at a different folder location. I tried to truobleshoot for days but I am not sure why it's happening. Thank you for your help!
Hello Data Labs, Kindly make one Tutorial on Payment Received by anyone and how much Payment is due on hem/her automatically calculated and save the data on excel with the help of VBA.
@@thedatalabs Thanks for your reply, I mean to say that suppose I am a merchant or customer and I had sold or purchased any item at 5000 and my customer or myself give him 2000 adv. and rest of the 3000 amt. due in this condition I want to take all the payment transaction records with the help of VBA on excel and when I feed each and everything with the advanced payment I received or given I will feed the amt. In the total amount of 5000, I got advanced amt. 2000 and due amount automatically calculated by VBA on Excel sheet every time when I feed for the same person amt. I get the amount due record in serial.
I noticed all these questions on the comment - remains un-responded... is there a way for you to hire someone to answer these comments? It would really help your subscribers. thanks.
Hi. Could you help it show error on the: Set wdDoc = we.documents.Open(thisworkbook.pâte & “ ame of my file.docx“) and i don’t understand Where is my mistake
Hi I followed your code but I get a syntax error and compile error on this line. wdDOC.SaveAs2(ThisWorkbook.Path & "\" & "sh.Range("A'' & iRow).Value & "\".Docs")
You are a life saver me.
I had 1500 data. Thanks for helping god bless u. Subscribed
Justo lo que buscaba, muchas gracias!! Suscrita y Like!
Thank you so much for this step by step tutorial! It was comprehensive and you made it simple to follow. Appreciate your kindness :)
The best tutorial in the world!!!! 🔥🔥🔥 thank you !
Neat, clean and concise lecture. You are very kind and generous. Thank you!
Thanks a lot, Sir
Really Awesome way to work easy.
Again Thanks
What an explanation brother! Great video! God bless you
Glad you liked it! Thanks!
You saved an hour daily for me and my team❤️
thanks pal! for this bookmark approach.. good to learned more:) may share yr thts, if compare to mail merge.. each pros and cons..
Beautiful piece of coding. Great lesson for me. Thank you.
I loved your video man. Your explanation and the way you narrated is too good. Thanks for sharing this video.
Hey dude your code worked for me thank you so much it helped aa lot
Thanks of Sharing, One question If we want to generate in one signle Doc file what code changes need to do?
thank you so much. allow me to copy your genius tricks
Perfect tutorial, thumbs up. :)
You guys are really awesome
Thanks again
thank you for the interesting video. I like your tutorials! greetings from Rwanda.
very simple and fantastic tips
Excellent 👌
Sir can you please make a video for same automation but the result must be in excel i.e excel sheet(workbook) to excel result(.eslx) files ....'
This video with your best logic is awesome in whole youtube
Thanks alot
great video!thank you
I have been using mail merge option but i am thinking this method will prove faster for me, Thank-You🙏
Thank you so much for this video
nice work again thanks
Thanks so much for this resourceful video. I however a little query. What if you want to populate all data in one document just like what mailmerge does.
Thankyou very much its very useful, here is my query,is it possible if i dont want to save different ms word file ,i want add page like mail merge if yes then pls share video on this.
It's so so nice information thanks sir
Awesome. This makes me think about using your method to prepare my marksheet. Please bear with me. If I have any problems I might ask for your help. I s that okay with you?
Initially got the debug error but simply added the ".docx" at the end of my filename then it worked great!
Thanks a lot ! Perfect
Very nice sir ji please upload this type of project
How do I change the coding that I will only save the last entry in the database to the word doument and not all the entry's ?
Really very Help full. But have a Question Please. I am very thankful to you if you help me. If we want to create all the records in a Single Sheet. How i can create all the result cards of a Class in Single sheets, Thanks
Once the marksheet has been generated, is there a way the marks can be changed automatically if i change the value in the excel file. Thank you for the video, great presentation and delivery.
Hello Sir
Your information was very good. I want to ask you is there a way to transfer data or text stores in Excel to Word automatically. For example, if I want to automatically paste some text on ms word using some code like abc or 123 Nd hit enter then that text stored in Excel wil auto populate in ms word. If yes, then can u explain me by giving steps and any referencing videos r there related to my inquiry please do provide them.
Please reply to my message
Thx for the unconditional share of skills! However, just a little question , is it possible to input VB codes in a word document to open an excel file to extract data from the excel? Since I have a word template that needs to grab data from several excels, will it be a good idea to have the doc as the main control point? Thanks very much for the reply !
awesome , Thanks
Do you have the code text with you. So that it will be helpful to practise and play around
Hi! Thankyou for the templates of the excel, specially the "Automated Data Entry User form". I have a question, I have been encountering a problem with "Automated Student Mark Sheet". Every time I press "Prepare Marksheet", it always shows an error "Run-time error '91' (Object Variable or With block variable not set). Whenever I debug it, it highlights this line of code "wd.Selection.GoTo What:=wdGoToBookmark = 1, Name:="SQL_Result". Any tips/solution with this one?
even I'm getting the same error... any solution found??
@@bennetvinir24ee89 even I'm getting the same error... any solution found??
hello brother it is showing error [ runtime error 91 object variable or with block variable not set] on line [ wd.Selection.GoTo what:=wdGoToBookmark, Name:="Prezracevanje"] any suggestion? it would really help. thanks in advance
same happened with me
same issue
Same for me!
Same here!
Hi Bro, please make other Videos as well on Topics Range, Selection, Bookmarks, in details..
Can som` help to chage this VBA code, to create a one sheet? (idea behind is to create for 1 filtered line word document) ???
Nice ❤ I did not know that you can assign macros to shapes :) I ve been using buttons from the developer tab all the time 😅
Thanks for your feedback!
Hello everyone I used the exact same code but when I try to run the code returns Run time error 91 at the section of adding the bookmarks. Does anyone know what is happening? thank you very much!
i found the same error. did you found any solution?
Hi, where you have you subject headings I have the names and where you have the names of students I have the subjects. How would the coding change for that?
did you have the exact vba code for this ? same problem the file name of excel copy the file name where the macro located
Great Video and thanks a lot first of all. I followed your instructions and after click on the 'Generate' button i get an message 'MS Excel is waiting for another application to complete an OLE action.' and the letters are not created. can you help?
Hi wonderful work,how we can save each row (students marksheet) in single pdf file instead seperate files for students.
What if i were to save the generate file into a specific folder?
Hello it's useful have created but just indicating marksheet created but not traferred to word document kindly assst....thanks
Hi, Im trying to fill a bookmark in my header and footer, but i cannot seem to accomplish this! can somebody please help me
did it work with you ?
perfect !
Can we update mail merged document with live status change in excel automatically. If yes pls tell how
Please how did you create this beautiful table
Sir error occurred when click on marksheet in 2nd line codding Microsoft word library active ok
Thank you for this toto. Please is there a code to generate pdf files instead of word files ?
I think you can change the extension to .pdf instead of .docx during the step of wdDOC.SaveAs2
Hi, I am getting an error when I send the workbook to a different location. I created three different documents (i.e. 3 different modules from 3 different excel sheets/tables) using your above codes. Any idea why this might be happening? It says that the file is corrupted when I open it at a different folder location. I tried to truobleshoot for days but I am not sure why it's happening. Thank you for your help!
good day sir ..i want to ask ho to put a search bar or button on a data entry form have a databave tnx....:)
Please watch this tutorial. Thanks!
ua-cam.com/video/BdEMj4NNXAE/v-deo.html
Is there any coading for convert ms word data into excel??
Love it. Is the sql_result supposed to be slq? Or is that a typo error?
Please use the bookmark name created in Word. Will check it again and post the changes on our website, if any error found. Thanks!
Hi, did anyone solve the run time error 91: object variable or with block variable not set error? I am really struggling to resolve. Thank you
Did you solve it? I need help there
No@@bonniewinsome8192
How to insert picture into ms word table in this way.please reply
Sir, after all complete, message showing me that "MS excel is waiting for another application to complete an OLE action". What happening Sir?
thaank youuuuu
How to generate all marksheet in the same one document . Please its important
Hi I need a vba code for same file but the output should be in different excel files name wise
did you have the exact vba code for this ? same problem the file name of excel copy the file name where the macro located
how to add print option....Thanks for tutorial from Bangladesh
Will try to add Print features. Thanks!
I followed your tutorial to the end. The marksheets are generated successfully but they are all blank. How do I get over this error.
How to transfer image (in path) from Excel to word
Can we generate all those marksheets in one same document?
Yes
Hey How to generate Pdf files instead of Word
Transfer certificate how make
Please use the same technique to automate certificate as well. Thanks!
HELPFULL
but sir how can i insert qrcode or image with this method
I am getting on error saying 'Microsoft Excel is waiting for other applications to complete OLE" , can you please help to overcome this error
Hello Data Labs, Kindly make one Tutorial on Payment Received by anyone and how much Payment is due on hem/her automatically calculated and save the data on excel with the help of VBA.
Could you please explain the requirement and functionalities in detail? Thanks!
@@thedatalabs Thanks for your reply, I mean to say that suppose I am a merchant or customer and I had sold or purchased any item at 5000 and my customer or myself give him 2000 adv. and rest of the 3000 amt. due in this condition I want to take all the payment transaction records with the help of VBA on excel and when I feed each and everything with the advanced payment I received or given I will feed the amt. In the total amount of 5000, I got advanced amt. 2000 and due amount automatically calculated by VBA on Excel sheet every time when I feed for the same person amt. I get the amount due record in serial.
Anyone in the chat can help me please
how to insert pic???
Link not working
I noticed all these questions on the comment - remains un-responded... is there a way for you to hire someone to answer these comments? It would really help your subscribers. thanks.
Thsnks sir NGO or TRUST 80g income tex format how make ta neya akta video karla valo hato pless sir eta khube prajan sir chesta karban pless
Excel application showing ole automation
dear sir same invoice data multipal item invoicenumber genret invoice templet word next video thanks
please helf
Sir one file multipal marksheet one by one page code
very nice code. but even at 2x speed it is very very slow. very long video.
Dear Sirji Apaka contact Number milega. Hume ek application banana hai
sir amar kano comments kano utter palam na
Toda jor se bath karo bhai, why so low voice.
sir pless apnar mobile no ta pata pari
Iterate under a fucking loop
Hi. Could you help it show error on the: Set wdDoc = we.documents.Open(thisworkbook.pâte & “
ame of my file.docx“) and i don’t understand Where is my mistake
Set wdDOC = wd.Documents.Open(ThisWorkbook.Path & "\Marksheet Template.docx")
Hi I followed your code but I get a syntax error and compile error on this line. wdDOC.SaveAs2(ThisWorkbook.Path & "\" & "sh.Range("A'' & iRow).Value & "\".Docs")
I m doing the same procedure for one of my projects but bookmark is getting deleted every time by default please help