Excel on a Form
 

Boys and Girls,

Sometimes I wonder if I simply do not get this whole programming thing.

I have an application written in Excel VB. On one of my input forms I
want to have the user input information via a grid-like-input-region
(you know something like a worksheet). I cannot see how/what control
will let me do this?

In my mind it is as simple as putting a "mini" spreadsheet on a form and
the only answer I could find is using "Office Web Components"

Could someone please confirm that this is the only (or best) solution or
as I said am I missing the point

Sean

P.S.
An even more attractive solution would be to have a "mini" MS Access
table on my form, but one step at a time

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Excel on a Form
 

Sean,
In your VB window go
"Tools" - "Additional Controls"
Add: Microsoft Office Spreadsheet #.# (I don't know what version you'll
have, I have 9.0)
If this doesn't meet your needs, there are many other additional controls to
try out.

Dan E

"Sean Howard" wrote in message
...
Boys and Girls,

Sometimes I wonder if I simply do not get this whole programming thing.

I have an application written in Excel VB. On one of my input forms I
want to have the user input information via a grid-like-input-region
(you know something like a worksheet). I cannot see how/what control
will let me do this?

In my mind it is as simple as putting a "mini" spreadsheet on a form and
the only answer I could find is using "Office Web Components"

Could someone please confirm that this is the only (or best) solution or
as I said am I missing the point

Sean

P.S.
An even more attractive solution would be to have a "mini" MS Access
table on my form, but one step at a time

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Excel on a Form
 

I have never used one, but I believe a flexgrid control does this (or
probably any control that has "grid" in its name).

Regards,
Tom Ogilvy


"Sean Howard" wrote in message
...
Boys and Girls,

Sometimes I wonder if I simply do not get this whole programming thing.

I have an application written in Excel VB. On one of my input forms I
want to have the user input information via a grid-like-input-region
(you know something like a worksheet). I cannot see how/what control
will let me do this?

In my mind it is as simple as putting a "mini" spreadsheet on a form and
the only answer I could find is using "Office Web Components"

Could someone please confirm that this is the only (or best) solution or
as I said am I missing the point

Sean

P.S.
An even more attractive solution would be to have a "mini" MS Access
table on my form, but one step at a time

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Excel on a Form
 

Thanks Dan E,

The "Microsoft Office Spreadsheet #.#" is the "Office Web Component" I
was refering to. I just was not sure if this was designed for specific
use on the web, or for general purposes?

I will run with this one then

Thanks again

Sean



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!