Fully Automated Student Marks Sheet (Transfer Data from Excel to Word) - A Step By Step Tutorial

[@2009shashikant]

You are a life saver me. I had 1500 data. Thanks for helping god bless u. Subscribed

[@deepakdakhore]

Thanks of Sharing, One question If we want to generate in one signle Doc file what code changes need to do?

[@arthurquartey]

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.

[@julianecoronel164]

Justo lo que buscaba, muchas gracias!! Suscrita y Like!

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

[@saurabh123kush2]

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.

[@7.waseem]

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

[@yaninasoroka2014]

The best tutorial in the world!!!! 🔥🔥🔥 thank you !

[@HammaD.K]

Thanks a lot, Sir Really Awesome way to work easy. Again Thanks

[@hicaveman]

thanks pal! for this bookmark approach.. good to learned more:) may share yr thts, if compare to mail merge.. each pros and cons..

[@mixietan]

Thank you so much for this step by step tutorial! It was comprehensive and you made it simple to follow. Appreciate your kindness :)

[@domsavio1409]

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.

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

[@jesusavarimuthuarockiam425]

What an explanation brother! Great video! God bless you

[@thedatalabs]

Glad you liked it! Thanks!

[@alposmanagaoglu7352]

Neat, clean and concise lecture. You are very kind and generous. Thank you!

[@RafiTAHasani]

You saved an hour daily for me and my team❤️

[@TheJassie22]

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 ?

[@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]

even I'm getting the same error... any solution found??

[@YOGENDERSINGH-gy9nq]

@@bennetvinir24ee89 even I'm getting the same error... any solution found??

[@eborne66]

Beautiful piece of coding. Great lesson for me. Thank you.

[@balajisanthanam9164]

Do you have the code text with you. So that it will be helpful to practise and play around

[@UGRTechHowTo]

I loved your video man. Your explanation and the way you narrated is too good. Thanks for sharing this video.

[@user-sashko]

Can som` help to chage this VBA code, to create a one sheet? (idea behind is to create for 1 filtered line word document) ???

[@nehadhobale3761]

Hey dude your code worked for me thank you so much it helped aa lot

[@barderians]

I have been using mail merge option but i am thinking this method will prove faster for me, Thank-You🙏

[@G-star6]

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]

same happened with me

[@farooqbukhari5577]

same issue

[@mehrezchtourou9135]

Same for me!

[@magux3617]

Same here!

[@mr.granger9962]

What if i were to save the generate file into a specific folder?

[@paulmucheru3749]

Hello it's useful have created but just indicating marksheet created but not traferred to word document kindly assst....thanks

[@2001chlaw]

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 !

[@bluejay12293]

thank you so much. allow me to copy your genius tricks

[@AbdulSalam-ne7ic]

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?

[@EuphonySpot]

did you have the exact vba code for this ? same problem the file name of excel copy the file name where the macro located

[@nicktobies]

very simple and fantastic tips

[@aggelosgkouveris2030]

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]

i found the same error. did you found any solution?

[@nateblack972]

Initially got the debug error but simply added the ".docx" at the end of my filename then it worked great!

[@abcd2-k4s]

Sir error occurred when click on marksheet in 2nd line codding Microsoft word library active ok

[@Vuurrooksmaak-yt]

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]

did it work with you ?

[@indiamoneywise]

Hi wonderful work,how we can save each row (students marksheet) in single pdf file instead seperate files for students.

[@shanthabaimothajigari7441]

How to insert picture into ms word table in this way.please reply

[@salihch3135]

You guys are really awesome Thanks again

[@chetanwaghodkar4508]

Can we update mail merged document with live status change in excel automatically. If yes pls tell how

[@KuldeepSingh-nq1vi]

Hi Bro, please make other Videos as well on Topics Range, Selection, Bookmarks, in details..

[@birasafabrice]

thank you for the interesting video. I like your tutorials! greetings from Rwanda.

[@abcd2-k4s]

Very nice sir ji please upload this type of project

[@reviewsfixeshacksmunsur3805]

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?

[@filipdopirak5226]

Perfect tutorial, thumbs up. :)

[@mouhamadrouabha2676]

Thank you for this toto. Please is there a code to generate pdf files instead of word files ?

[@omar-kv9jb]

I think you can change the extension to .pdf instead of .docx during the step of wdDOC.SaveAs2

[@allisonjoyalali2504]

Please how did you create this beautiful table

[@jovenvilla386]

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]

Please watch this tutorial. Thanks! kzbin.info/www/bejne/eJWofp1qg7OLd6c

[@KishanChauhan-yy3kb]

Is there any coading for convert ms word data into excel??

[@nickpapas2968]

great video!thank you

[@navin298786]

Excellent 👌

[@katel8784]

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!

[@rockfighter9974]

Thank you so much for this video

[@danishmew2873]

nice work again thanks

[@redatafeel]

How to generate all marksheet in the same one document . Please its important

[@Aleenaartandcraft]

It's so so nice information thanks sir

[@leocosh]

Hi I need a vba code for same file but the output should be in different excel files name wise

[@EuphonySpot]

did you have the exact vba code for this ? same problem the file name of excel copy the file name where the macro located

[@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.

[@vinodvinu4027]

I am getting on error saying 'Microsoft Excel is waiting for other applications to complete OLE" , can you please help to overcome this error

[@hollyx1992]

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]

Did you solve it? I need help there

[@YOGENDERSINGH-gy9nq]

No​@@bonniewinsome8192

[@luisshwekha4666]

Sir, after all complete, message showing me that "MS excel is waiting for another application to complete an OLE action". What happening Sir?

[@KangleiEdufun]

How to transfer image (in path) from Excel to word

[@দূরবীন-গ৬ষ]

how to add print option....Thanks for tutorial from Bangladesh

[@thedatalabs]

Will try to add Print features. Thanks!

[@aleonvc842]

Love it. Is the sql_result supposed to be slq? Or is that a typo error?

[@thedatalabs]

Please use the bookmark name created in Word. Will check it again and post the changes on our website, if any error found. Thanks!

[@catherineregnier1521]

Thanks a lot ! Perfect

[@1234arun999999]

Hey How to generate Pdf files instead of Word

[@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!

[@roshanlama5134]

Can we generate all those marksheets in one same document?

[@thedatalabs]

Yes

[@abcd2-k4s]

Transfer certificate how make

[@thedatalabs]

Please use the same technique to automate certificate as well. Thanks!

[@jamalarif3104]

HELPFULL but sir how can i insert qrcode or image with this method

[@rehanali-qr4ld]

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]

Could you please explain the requirement and functionalities in detail? Thanks!

[@rehanali-qr4ld]

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

[@farooqbukhari5577]

how to insert pic???

[@eaasle]

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.

[@prasenjitmidya5794]

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

[@ashwagal-sabaan3783]

awesome , Thanks

[@letschilldude7358]

Link not working

[@shivannahr780]

dear sir same invoice data multipal item invoicenumber genret invoice templet word next video thanks please helf

[@tahaelyakoubi1913]

thaank youuuuu

[@sourabhbarde4785]

Excel application showing ole automation

[@hammirdev7354]

Sir one file multipal marksheet one by one page code

[@meisam1211]

perfect !

[@skdaroch]

very nice code. but even at 2x speed it is very very slow. very long video.

[@nileshdhaigude3127]

Dear Sirji Apaka contact Number milega. Hume ek application banana hai

[@positivexyz]

Toda jor se bath karo bhai, why so low voice.

[@prasenjitmidya5794]

sir amar kano comments kano utter palam na

[@prasenjitmidya5794]

sir pless apnar mobile no ta pata pari

[@bryanpowell1232]

Iterate under a fucking loop

[@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")

[@HollandDude]

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