help!!!! excel to word and word to excel

[302]

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.

[AliGW]

Continue in THIS thread - you can attach your workbooks here. I removed a link to another thread, NOT any attachments.

[302]

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.

[AliGW]

Be patient, please. And give a MUCH more detailed explanation of what you want: your opening post makes no sense whatsoever.

[302]

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.

[macropod]

In addition, I also need to reverse convert how to extract the contents of multiple word tables and summarize them to excel tables.

For some code to get you started with that, see: posts #4 & #6 in https://forums.excelguru.ca/threads/...-to-excel.8900

[302]

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

[AliGW]

Moved to the Excel VBA section. Now be patient, please. I shall not be moving this thread again.

[302]

Are there any experts who can take time to pay attention to my post?

[AliGW]

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.

[302]

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.

[AliGW]

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.

[302]

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.

[302]

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.

[AliGW]

That's exactly what mail merge does. You create a template in Word.

Anyway, it's up to you.

[302]

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.

[macropod]

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?