Programming Forums > Application Development > Visual Basic .NET

Shaythen · Mar 6th, 2008, 2:12 PM

I've recently been tasked to create a program that will open an excel file, gather data and then on a new sheet (same workbook or not) display the data in the form of a chart. I figure VB is the way to go, but I'm not well versed. Here is my initial code:

(Toggle Plain Text)

        Dim dBfile As Excel.Application
        dBfile = New Excel.Application

        dBfile.Workbooks.Open("c:\file\name.dbf")

        dBfile.Visible = True

This seems to work great for opening and displaying the file but I'm at a loss for what to do next. I thought maybe I could record a macro of me creating a chart and then do cut/paste action with the macro script. This, however, turned out to be quite sloppy. I figure I need to declare some chart, then use some inherent method to create it. Any general feedback on what to try is much appreciated.

Mar 6th, 2008, 2:12 PM	#1
Shaythen Newbie Join Date: Mar 2008 Posts: 6 Rep Power: 0	Using VB to automate chart creation in excel. I've recently been tasked to create a program that will open an excel file, gather data and then on a new sheet (same workbook or not) display the data in the form of a chart. I figure VB is the way to go, but I'm not well versed. Here is my initial code: (Toggle Plain Text) Dim dBfile As Excel.Application dBfile = New Excel.Application dBfile.Workbooks.Open("c:\file\name.dbf") dBfile.Visible = True Dim dBfile As Excel.Application dBfile = New Excel.Application dBfile.Workbooks.Open("c:\file\name.dbf") dBfile.Visible = True This seems to work great for opening and displaying the file but I'm at a loss for what to do next. I thought maybe I could record a macro of me creating a chart and then do cut/paste action with the macro script. This, however, turned out to be quite sloppy. I figure I need to declare some chart, then use some inherent method to create it. Any general feedback on what to try is much appreciated. __________________ "Either write something worth reading or do something worth writing." -Benjamin Franklin

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VB 2002 -> VB 2008 conversion	pal	Visual Basic .NET	1	Sep 15th, 2007 3:43 AM
appending an excel file	glevine	PHP	1	Nov 29th, 2005 5:33 PM
entering data into excel from a form	glevine	Perl	1	Nov 18th, 2005 5:03 PM
Reading Excel files on the web	sagi	Other Web Development Languages	3	May 2nd, 2005 10:24 AM
How to run a macro in MSProject from Excel?	jiancheng80	Visual Basic	2	Jan 19th, 2005 6:49 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Application Development > Visual Basic .NET

Using VB to automate chart creation in excel.