Fully Automated Student Marks Sheet (Transfer Data from Excel to Word)

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

Рет қаралды 84,717

Күн бұрын

Fully Automated Student Marks Sheet - Step By Step Tutorial
In this tutorial, we will learn how to create student's marks sheet from Excel using VBA. We will transfer data from Excel file to Word file in a specific format.
#WordAutomation #TheDataLabs
Please follow the below link to download the Excel and Word files used in this video.
thedatalabs.org/automated-stu...
Please visit our website www.thedatalabs.org
Please contact us on thedatalabs@gmail.com
Thanks for watching!
Please like, share, comment and subscribe.
Have a great day!

Пікірлер: 113

@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 Жыл бұрын

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

@2009shashikant 2 жыл бұрын

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

@eborne66 Жыл бұрын

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

@UGRTechHowTo 3 жыл бұрын

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

@salihch3135 4 жыл бұрын

You guys are really awesome Thanks again

@catherineregnier1521 2 жыл бұрын

Thanks a lot ! Perfect

@nickpapas2968 Жыл бұрын

great video!thank you

@filipdopirak5226 Жыл бұрын

Perfect tutorial, thumbs up. :)

@danishmew2873 4 жыл бұрын

nice work again thanks

@meisam1211 4 жыл бұрын

perfect !

@rockfighter9974 Жыл бұрын

Thank you so much for this video

@jesusavarimuthuarockiam425 9 ай бұрын

What an explanation brother! Great video! God bless you

@thedatalabs 9 ай бұрын

Glad you liked it! Thanks!

@ashwagal-sabaan3783 3 жыл бұрын

awesome , Thanks

@navin298786 10 ай бұрын

Excellent 👌

@blinkwinkenterprises8056 2 жыл бұрын

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

@bluejay12293 Жыл бұрын

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

@nateblack972 Жыл бұрын

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

@HammaD.K 4 жыл бұрын

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

@nehadhobale3761 Жыл бұрын

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

@birasafabrice 4 жыл бұрын

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

@nicktobies 4 жыл бұрын

very simple and fantastic tips

@Aleenaartandcraft 2 жыл бұрын

It's so so nice information thanks sir

@hicaveman 9 ай бұрын

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

@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

@prediction2302 4 жыл бұрын

Very nice sir ji please upload this type of project

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

@tahaelyakoubi1913 3 жыл бұрын

thaank youuuuu

@mielkew27 2 жыл бұрын

Great video, how about adding rows in the word table from excel table?

@KuldeepSingh-nq1vi Жыл бұрын

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

@arthurquartey1939 10 ай бұрын

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.

@deepakdakhore 9 ай бұрын

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

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

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

@domsavio1409 3 ай бұрын

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.

@indiamoneywise Жыл бұрын

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

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

@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

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

@rajkumar5461 3 жыл бұрын

EASY AND PERFECT MAIL-MERGE AUTOMATION, SIR. IT COULD HAVE SIMPLE ADDITION OF CODE TO SAVE THE WORD FILE INTO PDF FORMAT. SIR THERE IS NOT A SINGLE VIDEO ON THE SCHOOL MANAGEMENT IN WHICH FEES FOR THE COMING MONTH IS SHOWN AS ONLY WHEN IT IS DUE - LIKE IN THE COLUMN OF FEE FOR AUGUST IS SHOWN ONLY ON START OF AUGUST MONTH AND OTHERWISE AS ZERO . IT CAN COMPUTE THE PENDING FEE DUE ON A CERTAIN DATE.

@allisonjoyalali2504 2 жыл бұрын

Please how did you create this beautiful table

@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

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

@KishanChauhan-yy3kb 4 жыл бұрын

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

@balajisanthanam9164 2 жыл бұрын

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

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

@chetanwaghodkar4508 2 жыл бұрын

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

@mr.granger9962 3 ай бұрын

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

@prediction2302 4 жыл бұрын

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

@paulmucheru3749 2 жыл бұрын

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

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

@1234arun999999 3 жыл бұрын

Hey How to generate Pdf files instead of Word

@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 10 ай бұрын

Same here!

@bryankessel9396 Жыл бұрын

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 8 ай бұрын

did it work with you ?

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

@jamalarif3104 4 жыл бұрын

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

@YummyNation Жыл бұрын

I m doing the same procedure for one of my projects but bookmark is getting deleted every time by default please help

@shanthabaimothajigari7441 Жыл бұрын

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

@KangleiEdufun 6 ай бұрын

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

@magux3617 10 ай бұрын

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 4 ай бұрын

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

@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

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

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

@farooqbukhari5577 2 жыл бұрын

how to insert pic???

@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

@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

@letschilldude7358 3 жыл бұрын

Link not working

@hollyx1992 2 жыл бұрын

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

@user-et9rq8po4g 4 жыл бұрын

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

@thedatalabs 4 жыл бұрын

Will try to add Print features. Thanks!

@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

@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! kzfaq.info/get/bejne/eMp1gM1ls7S8cXk.html

@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

@prediction2302 4 жыл бұрын

Transfer certificate how make

@thedatalabs 4 жыл бұрын

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

@roshanlama5134 3 жыл бұрын

Can we generate all those marksheets in one same document?

@thedatalabs 3 жыл бұрын

Yes

@sourabhbarde4785 6 ай бұрын

Excel application showing ole automation

@hammirdev7354 2 жыл бұрын

Sir one file multipal marksheet one by one page code

@skdaroch 4 жыл бұрын

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

@shivannahr780 3 жыл бұрын

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

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

@prasenjitmidya5794 4 жыл бұрын

sir amar kano comments kano utter palam na

@nileshdhaigude3127 3 жыл бұрын

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

@prasenjitmidya5794 4 жыл бұрын

sir pless apnar mobile no ta pata pari

@bryanpowell1232 8 ай бұрын

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

@user-mw1sv9cx9w 7 ай бұрын

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

@rajkumar5461 3 жыл бұрын

wd.Selection.GoTo What:=wdGoToBookmark, Name:="NAME" - HERE IT GIVES ERROR 91, SIR. WHAT TO DO.

@mehrezchtourou9135 Жыл бұрын

The same for me! Did you find the solution please?