simple order form and way to store the information

[LongBeach]

I understand how to create a database in MS Access and use VB6 to create an interface for a user. However, I am interested in developing a VB6 order form User Interface and connect it to simple spreadsheet to hold the order information. Can I connect my user interface to flexgrid? I do not want to use SQL, foxpro, or filemaker Pro. Thank you.

 

[dellyjm]

What do you think about using Microsoft Excel and interfacing Excel and VB with the Microsoft Excel Object Library provided in the Project--> References menu, that way you could link to a popular and ubiquituous spreadsheet.

Better yet...no SQL. Although it would be great to use it.

Option Explicit

Dim xlsApp As Excel.Application
Dim wrdApp As Word.Application

Private Sub Command1_Click()
Set xlsApp = Excel.Application
With xlsApp
'Show Excel
.Visible = True
'Create a new workbook
.Workbooks.Add
'Put text in to the cell that is selected
.ActiveCell.Value = "Hi"
'Put text into A3 regardless of the selected cell
.Range("A3&quot.Value = "This is an example of connecting to Excel"
End With
End Sub

Check out this site.

http://www.vbexplorer.com/office_vb.asp

Delton.
deltonphillips@hotmail.com

 

[swilliams]

I think first you have to consider what this store of information is going to be used for, and how it will use the data.

If you want a store of data, then you are creating a database and so you should be using Access or similar and you shouldn't be using Excel. Excel is a spread sheet application, used for data manipulation.

Simon