login
Forgot?
Login with Facebook

Don't have an account? Register one now!

Excel VBscript to export rows to specified Word styles

Bids 
28
Avg Bid
$79 USD
CLOSED
  • Project ID:

    752960
  • Project Type:

    Fixed
  • Budget:

    $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

Project posted by:

TheCentre Australia
(5 Reviews)

Last seen:

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

  • TheCentre

    doc # 2

    Attachment: Excl+RS+demo.xlsx

    over 1 year ago

  • TheCentre

    document #1

    Attachment: Word+RS+demo.docx

    over 1 year ago


If you are the project creator or one of the bidders, please Log In for more options.


Awarded Bids

maap0404 Mexico
maap0404
Mexico From Mexico     Offline
 Accepted
$35 in 2 days 
0
over 1 year ago
4.6

1.6

1 Review
100% Completion Rate
Hi, please check your PM, best regards

All Bids ()

vbexcel Canada
EXCEL PNG.png
vbexcel
Canada From Canada     Offline
  Freelancer Orientation (85%, 99th percentile)
  General Freelancer Orientation (80%, 90th percentile)
$60 in 2 days 
0
over 1 year ago
4.9

4.9

19 Reviews
69% Completion Rate
Over ten years experience in developing Excel/VBA solutions.
ifaisal New Zealand (Aotearoa)
PP_Pic.jpg
ifaisal
New Zealand (Aotearoa) From New Zealand (Aotearoa)     Offline
$100 in 1 day 
$10 Milestone Requested
over 1 year ago
5.0

2.9

2 Reviews
70% Completion Rate
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 India
Ilyas Kazi.png
iQraTechnologies
India From India     Offline
$100 in 1 day 
$10 Milestone Requested
over 1 year ago
5.0

2.3

3 Reviews
100% Completion Rate
Hi, please consider checking your inbox for more information. Thank you!
sTdwares India
animated_clipart_dancing.gif
sTdwares
India From India     Offline
  General Freelancer Orientation (80%, 90th percentile)
$45 in 3 days 
$45 Milestone Requested
over 1 year ago
4.7

1.9

2 Reviews
37% Completion Rate
Hello. Please check your PMB before making a decision. Regards.
WebSolution4 United States
WebSolution4
United States From United States     Offline
  Foundation Freelancer.co.uk Member
  Foundation EUFreelance.com Member
$50 in 1 day 
0
over 1 year ago
5.0

1.0

1 Review
40% Completion Rate
Hi, Please view PM. Thank you
Straid United Kingdom
Straid
United Kingdom From United Kingdom     Offline
  Foundation EUFreelance.com Member
$100 in 1 day 
0
over 1 year ago
5.0

1.0

1 Review
100% Completion Rate
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.
Alirezaal2009 Iran
Alirezaal2009
Iran From Iran     Offline
$30 in 4 days 
0
over 1 year ago
check your pm for detail.
skanom Tunisia
skanom
Tunisia From Tunisia     Offline
$50 in 2 days 
0
over 1 year ago
I would like to render my services for your project
shakil2021 Bangladesh
shakil2021
Bangladesh From Bangladesh     Offline
$30 in 1 day 
0
over 1 year ago
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 Sri Lanka
sumithbuddika
Sri Lanka From Sri Lanka     Offline
$75 in 2 days 
$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
mankumar2 Canada
mankumar2
Canada From Canada     Offline
$30 in 14 days 
$6 Milestone Requested
over 1 year ago
Hi, I am a macro specialist and i can really help you on this.
pedtauk Brazil
pedtauk
Brazil From Brazil     Offline
$60 in 5 days 
$12 Milestone Requested
over 1 year ago
I can take this project.
toraja India
toraja
India From India     Offline
$85 in 3 days 
0
over 1 year ago
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 India
sudhasrinivasan
India From India     Offline
$50 in 2 days 
$50 Milestone Requested
over 1 year ago
Pls view pm
ayswaryacv India
ayswaryacv
India From India     Offline
$30 in 30 days 
$2 Milestone Requested
over 1 year ago
I can do it.
rjkumar India
taj1_176x144.gif
rjkumar
India From India     Offline
$36 in 0 days 
$18 Milestone Requested
over 1 year ago
Please read my PM
ExcelNumber1 Viet Nam
ExcelNumber1
Viet Nam From Viet Nam     Offline
$50 in 1 day 
$20 Milestone Requested
over 1 year ago
I can do it now, please see PMB
mile10 Serbia and Montenegro
mile10
Serbia and Montenegro From Serbia and Montenegro     Offline
$30 in 2 days 
0
over 1 year ago
0.0

0.0

0 Reviews
50% Completion Rate
Hello, I have a lot experience in VBA for Excel, Outlook and Word. Please contact me...
jordan146 United States
JC-Logo.jpg
jordan146
United States From United States     Offline
  General Freelancer Orientation (75%, 81st percentile)
$75 in 1 day 
0
over 1 year ago
Should not be a problem. Once I see the excel file I can turn your project around in 24hrs.
anatprog Ukraine
anatprog
Ukraine From Ukraine     Offline
$100 in 5 days 
0
over 1 year ago
0.0

0.0

0 Reviews
33% Completion Rate
I can do it
orifjon Uzbekistan
orifjon
Uzbekistan From Uzbekistan     Offline
$100 in 3 days 
$50 Milestone Requested
over 1 year ago
I can do it.
SCAnalytics India
SCAnalytics
India From India     Offline
$90 in 2 days 
$9 Milestone Requested
over 1 year ago
0.0

0.0

0 Reviews
44% Completion Rate
We have a team of VBA experts and can surely do this for you. We have done several projects with similar functionality requirements.
grvkpr18 India
IMG0025A.jpg
grvkpr18
India From India     Offline
$30 in 2 days 
0
over 1 year ago
hi...... I have made some projects using VBA and eager to do this.
zoxno6 Serbia and Montenegro
ZM.jpg
zoxno6
Serbia and Montenegro From Serbia and Montenegro     Offline
  Foundation EUFreelance.com Member
$160 in 1 day 
0
over 1 year ago
0.0

0.0

0 Reviews
0% Completion Rate
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.
VikyB India
VikyB
India From India     Offline
$150 in 4 days 
$150 Milestone Requested
over 1 year ago
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.
AlexM1983 Belarus
AlexM1983
Belarus From Belarus     Offline
$200 in 2 days 
$10 Milestone Requested
over 1 year ago
See Your PM
pug Belarus
pug
Belarus From Belarus     Offline
$250 in 5 days 
0
over 1 year ago
0.0

2.0

0 Reviews
100% Completion Rate
Hi! I am VB/VBA expert with wide experience.