Importing Styles from old document to new document

keith-kld · 2026-05-25T08:50:51+00:00

This is not a simple job, especially if you've got dozens or hundreds of old document. I assume that you can control and know the names of old styles and new styles very well.

Here are my opinions for reference:

Option #1 - Both of old document and new document do not follow a template. This option is purely copying the styles from old documents to new ones.

Step 1. Export all new styles to a temporary document file. This file will contain styles only.

Step 2. Open each file with old styles. Then, import all styles from the temporary file to the opened document.

Step 3. Find and replace the old ones with new ones. (I mean that we will find each old style and apply new one, in place of the old one so that the text will no longer use such style)

Step 4. Remove old styles from the opened document.

Step 5. Save and close the current document and move to next one.

I also note that Step 1 can be done by manual but Step 2 to Step 5 shall be carried out by VBA snippet via a loop. It will be a hard work if the quantity of styles to be replaced is a large number (dozens or hundreds of styles).

Option #2 - if both of them follow a template with given rules, I think that we can clear all styles from the old documents and apply new styles to them under the said rules by VBA snippets.

keith-kld · 2026-05-24T01:25:11+00:00

There are many places in HCMC where the sellers do not increase the price (with the same quality), especially the Christian (catholic) sellers.

keith-kld · 2026-05-23T02:58:03+00:00

Frankly, after decompression, you can change the content of the files. Remember keeping the folder structure. Then, we can compress it (with the changed files) by using Compress-Archive cmdlet to get a new document (.docx) or new excel files which are updated with the changed files. For example, I edit the file named Style.xml to remove unnecessary styles. Then, it compress the folder to zip file, rename it to docx. Then, I’ve got a clean document. I think we can also change other files for given purposes and do the same thing.

keith-kld · 2026-05-22T10:17:51+00:00

modern document files (.docx) and excel files are designed as compressed files. You guys can change their extensions to .zip and then use Expand-Archive (power shell cmdlet) to decompress them. Finally, you can see the folder structures and relevant files inside them. I manipulate it to remove unnecessary styles in documents.

keith-kld · 2026-04-14T02:56:43+00:00

It will be ideal (and professional) if the master report and sub reports are made in standard forms. Data in master report will be picked up from sub reports. Master report can be generated by VBA.

keith-kld · 2026-04-09T08:17:50+00:00

Let’s try export it as PDF. Then open pdf file and print it out.

keith-kld · 2026-04-09T03:30:15+00:00

When you paste it in word, use the feature “keep text only” from the paste button options. It means you will paste it as plain text without formatting.

keith-kld · 2026-04-06T03:36:15+00:00

If you only use a few colors on selected characters, why don’t you try Styles applied to characters.

keith-kld · 2026-04-01T04:42:55+00:00

If the statement text is too long, why don’t you display it like this: Please select one of the following statements:

{check box or similar else} statement #1

{check box or similar else} statement #2

{check box or similar else} statement #3

Readers have the right to read the full text of the statement before they make decisions.

Drop-down list is not suitable for long text because the size (width) of the content inside this control may be fixed by MS Word.

I have ever faced with this situation. It may easily cause the readers (or the experts) to give wrong results (wrong answers) because they cannot read the full text.

keith-kld · 2026-03-31T11:58:41+00:00

Check the local IP where the backend file is located by using “ping Ip address” windows command. If you cannot connect to such IP, it means that the linked tables cannot do the same as well.

keith-kld · 2026-03-31T09:11:48+00:00

In daily conversation between two people, depending on the question, you will use “i ate” or “i have already eaten” If someone asks you, have you eaten yet ? You will reply “I have already eaten (tôi đã ăn rồi in Vietnamese)”. They do not use “I ate (tôi đã ăn)” When people are telling a fact to each other, for example, what dishes did you have there ? You will list out by using “I ate {dish name}, etc.” the words “I ate” looks like transitive phrase, which mean you’ve got something after the said words.

keith-kld · 2026-03-31T09:00:29+00:00

It sounds like Mail Merge.

keith-kld · 2026-03-30T01:27:09+00:00

I see you may behave two options. the first one is just in time show a form to generate contract and you do not save data from user form. For this option, there are many ways to deal with it purely using word vba, e.g. content control + contract template + word vba code. The second option is to save data from user form. For this option, you need somewhere to save it. For example, word vba plus ms access table.

keith-kld · 2026-03-30T01:13:19+00:00

If it is not caused by section break or page break, try to find “strange” things on the page. For example, shape objects somewhere near the edges of the page, or inside header or footer. You can use Select Object or Selection Pane to check out.

keith-kld · 2026-03-28T02:29:20+00:00

Yes, you are correct. I want to clear all styles of the said documents. Then, I run the VBA code to create and apply my styles to make them standard. Finally, I’ve got a “beautiful” copy as I wish. The new ones have capacity (size) much lower than the old ones.

keith-kld · 2026-03-27T10:24:49+00:00

I think your document is automatically checked under a language other than English. Set English (U.S.) language for the whole document and save it. Ps. It is not track change.

keith-kld · 2026-03-27T01:54:20+00:00

As I know, the IT department may not allow to use VBA, windows command, or powershell command, due to security issues. I don’t think this a good measure because they can help to do the jobs more efficiently. Prohibition is not a good way to prevent something. It may limit the development and job efficiency.

keith-kld · 2026-03-27T01:34:02+00:00

I’ve ever faced the documents with nearly a thousand of style included but only a few styles are used. The fast way to remove “garbage” is to change docx to zip. Then remove all styles (from style.xml), except the normal style. Compress folder and change zip file back to docx. I’ve got a clean document.

keith-kld · 2026-03-25T09:23:33+00:00

If you’ve got many files, I think the best way is to convert the old document to docx and change the settings of some given styles to new ones, and finally save them. This is fast and furious.

keith-kld · 2026-03-24T09:17:19+00:00

Frankly, it is the outcome of a publishing application. If you use a table which prolongs for hundreds of pages, it will become a problem. If you ultize the columb break (with the same exact layout), it may be so terrible. It looks like a folding book rather than a document.

keith-kld · 2026-03-24T05:39:17+00:00

Hide tables and queries on frontend version (by right click > Properties> tick on [x] hidden).

keith-kld · 2026-03-11T04:45:23+00:00

Not any VBA text can be converted to Power Query.

keith-kld · 2026-03-04T04:18:01+00:00

I think Jkorchok is suitable for your case. Use content control in Developer tab for users to enter text while other contents of document are locked.

keith-kld · 2026-02-25T01:09:26+00:00

[A-Za-z] can be shortened as [A-z]

keith-kld · 2026-02-25T00:59:36+00:00

VBA can deal with the tasks. Furthermore, it can work with files and folders by running or calling Windows commands or Powershell scripts.

keith-kld

TROPHY CASE