steambyte
asked on
Excel and VB6
Does anybody know of some code sites for using Excel and VB6
Look in the MSDN Library that ships with VB6...good starting point.
Also, if you do a search on Excel at the site below, you will find a few examples.
http://www.vbcode.com/asp/code.asp
Wayne
Also, if you do a search on Excel at the site below, you will find a few examples.
http://www.vbcode.com/asp/code.asp
Wayne
ASKER
Juliette: I checked the MSDN without much luck, also VBCODE site.
What I would like to do is use an Excel spreadsheet that has lab results and use these in a VB6 program.
The worksheets are organised into one client per sheet, each sheet has upto 12 rows of 12 columns. Each column is a result detail of the row.
I would like to select a row and and have the corresponding columns put into the corresponding text fields of the program
What I would like to do is use an Excel spreadsheet that has lab results and use these in a VB6 program.
The worksheets are organised into one client per sheet, each sheet has upto 12 rows of 12 columns. Each column is a result detail of the row.
I would like to select a row and and have the corresponding columns put into the corresponding text fields of the program
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
A common tip:
If you want to automate anything record a macro in Excel See the code in VB Editor. Copy it to VB Do the necessary changes (Hardly if any). Then Go ahead!!