If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi all! We have been experiencing an issue on site where threads have been missing the latest postings. The platform host Vanilla are working on this issue. A workaround that has been used by some is to navigate back from 1 to 10+ pages to re-sync the thread and this will then show the latest posts. Thanks, Mike.

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Generating a report in excel from VB6

youcancallmeal · 2007-04-11 10:03:22

Would anybody be able to point me in the direction of how to use Visual Basic 6 to generate an excel sheet and insert my data into it and create a bar chart? I was thinking of taking my data from a simple text file but it would probably be easier to just code the data directly into VB6?

11-04-2007 11:03am

#1

youcancallmeal

Registered Users, Registered Users 2 Posts: 8,037 ✭✭✭

Join Date: February 2005

Posts: 7652

Would anybody be able to point me in the direction of how to use Visual Basic 6 to generate an excel sheet and insert my data into it and create a bar chart? I was thinking of taking my data from a simple text file but it would probably be easier to just code the data directly into VB6?

0

Comments

#2 11-04-2007 12:09pm

NutJob

Closed Accounts Posts: 884 ✭✭✭

Join Date: May 2002

Posts: 818

Google CSV files

May answer your question

0
#3 11-04-2007 2:03pm

Ginger

Registered Users, Registered Users 2 Posts: 2,931 ✭✭✭

Join Date: January 2003

Posts: 2658

One of the easiest ways is the following

Open excel and record a macro of you creating the bar chart. This will give you that piece of the code in VBA which is easy to convert to VB

Next thing in your VB6 application add a reference to Excel so you can see all the properties and methods.

Use the .CreateWorkbook i think and go from there.

This will probably help you http://www.codeguru.com/vb/gen/vb_misc/tips/article.php/c7767/

0
#4 11-04-2007 2:16pm

youcancallmeal

Registered Users, Registered Users 2 Posts: 8,037 ✭✭✭

Join Date: February 2005

Posts: 7652

Excellent stuff guys, I 'll give it a shot and let you know how I get on

0