Excel VBscript to export rows to specified Word styles
Project ID:
752960Project Type:
FixedBudget:
$30-$250 USD
Project Description:
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.
Skills required:
Excel, Microsoft, Visual Basic, Word
Public Clarification Board
3 messages
-
TheCentre
Format for XML file (generated from the previously uploaded Excl+RS+demo.xlsx file)
<Array dim='[2]' type='Cluster'>
<ENTRY mems='5'>
<RS type='String'>RS0001</RS>
<Name type='String'>AGS Function</Name>
<Status type='DBL'>0</Status>
<Requirement type='String'>Provide ground/satellite communications according to specifications provided by SFL. Duplicate functionallity of existing SFL ground station within cost constraints and local requirements. </Requirement>
<Detail type='String'>Satellite tracking, Satellite Control and Sequencing, Data collection and dissemination </Detail>
</ENTRY>
<ENTRY mems='5'>
<RS type='String'>RS0006</RS>
<Name type='String'>Site Survey</Name>
<Status type='DBL'>1</Status>
<Requirement type='String'>Measurement of site RF noise/interference
</Requirement>
<Detail type='String'>Filtering for in band (2.3-24GHz) signals </Detail>
</ENTRY>
</Array>over 1 year ago
Awarded Bids
All Bids ()
vbexcel
|
vbexcel
From Canada
Offline
|
Freelancer Orientation (85%, 99th percentile)
General Freelancer Orientation (80%, 90th percentile)
$60
in 2 days
over 1 year ago
Over ten years experience in developing Excel/VBA solutions.
ifaisal
|
ifaisal
From New Zealand (Aotearoa)
Offline
|
$100
in 1 day
$10 Milestone Requested
$10 Milestone Requested
over 1 year ago
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.
iQraTechnologies
|
iQraTechnologies
From India
Offline
|
$100
in 1 day
$10 Milestone Requested
$10 Milestone Requested
over 1 year ago
Hi, please consider checking your inbox for more information. Thank you!
sTdwares
|
sTdwares
From India
Offline
|
General Freelancer Orientation (80%, 90th percentile)
$45
in 3 days
$45 Milestone Requested
$45 Milestone Requested
over 1 year ago
Hello. Please check your PMB before making a decision. Regards.
WebSolution4
|
|
WebSolution4
From United States
Offline
|
Foundation Freelancer.co.uk Member
Foundation EUFreelance.com Member
$50
in 1 day
over 1 year ago
Hi,
Please view PM.
Thank you
Straid
|
|
Straid
From United Kingdom
Offline
|
Foundation EUFreelance.com Member
$100
in 1 day
over 1 year ago
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.
check your pm for detail.
I would like to render my services for your project
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.
sumithbuddika
|
|
sumithbuddika
From Sri Lanka
Offline
|
$75
in 2 days
$19 Milestone Requested
$19 Milestone Requested
over 1 year ago
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 wish.we have Profess... more
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 wish.we have Professional men and women for any creations.Why don’t you give us to little chance to design your creation?Give a one chance and see the difference.
less
Hi,
I am a macro specialist and i can really help you on this.
I can take this project.
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.
sudhasrinivasan
|
|
sudhasrinivasan
From India
Offline
|
$50
in 2 days
$50 Milestone Requested
$50 Milestone Requested
over 1 year ago
Pls view pm
I can do it.
Please read my PM
ExcelNumber1
|
|
ExcelNumber1
From Viet Nam
Offline
|
$50
in 1 day
$20 Milestone Requested
$20 Milestone Requested
over 1 year ago
I can do it now, please see PMB
Hello, I have a lot experience in VBA for Excel, Outlook and Word. Please contact me...
jordan146
|
jordan146
From United States
Offline
|
General Freelancer Orientation (75%, 81st percentile)
$75
in 1 day
over 1 year ago
Should not be a problem. Once I see the excel file I can turn your project around in 24hrs.
I can do it
I can do it.
We have a team of VBA experts and can surely do this for you. We have done several projects with similar functionality requirements.
hi......
I have made some projects using VBA and eager to do this.
zoxno6
|
zoxno6
From Serbia and Montenegro
Offline
|
Foundation EUFreelance.com Member
$160
in 1 day
over 1 year ago
20 years in advanced Excel/Word/VBA programming.I will do done your project and I will learn you to solve this and similar problem yourself.
Hi Sir,
I am working in your project very carefully. Please give me your project. I complete your project in 4 or 5 days if it is sort.
See Your PM