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

en 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é à:


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

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 2 jours
(2 Commentaires)

9 freelance font une offre moyenne de $49 pour ce travail


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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(58 Commentaires)

Consider it done. Check your PM for my bid details

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(50 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(20 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(9 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(9 Commentaires)

believe me

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)

Dear Sir, Lemme giva chance to serve u!

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)