Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
excel layout in VB?
- Thread starter knarfo
- Start date
In your components (where controls reside), click Add, Choose COM components Tab, and choose Microsoft OfficeXX Spreadsheet. This is commonly known as the OWC spreadsheet.
This looks and feels like Excel, but has more columns and rows available, and can be easily connected to a DB with a connection string.
However, if you try to distribute this control, the recipient must have the same version of Excel/Office, and must also have the Developer Edition for Office (I believe).
I hope this helps.
Ron Repp
If gray hair is a sign of wisdom, then I'm a genius.
This looks and feels like Excel, but has more columns and rows available, and can be easily connected to a DB with a connection string.
However, if you try to distribute this control, the recipient must have the same version of Excel/Office, and must also have the Developer Edition for Office (I believe).
I hope this helps.
Ron Repp
If gray hair is a sign of wisdom, then I'm a genius.
- Thread starter
- #5
- Status
