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 Chriss Miller 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?

Status
Not open for further replies.

knarfo

Programmer
Joined
Nov 21, 2006
Messages
8
Location
NL
Hello,

I'm looking for an excel layout for VB.
So a spreadsheet lookalike or something.
Does that exist?

thanks
frank
 
Have a look at the COM object called something like Excel spreadsheet.
 
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.
 
thats great thanks!
frank
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top