Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - General Queries (http://www.outlookbanter.com/outlook-general-queries/)
-   -   Excel as folder home page in Outlook2003 (http://www.outlookbanter.com/outlook-general-queries/27422-excel-folder-home-page-outlook2003.html)

tee September 19th 06 06:20 AM

Excel as folder home page in Outlook2003
 
i want to open an Excel file as default home page for a folder
in outlook 2003.

I went to home page tab of the properties of that folder and
gave the excel path as well as Show the page check box as clicked.

But i am not able to view the Excel sheet. Instead some garbage
values are coming. But i am able to see .htm files and .xml files.

What should i do to see the excel file? is the security features
are the problem for Outlook2003 also?


Diane Poremsky September 19th 06 06:29 AM

Excel as folder home page in Outlook2003
 
You cannot view certain files types as folder homepages and AFAIK, excel is
one of the types that is not supported.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

"tee" wrote in message
ups.com...
i want to open an Excel file as default home page for a folder
in outlook 2003.

I went to home page tab of the properties of that folder and
gave the excel path as well as Show the page check box as clicked.

But i am not able to view the Excel sheet. Instead some garbage
values are coming. But i am able to see .htm files and .xml files.

What should i do to see the excel file? is the security features
are the problem for Outlook2003 also?



tee September 20th 06 06:19 AM

Excel as folder home page in Outlook2003
 
Thank you Diane..

I tried the following code
app = New Excel.Application
wb = app.Workbooks.Open("E:\Book1.xls", 0, False, 5, "",
"", False, Excel.XlPlatform.xlWindows, "", True, False, 0, True, False,
False)
app.Visible = True

Now excel is opening outside of outlook as a separate window.
But I want to get this Excel to be opened within outlook.
Any way to open it inside outlook?
Is this possible in any version of outlook?

Diane Poremsky wrote:

You cannot view certain files types as folder homepages and AFAIK, excel is
one of the types that is not supported.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

"tee" wrote in message
ups.com...
i want to open an Excel file as default home page for a folder
in outlook 2003.

I went to home page tab of the properties of that folder and
gave the excel path as well as Show the page check box as clicked.

But i am not able to view the Excel sheet. Instead some garbage
values are coming. But i am able to see .htm files and .xml files.

What should i do to see the excel file? is the security features
are the problem for Outlook2003 also?



Sue Mosher [MVP-Outlook] September 20th 06 12:50 PM

Excel as folder home page in Outlook2003
 
As Diane said, an Excel worksheet cannot operate as a folder home page. You could, however, embed the Microsoft spreadsheet control in a web page and display the worksheet by that means.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"tee" wrote in message oups.com...
Thank you Diane..

I tried the following code
app = New Excel.Application
wb = app.Workbooks.Open("E:\Book1.xls", 0, False, 5, "",
"", False, Excel.XlPlatform.xlWindows, "", True, False, 0, True, False,
False)
app.Visible = True

Now excel is opening outside of outlook as a separate window.
But I want to get this Excel to be opened within outlook.
Any way to open it inside outlook?
Is this possible in any version of outlook?

Diane Poremsky wrote:

You cannot view certain files types as folder homepages and AFAIK, excel is
one of the types that is not supported.


"tee" wrote in message
ups.com...
i want to open an Excel file as default home page for a folder
in outlook 2003.

I went to home page tab of the properties of that folder and
gave the excel path as well as Show the page check box as clicked.

But i am not able to view the Excel sheet. Instead some garbage
values are coming. But i am able to see .htm files and .xml files.

What should i do to see the excel file? is the security features
are the problem for Outlook2003 also?



tee September 25th 06 12:27 PM

Excel as folder home page in Outlook2003
 
thank you so much.
now i am able to open excel at folder homepage by the method you said.
but the graphical representations like charts in excel are not shown
when it is embedded in webpage.
Can you suggest any method to acheive the same.

thanks in advance.

Sue Mosher [MVP-Outlook] wrote:

As Diane said, an Excel worksheet cannot operate as a folder home page. You could, however, embed the Microsoft spreadsheet control in a web page and display the worksheet by that means.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"tee" wrote in message oups.com...
Thank you Diane..

I tried the following code
app = New Excel.Application
wb = app.Workbooks.Open("E:\Book1.xls", 0, False, 5, "",
"", False, Excel.XlPlatform.xlWindows, "", True, False, 0, True, False,
False)
app.Visible = True

Now excel is opening outside of outlook as a separate window.
But I want to get this Excel to be opened within outlook.
Any way to open it inside outlook?
Is this possible in any version of outlook?

Diane Poremsky wrote:

You cannot view certain files types as folder homepages and AFAIK, excel is
one of the types that is not supported.


"tee" wrote in message
ups.com...
i want to open an Excel file as default home page for a folder
in outlook 2003.

I went to home page tab of the properties of that folder and
gave the excel path as well as Show the page check box as clicked.

But i am not able to view the Excel sheet. Instead some garbage
values are coming. But i am able to see .htm files and .xml files.

What should i do to see the excel file? is the security features
are the problem for Outlook2003 also?




Sue Mosher [MVP-Outlook] September 25th 06 01:11 PM

Excel as folder home page in Outlook2003
 
Not really an Outlook question, but I think there is a separate chart web component. Please refer to the Excel help topic "Putting Microsoft Excel data on the Web".

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"tee" wrote in message ups.com...
thank you so much.
now i am able to open excel at folder homepage by the method you said.
but the graphical representations like charts in excel are not shown
when it is embedded in webpage.
Can you suggest any method to acheive the same.

thanks in advance.

Sue Mosher [MVP-Outlook] wrote:

As Diane said, an Excel worksheet cannot operate as a folder home page. You could, however, embed the Microsoft spreadsheet control in a web page and display the worksheet by that means.

"tee" wrote in message oups.com...
Thank you Diane..

I tried the following code
app = New Excel.Application
wb = app.Workbooks.Open("E:\Book1.xls", 0, False, 5, "",
"", False, Excel.XlPlatform.xlWindows, "", True, False, 0, True, False,
False)
app.Visible = True

Now excel is opening outside of outlook as a separate window.
But I want to get this Excel to be opened within outlook.
Any way to open it inside outlook?
Is this possible in any version of outlook?

Diane Poremsky wrote:

You cannot view certain files types as folder homepages and AFAIK, excel is
one of the types that is not supported.


"tee" wrote in message
ups.com...
i want to open an Excel file as default home page for a folder
in outlook 2003.

I went to home page tab of the properties of that folder and
gave the excel path as well as Show the page check box as clicked.

But i am not able to view the Excel sheet. Instead some garbage
values are coming. But i am able to see .htm files and .xml files.

What should i do to see the excel file? is the security features
are the problem for Outlook2003 also?





All times are GMT +1. The time now is 12:51 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com