En cours

MS Excel 2007 Macro in Visual Basic

Importing a Comma Delimited File into MS Excel 2007, extracting 3 colums out of a data range, creating with this data a simple day chart, on Y axis pips and on X axis Data and Time. Time between 07:00 GMT to 17:00 GMT. Creating a Day by Day Line Chart or over preset number of days. One Button Macro, with input requests for respective days or day.

1. Importing CSV file into WorkBook with VBA-code
2. Executing Code, when CSV file is imported in WorkBook
3. One Button on Sheet to execute code manually
4. Code checks if this is a new CSV file
5. New CSV file ? With latest date/time ( 07/08/2012 - 07:00 GMT-17:00 GMT) Reading CSV file and validating
6. Adding One Day Records to Existing CSV file to create more history over days
7. Create Day Line Graph from latest added Records
8. Option to Create More Day Line Graph
9. CSV Records are stored in Archive

Note: X Axis shows Date 07/08/2012 and hourly time interval 07:00-08:00; 08:00-09:00 etc etc.

Compétences : Excel

Voir plus : x-axis, visual basic x, excel 16, data entry macro, data entry in excel 2007, MS Excel 2007, Visual Basic Excel, simple macro, ms-excel, ms excel, macro, excel visual basic, excelchart, data entry visual basic, range macro excel, macro data entry, data entry visual, excel macro simple, simple chart data entry, excel delimited, excel line, excel button, data entry chart, number excel macro, simple excel macro

Concernant l'employeur :
( 5 commentaires ) Heemstede, Netherlands

N° du projet : #2408289

Décerné à :

Kimberley80

Hi, Professional Excel / VBA designer at your service. This is a very straightforward task which can be completed quickly and effectively. Please check your inbox for further details. Many thanks, Kim

30 $ USD en 2 jours
(2 Commentaires)
1.3

9 freelance ont fait une offre moyenne de 49 $ pour ce travail

bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

100 $ USD en 3 jours
(58 Commentaires)
6.3
Teloquence

Consider it done. Check your PM for my bid details

50 $ USD en 1 jour
(50 Commentaires)
5.2
Nhcuong

Hi, I can do it. Looking forward to hearing you, CuongNH

45 $ USD en 2 jours
(20 Commentaires)
4.8
jaimecruz

Hi I'm really interested in your project. I'm an Excel Expert Programmer.

40 $ USD en 1 jour
(9 Commentaires)
4.2
manishadk

Very Easy Job For us. Please Check PMB for details.

45 $ USD en 2 jours
(9 Commentaires)
3.6
danghungit

believe me

50 $ USD en 7 jours
(0 Commentaires)
0.0
Faysal01

I am here to say that i want to work in ur project there by i also say that i am a great worker thank u

50 $ USD en 2 jours
(0 Commentaires)
0.0
NADEEMAFZAL

Dear Sir, Lemme giva chance to serve u!

30 $ USD en 1 jour
(0 Commentaires)
0.0