OLE

OLE automation Program: Create a tracking program that enables the automatic ploting of a numerical information, through the use of a microsoft excel [url removed, login to view] called by OLEautomation. Selecting File Open should enable the user to select a file data to be [url removed, login to view] file should be a standard text file Accessed through the file [url removed, login to view] method. Once the file is opened, the user should be able to choose a data element,to plot by dragging and droping the element from a list box onto the plotting picture box Plotting is to be accomplished through the use of OLE automation. The information to be ploted should be sent to an excel worksheet that has a graph that plots information in the worksheet. When excel receives the new data it will automatically update the graph which then can be programmatically copied to the clipboard and pasted into the picture box. In general the program should take from a text file names of products and show them in the list [url removed, login to view] user could drag a name of a product to the picture box. Then the picture wwill show an excel graph of sales from May to November In addition will show in labels price of sale, quantity sold ,cost price. The program will show in a different lable for each product the average sales. the form should have a list box and a picturebox for the graph to be shown from excel and different lable boxes to show the different data. There’s an excel sheet attached with the data. The program must incorporate the most recent file plotted being presented as a menue chice (store file name and path in registery.) The program must have a suitable icon for use with drag n drop actions. The program should also return at least one value from a calculated cell in the excel worksheet.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.

## Platform

vb 6.0 windows 2000 professional

Ingeniería MySQL PHP Arquitectura de software Verificación de software Visual Basic

Nº del proyecto: #2891996

Sobre el proyecto