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.
Bu iş için 28 freelancer ortalamada $79 teklif veriyor
Over ten years experience in developing Excel/VBA solutions.
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.
Hello. Please check your PMB before making a decision. Regards.
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.
Dear Sir, I am a data entry operator in IT firm. But I want to do this work as a per time job. I am waiting for your assure reply. Thank you. Shakil.
Dear sir , We would like to inform you that we have good condition to do your work because we are the best team in world to do any work any time as soon as possible with your idea or your [login to view URL] have Profess Daha Fazla
Hi, I am a macro specialist and i can really help you on this.
Hello Sir. I have four years experience in Document Specialist. If u give this offer to me. I will complete ur work fast and accuracy.
Hello, I have a lot experience in VBA for Excel, Outlook and Word. Please contact me...