LinkBack URL
About LinkBacks
Excel forms are exchanged with word forms, and the contents of excel forms are copied to the specified position of word, or the contents of word forms are copied to excel forms.
help!!!! excel to word and word to excel
Excel forms are exchanged with word forms, and the contents of excel forms are copied to the specified position of word, or the contents of word forms are copied to excel forms.
Last edited by AliGW; 10-29-2022 at 11:12 AM. Reason: URL removed.
Continue in THIS thread - you can attach your workbooks here. I removed a link to another thread, NOT any attachments.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Re: help!!!! excel to word and word to excel
Sorry administrator, just now I can't upload the attachment, so I resend the Post. Now I can upload the attachment. I hope some experts can help me solve this problem. thank you.
Be patient, please. And give a MUCH more detailed explanation of what you want: your opening post makes no sense whatsoever.
Re: help!!!! excel to word and word to excel
I'm sorry, because my needs were not clearly stated.
For example, I have a personal information excel form with three people in it. I need to automatically generate three corresponding word forms according to the contents of this form, which is equivalent to that I have a fixed word template and fill in data according to the contents of the form registered in excel.
In addition, I also need to reverse convert how to extract the contents of multiple word tables and summarize them to excel tables.
If there is anything you don't understand, please leave a message for me. Thank you.
Moved to the Excel VBA section. Now be patient, please. I shall not be moving this thread again.
Are there any experts who can take time to pay attention to my post?
This thread as had 194 views and no help has been offered. The most likely reasons for this are either that nobody feels they have the expertise to help or your explanation of what you want is too vague. Personally, I'd imagine that it is the latter.
Take a moment to explain in DETAIL what you are trying to achieve, then you might get some traction.
Thank you for your advice.
Each row of the Excel table stores the information of an individual person, and then the word document is the resume template. The location and format of the word document are fixed. I need to generate a resume document based on the data in the Excel table. Each row of data in Excel generates a word file.
On the contrary, I also hope to summarize the information in Word documents into an Excel table in batches. The format and location of each Word document are the same.
In other words, it is to split the data in the excel form into multiple word documents, and multiple word documents are summarized into one excel form.
Splitting out to Word can be done using the Mail Merge feature: https://www.ablebits.com/office-addi...ge-excel-word/
I cannot help you with getting data into Excel the other way - sorry. It will most likely require VBA.
Are you expecting this to be a two-way process? In other words, if Excel is updated, then the Word documents are updated, and if a Word document is edited, the Excel workbook is updated? If so, then I think quite complex VBA would be required. Let's hope someone knows how to do it.
I don't want both sides to update at the same time. These are two independent operations. Word is summarized into Excel, and Excel is split into Word.
It feels a little like mail merge, but what I want is a form with a fixed template in the Word document. I just fill in the data corresponding to Excel.
That's exactly what mail merge does. You create a template in Word.
Anyway, it's up to you.
Sorry, I didn't mean anything else. I just read the link you sent. It seems that it is not a VBA method, because I have too many files. I hope VBA code can be executed automatically.
For some code to get you started with that, see: posts #4 & #6 in https://forums.excelguru.ca/threads/...-to-excel.8900Originally Posted by 302
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Sorry macropod, I copied the code and ran with an error. I can't understand the Word VBA code. I don't know how to rewrite the code
As I said, it is code to get you started. You need to edit it to suit your particular requirements. Simply telling us it "ran with an error" isn't at all helpful. Did you follow the instructions in the note at the top of the code I posted there?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks