Excel VBscript to export rows to specified Word styles
$30-250 USD
Completed
Posted over 13 years ago
$30-250 USD
Paid on delivery
1. Write a script/macro to allow a selected set of rows/columns to be exported in row then column order to a word document using paragraphs styles that are associated with the Excel sheet column names (e.g. the text of column 1 could be exported to Heading 1, the text of column 2 could be exported to Heading 3. Row 1 of the Excel sheet would be exported as the first set of these followed by row 2 etc. in sequential order).
The first column name also needs to have the capability to be exported to the word document as the entry in a numbered list (e.g. if the first entry on the first row at column 1 was RS01 the style for column 1 could be selected as a list and RS01 would be the number, if the second row, first column was RS05 then this would the next list entry)
2. The data so selected should also be exported to an XML file with the same name as the word document, using the column names as categories and rows as items.
In a future on project I would also like to investigate doing the reverse of the above.
Hello
This can be done without using a Macro. I can do this using word and Excel capabilities. I can teach you so you can do it yourself in future.
If you give me this project now, I'll finish on weekend.
Hi, We have excellent VBA experience and would be happy to complete you project. Will agree full product spec prior to start. Any questions please get in touch. Regards, Straid.