In Progress

VB script to export an Excel schedule in CSV text file

We need an Excel VBA script that is able to export a schedule manually formated in Excel in a csv format.

We have:

Time periods in 1 row

Rooms names on 1st and 2nd column

In cells, we have course names

Each cell has a colour which is related to a class [url removed, login to view] mapping of the colours and class names are on bottom of the sheet.

The exported csv file should then look like this:

Room X,0800/0950,Class Alpha,Mathematics

Room X, 1005/1155, Class Beta, English

Merged cells should be also managed.

A screenshot of the excel sheet is attached.

Skills: Excel, Visual Basic

See more: script csv, we excel, vb this, export excel text script, excel schedule, excel export text, vba excel, vb excel, format excel, export, excel vba script, excel mathematics, CSV, cells, csv script vba, excel colour, cell names, excel row column, mapping excel vba, sheet excel visual basic, csv column format, sheet visual basic script, excel column row, excel format cell, excel cell format

About the Employer:
( 4 reviews ) Geneva, Switzerland

Project ID: #589419

Awarded to:

djucuti

Hello, Please check PM!

$100 USD in 2 days
(19 Reviews)
4.7

26 freelancers are bidding on average $84 for this job

svet63

VBA developer since 1997. Can do. Regards, Svet.

$180 USD in 3 days
(48 Reviews)
6.3
guoxinliu917

Hello, I can do it for you. Please check my PMB. Thanks.

$90 USD in 1 day
(28 Reviews)
6.0
nagybatonyi

Such jobs are my daily practice; please see PMB for details! Regards!

$50 USD in 1 day
(45 Reviews)
5.6
srinichal

I can do the task and deliver the script

$45 USD in 2 days
(30 Reviews)
5.5
Wonderer

Hi, Can be perfectly done. Thanks, Al

$99 USD in 1 day
(30 Reviews)
5.3
gangabass

I can do this job for you. See PM for details.

$50 USD in 2 days
(45 Reviews)
5.0
morpheeen

Hi, I have experience in doing this type of things, I have written some similar code for Celestica also.

$100 USD in 5 days
(12 Reviews)
4.5
KellogITSolution

Hello Ready to start right now. Please see your PMB for details. Thanks

$55 USD in 2 days
(15 Reviews)
4.4
VLADNOVA

Kindly see PM for details. Vlad

$199 USD in 2 days
(9 Reviews)
4.2
johnsinit

Dear Trezza! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.

$145 USD in 2 days
(16 Reviews)
4.2
piyushdpatel

Hi This is Piyush Patel I have 5 yrs of Exp in VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Please Check My PM

$80 USD in 1 day
(10 Reviews)
4.0
Varun1981

Hi Sir, Allow me to take this project and I will deliver you the best solution in the market. Please check my PM for details. Thanks Varun Sharma

$55 USD in 3 days
(5 Reviews)
3.7
zszabo

Hi, Could you post a sample excel sheet, please and I will send you a solution. B.R. Zoltan

$80 USD in 3 days
(3 Reviews)
2.2
flairer

You will get the best service from us, Guaranteed.

$65 USD in 1 day
(0 Reviews)
0.0
Nghinv

Please to be served! I will bring you the most satisfied :)

$45 USD in 2 days
(0 Reviews)
0.0
bradul

Hi I can you help

$30 USD in 0 days
(0 Reviews)
0.0
tm2009

Greetings! This is a simple job for me, so I will charge you a very small amount. Thank you.. - TM

$75 USD in 3 days
(0 Reviews)
0.0
excelexpertz

plz view pm for details

$100 USD in 1 day
(0 Reviews)
0.0
amalgam002

Hello Sir/Madam I have good experience in this similar type of work. recently I have finished a projects of similar type work. I am confident that I can do this work for you. Ready to start the project immediately. I More

$30 USD in 1 day
(0 Reviews)
0.0
mongkolchon

Easy Task I can do it in 1 day. 2 days spare for communication and correction.

$50 USD in 3 days
(0 Reviews)
0.0