Displaying Office File in VB Form

Question

Upon opening an office file (i.e. Word., Powerpoint, Excel, Access, etc), is it possible to do the following:

 

1) Display in Userform (WebControl or other control)?

2) Manuipulate while in the userform?

 

 

Thanks

RK

Answer 1

For definate with excel. you can embed a spreadsheet within a user form.

 

That said, for licensing purposes you still need to have the office application installed on the machine.  You can just go distributing these office assemblies.

 

Answer 2

Office would alway be installed on these systems.  I could test for this as well if need be.  So how do you pull the Excel file into the userform.  Don't think I want to use a datagrid. Would actually like to see the actual spreadsheet in the form.  Would I use a Web Control?

 

EM

Answer 3

On a machine with Office Installed.

 

You can right click the toolbox, click "customize toolbox", add the Microsoft Office Excel 10.0 COM component (Or whatever version of office is installed) and you now get a control in you toolbox which you can add to the form

 

You can control this using the Excel Object model.

 

 

Answer 4

Sorry to be more specific, which control do I use?

 

EM