Programmatically opening Microsoft Excel using Access 2

[dleiba]

Hey guys,

Yet another question to hopefully challenge the brain.

I know it is possibly to open an Excel workbook from within access using the Shell() command.

However, I do not want the user to have access to the default menus and toolbars available in Microsoft Excel.

1) Is there a way to programmatically disable these menus and toolbars for that specific workbook file from within Access?

2) If not, is it possible to open the spreadsheet in a window from within Access (showing only the spreadsheet and no menus or toolbars)?

Once again, any help would be greatly appreciated!

Thanks

 

[Gzep]

Hi.

Check out CreateObject(). oddly enough, it has a heap of examples and explanations!
Your code can run Excel by itself.

eg:
Dim ExcelSheet As Object
Set ExcelSheet = CreateObject("Excel.Sheet&quot

alternatively there is an activeX control called:
Microsoft Office Spreadsheet 9.0
This control inserts a spreadsheet control into your
access form.

Gzep, SOF

 

[dleiba]

Gzep,

Thanks for your response.

I tried the ActiveX Control method you suggested and inserted a spreadsheet control on my form.

The concept is exactly what I was looking for.

I have one question however.

The ActiveX Control brings up a NEW spreadsheet. How do I reference an EXISTING spreadsheet and display it in a similar fashion?

Please let me know...Thanks once again!

Dominic Leiba

 

[KenG]

Look at the object browser for the Excel object.
That's how I learn a lot about how to control Excel, or other ActiveX objects.

 

[Databaseguy]

There's Create and Get. You want to use the GetObject method.

Note, make sure you set reference the MS Excel 8.0 (or 9) object library or the properties and methods won't be available in the VBE. Tools/References from the VBE

Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy