About Dennis Cassøe Expertise ASP in many areas, to include them all would not be possible but some examples:
Database access (SQL server, access)
Forms
Functions
Components like aspsmartupload, aspupload, FileSystemObject, jmail
And much more.
Can`t always garenty an answer, but will do my best.
Experience Have teached courses in ASP (for beginners)
Created
Knowledgebases
E-commerce applications
Ordinary updatable homepages
Organizations belong to Aarhus School of Business, Denmark
Freelance programmer
Education/Credentials Graduate student at the Aarhus School of Business, Denmark
Expert: Dennis Cassøe Date: 2/9/2004 Subject: VB6 front end to EXCEL sheet
Question Dennis
Not sure if you are able to help me and this makes sense.
For some time I have been manipulating spreadsheets right at the sheet itself. I thought it would be great to tidy what I have been doing by making a VB6 front end to the spreadsheet.
Using VB6 I want to make a VB form, work as a front end to an EXCEL 2000 worksheet.
I have done a similar thing with Access/VB some time ago but can't seem to be able to attach an Excel Worksheet to the VB form so I can in turn manipulate the contents of individual cells in the spreadsheet with dropdown and text boxes on a VB form.
What I need to know in easy steps is.
A) How do I attach the Worksheet to a VB Form?
B) In the properties of a text box what references are required to attach to an individual cell.
I did try to do this with an OLE so that the cells I wanted to display were visible. It seemed to work, but it imported the complete spreadsheet so I am not able make any alterations to the formulas in the Excel Workbook later and some of the functions like print preview did not work either.
What I want is for the VB6 Form to just be attached at run time.
Cheers
Eric
Answer Well, there isn't at sheet that just fits into vb as access have the data grids in vb.
So you'll need to program you of the problem.
To implement the excel object library you need the reference for Microsoft Excel XX.0 object library.
I can't give you any code examples, since I don't use excel i vb, because I've read that it works rather slow, and I would normally rather save that data in a database :)
