Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

How to put word filename & headline to excel table with some

by polixenes Jul 1, 2009 9:17PM PDT

Hello,

I am not new to word, but still lack of detailed knowledge.

Is it possible to make macro or other command line to automaticaly fill one field with document count and then use it as filename also.
This filenema should then be filled in one excel document with aditional text from another field for DB creation

Please help.

example

Word
Order no. XXXX(here should be document number counting from 1- step1); this number should be used in filename and also in
Excel

Order No. Item
XXXXX XXXXXXX (from some other field in word that would be filled in)

Discussion is locked

1 Posts

- Collapse + Expand Details

- Collapse -

Yes.

by Kees Bakker Jul 1, 2009 9:26PM PDT

That's quite well possible.

Find a programmer to make it, or invest the time to learn to do it yourself. Google is your friend when writing macro's (use VBA in the search terms) for example code if the inbuilt help isn't sufficient.

Kees

Back to Office & Productivity Software forum