Creating a chart from a .csv file in VB6

[johnvella]

I don't know whether or not this is do-able, but here goes:

I have a .csv file which is auto-generated and at present I load this into Excel and create charts, for reporting purposes.

At the moment this is done on a weekly basis, but I've been told it will soon be a daily report which is why I would like to automate the process.

Ideally what I would like is to have a little application where I would be able to decide which report I need to run, by clicking on 1 of several buttons, and the data would be read in from my .csv file and automatically outputted in a chart format, (I'm not too bothered about the format of the output, as long as it can be imported into a PowerPoint slide, or a Word Document for instance)

I've just read back through the request so far, and realise that this might be quite complex, so if it helps I have figured out how to read the data from a .csv file and output it to another .csv file, (I got the code from this site!) but I'm not sure about the whole converting the data into a chart format part.

Any help/advice/suggestions would be greatly appreciated.

By the way, I use Visual Basic 6, SP5 and Excel 2003 if that makes any difference.

Thanks in advance,

John V.

 

[johnwm]

Hi johnvella and welcome to Tek-Tips

May I suggest you read faq222-2244 to get the best from the forum.

For this question there are numerous threads covering the subject which you can find with the search tab which appears immediately below the thread number (top of this panel). There are also 3 faqs. Try:
faq222-240
faq222-3383
faq222-1020

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts

 

[johnvella]

Hi johnwm,
Thanks for you speedy response, and it's great to be here! This seems like a really useful site, which I will add to my favourites both at home and at work!

I've read the rules, (I will review them later when I've a little more time to digest the contents fully) and have had a quick look at the other threads. Again, I will look at these later, (when I don't have 3 screaming kids running around) but for now thanks again for your help, and the links you provided look very useful... I'll let you know how I get on.

Regards,

John.