You are a life saver me. I had 1500 data. Thanks for helping god bless u. Subscribed
@yaninasoroka2014
2 жыл бұрын
The best tutorial in the world!!!! 🔥🔥🔥 thank you !
@mixietan
2 жыл бұрын
Thank you so much for this step by step tutorial! It was comprehensive and you made it simple to follow. Appreciate your kindness :)
@alposmanagaoglu7352
Жыл бұрын
Neat, clean and concise lecture. You are very kind and generous. Thank you!
@RafiTAHasani
2 жыл бұрын
You saved an hour daily for me and my team❤️
@HammaD.K
4 жыл бұрын
Thanks a lot, Sir Really Awesome way to work easy. Again Thanks
@UGRTechHowTo
3 жыл бұрын
I loved your video man. Your explanation and the way you narrated is too good. Thanks for sharing this video.
@307waseemtariq5
2 жыл бұрын
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
@eborne66
Жыл бұрын
Beautiful piece of coding. Great lesson for me. Thank you.
@barderians
2 жыл бұрын
I have been using mail merge option but i am thinking this method will prove faster for me, Thank-You🙏
@jesusavarimuthuarockiam425
11 ай бұрын
What an explanation brother! Great video! God bless you
@thedatalabs
11 ай бұрын
Glad you liked it! Thanks!
@nateblack972
Жыл бұрын
Initially got the debug error but simply added the ".docx" at the end of my filename then it worked great!
@hicaveman
11 ай бұрын
thanks pal! for this bookmark approach.. good to learned more:) may share yr thts, if compare to mail merge.. each pros and cons..
@deepakdakhore
Жыл бұрын
Thanks of Sharing, One question If we want to generate in one signle Doc file what code changes need to do?
@bluejay12293
2 жыл бұрын
thank you so much. allow me to copy your genius tricks
@arthurquartey1939
Жыл бұрын
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.
@nehadhobale3761
2 жыл бұрын
Hey dude your code worked for me thank you so much it helped aa lot
@pureislam4986
Жыл бұрын
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
@birasafabrice
4 жыл бұрын
thank you for the interesting video. I like your tutorials! greetings from Rwanda.
@nicktobies
4 жыл бұрын
very simple and fantastic tips
@domsavio1409
5 ай бұрын
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.
@salihch3135
4 жыл бұрын
You guys are really awesome Thanks again
@ruffbean8570
Жыл бұрын
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?
@danishmew2873
4 жыл бұрын
nice work again thanks
@prediction2302
4 жыл бұрын
Very nice sir ji please upload this type of project
@filipdopirak5226
Жыл бұрын
Perfect tutorial, thumbs up. :)
@mr.granger9962
6 ай бұрын
What if i were to save the generate file into a specific folder?
@rockfighter9974
Жыл бұрын
Thank you so much for this video
@Aleenaartandcraft
2 жыл бұрын
It's so so nice information thanks sir
@navin298786
Жыл бұрын
Excellent 👌
@TheJassie22
3 жыл бұрын
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 ?
@nickpapas2968
Жыл бұрын
great video!thank you
@aggelosgkouveris2030
3 жыл бұрын
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!
@bilalarshad9502
3 жыл бұрын
i found the same error. did you found any solution?
@paulmucheru3749
2 жыл бұрын
Hello it's useful have created but just indicating marksheet created but not traferred to word document kindly assst....thanks
@G-star6
3 жыл бұрын
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
@bilalarshad9502
3 жыл бұрын
same happened with me
@farooqbukhari5577
2 жыл бұрын
same issue
@mehrezchtourou9135
Жыл бұрын
Same for me!
@magux3617
Жыл бұрын
Same here!
@Vuurrooksmaam
2 жыл бұрын
Hi, Im trying to fill a bookmark in my header and footer, but i cannot seem to accomplish this! can somebody please help me
@waledkhaled5439
10 ай бұрын
did it work with you ?
@KuldeepSingh-nq1vi
Жыл бұрын
Hi Bro, please make other Videos as well on Topics Range, Selection, Bookmarks, in details..
@prediction2302
4 жыл бұрын
Sir error occurred when click on marksheet in 2nd line codding Microsoft word library active ok
@AbdulSalam-ne7ic
2 жыл бұрын
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?
@catherineregnier1521
2 жыл бұрын
Thanks a lot ! Perfect
@kapibara2440
Жыл бұрын
Nice ❤ I did not know that you can assign macros to shapes :) I ve been using buttons from the developer tab all the time 😅
@thedatalabs
Жыл бұрын
Thanks for your feedback!
@balajisanthanam9164
2 жыл бұрын
Do you have the code text with you. So that it will be helpful to practise and play around
@chetanwaghodkar4508
3 жыл бұрын
Can we update mail merged document with live status change in excel automatically. If yes pls tell how
@2001chlaw
3 жыл бұрын
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 !
@indiamoneywise
2 жыл бұрын
Hi wonderful work,how we can save each row (students marksheet) in single pdf file instead seperate files for students.
@magux3617
Жыл бұрын
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?
@bennetvinir24ee89
7 ай бұрын
even I'm getting the same error... any solution found??
@YOGENDERSINGH-gy9nq
27 күн бұрын
@@bennetvinir24ee89 even I'm getting the same error... any solution found??
@KangleiEdufun
8 ай бұрын
How to transfer image (in path) from Excel to word
@EuphonySpot
3 жыл бұрын
did you have the exact vba code for this ? same problem the file name of excel copy the file name where the macro located
@ashwagal-sabaan3783
3 жыл бұрын
awesome , Thanks
@meisam1211
4 жыл бұрын
perfect !
@mielkew27
2 жыл бұрын
Great video, how about adding rows in the word table from excel table?
@reviewsfixeshacksmunsur3805
2 жыл бұрын
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?
@allisonjoyalali2504
3 жыл бұрын
Please how did you create this beautiful table
@hollyx1992
3 жыл бұрын
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
@bonniewinsome8192
2 жыл бұрын
Did you solve it? I need help there
@YOGENDERSINGH-gy9nq
27 күн бұрын
No@@bonniewinsome8192
@vinodvinu4027
2 жыл бұрын
I am getting on error saying 'Microsoft Excel is waiting for other applications to complete OLE" , can you please help to overcome this error
@katel8784
3 жыл бұрын
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!
@shanthabaimothajigari7441
Жыл бұрын
How to insert picture into ms word table in this way.please reply
@tahaelyakoubi1913
3 жыл бұрын
thaank youuuuu
@deepakkhisty9038
Жыл бұрын
I followed your tutorial to the end. The marksheets are generated successfully but they are all blank. How do I get over this error.
@KishanChauhan-yy3kb
4 жыл бұрын
Is there any coading for convert ms word data into excel??
@luisshwekha4666
4 жыл бұрын
Sir, after all complete, message showing me that "MS excel is waiting for another application to complete an OLE action". What happening Sir?
@mouhamadrouabha2676
2 жыл бұрын
Thank you for this toto. Please is there a code to generate pdf files instead of word files ?
@omar-kv9jb
2 жыл бұрын
I think you can change the extension to .pdf instead of .docx during the step of wdDOC.SaveAs2
@user-et9rq8po4g
4 жыл бұрын
how to add print option....Thanks for tutorial from Bangladesh
@thedatalabs
4 жыл бұрын
Will try to add Print features. Thanks!
@jamalarif3104
4 жыл бұрын
HELPFULL but sir how can i insert qrcode or image with this method
@redatafeel
2 жыл бұрын
How to generate all marksheet in the same one document . Please its important
@aleonvc842
4 жыл бұрын
Love it. Is the sql_result supposed to be slq? Or is that a typo error?
@thedatalabs
4 жыл бұрын
Please use the bookmark name created in Word. Will check it again and post the changes on our website, if any error found. Thanks!
@jovenvilla386
3 жыл бұрын
good day sir ..i want to ask ho to put a search bar or button on a data entry form have a databave tnx....:)
@thedatalabs
3 жыл бұрын
Please watch this tutorial. Thanks! kzitem.info/news/bejne/o5p7s55qh4CJdHo
@leocosh
3 жыл бұрын
Hi I need a vba code for same file but the output should be in different excel files name wise
@EuphonySpot
3 жыл бұрын
did you have the exact vba code for this ? same problem the file name of excel copy the file name where the macro located
@1234arun999999
3 жыл бұрын
Hey How to generate Pdf files instead of Word
@rehanali-qr4ld
4 жыл бұрын
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
4 жыл бұрын
Could you please explain the requirement and functionalities in detail? Thanks!
@rehanali-qr4ld
4 жыл бұрын
@@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.
@YummyNation
Жыл бұрын
Anyone in the chat can help me please
@prasenjitmidya5794
4 жыл бұрын
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
@eaasle
2 жыл бұрын
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.
@sourabhbarde4785
8 ай бұрын
Excel application showing ole automation
@shivannahr780
3 жыл бұрын
dear sir same invoice data multipal item invoicenumber genret invoice templet word next video thanks please helf
@prediction2302
4 жыл бұрын
Transfer certificate how make
@thedatalabs
4 жыл бұрын
Please use the same technique to automate certificate as well. Thanks!
@roshanlama5134
4 жыл бұрын
Can we generate all those marksheets in one same document?
@thedatalabs
4 жыл бұрын
Yes
@skdaroch
4 жыл бұрын
very nice code. but even at 2x speed it is very very slow. very long video.
@farooqbukhari5577
2 жыл бұрын
how to insert pic???
@hammirdev7354
2 жыл бұрын
Sir one file multipal marksheet one by one page code
@letschilldude7358
4 жыл бұрын
Link not working
@prasenjitmidya5794
4 жыл бұрын
sir amar kano comments kano utter palam na
@nileshdhaigude3127
4 жыл бұрын
Dear Sirji Apaka contact Number milega. Hume ek application banana hai
@bryanpowell1232
10 ай бұрын
Iterate under a fucking loop
@prasenjitmidya5794
4 жыл бұрын
sir pless apnar mobile no ta pata pari
@laura3hvwws.s.s.s149
Жыл бұрын
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
@mrmissdestiny5953
Жыл бұрын
Set wdDOC = wd.Documents.Open(ThisWorkbook.Path & "\Marksheet Template.docx")
@user-mw1sv9cx9w
9 ай бұрын
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")
@YummyNation
Жыл бұрын
I m doing the same procedure for one of my projects but bookmark is getting deleted every time by default please help
Пікірлер: 112