VB script to export an Excel schedule in CSV text file
$30-250 USD
Selesai
Disiarkan sekitar 14 tahun yang lalu
$30-250 USD
Dibayar semasa penghantaran
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 [login to view URL] 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.
Hi,
We have well experienced in VBA programming and we have done lot of automation and data scrapping on VBA (Excel, Access, Word).
Please give us this opportunity to give you the quality solution.
PLEASE SEE PMB for detil.
Thanks
Radical Info Systems.