Excel workbook in Webpage
Author
Discussion

tim2100

Original Poster:

6,288 posts

281 months

Thursday 27th May 2004
quotequote all
Help

I need to put an excel workbook on one of our intranet pages.
I can't save the worbook in html as it has macro's in there that need to run, depending which project is selected.

I could set this up as a link, but ideally I would like to have the excel book within the actual page.

Can I do this?

Tim.

KITT

5,345 posts

265 months

Thursday 27th May 2004
quotequote all
You may be abble to use the embed tag:

www.willcam.com/cmat/html/other.html#Embed

and specify the src="whatever.xls" property to be the Excel file you want to embed. Not sure though as I've never needed to do it!

miniman

29,465 posts

286 months

Thursday 27th May 2004
quotequote all
Do all the users have Excel installed? If so, I think you can just link to the file from another page and it should open up in IE. We have this on our intranet and it works fine. Some users might, I suppose, get a "Download or Open" message.

anonymous-user

78 months

Thursday 27th May 2004
quotequote all
The two ways to get the excel sheet to actually appear "in" the page, as in surrounded by the rest of the page, are to use an iframe, or use Micosoft's Office Web Components.

In the case of an iframe, you just point the src attribute at the excel file and it will be opened up in the frame, assuming the client pc has Excel installed.

With OWC, you can use an <OBJECT> tag in the HTML to point to the Excel workbook. You can also use the Codebase attribute on an Intranet to point to an office installation directory in the event that OWC aren't installed on the client. I believe that OWC have the additional benefit in that you can script them in VBScript/JavaScript.