 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Publisher / Web Design / May 2008puting excel functions into websites
I have made a small spreadsheet in excel that can calcualate clothes sizes when inputing various measurements. Is there a way of tranfering this to a publisher website that enables users to input values on the webpage and then using the excel functions to carry out calculations? (office 2003) I kind of doubt it. Publisher produces static pages. You can add some dynamic functionality using the insert html code fragment tool and inserting javascript, CSS snippets, and other code snippets but I think the type of functionality you are hoping for is beyond the scope of Publisher web pages. Might be time to look to a different program to build your site... DavidF >I have made a small spreadsheet in excel that can calcualate clothes sizes > when inputing various measurements. Is there a way of tranfering this to a > publisher website that enables users to input values on the webpage and > then > using the excel functions to carry out calculations? (office 2003) Thanks for the reply. Would I be able to put such functionality into frontpage? If so how can I open my publisher file in frontpage Rob is a MS Web Expression MVP, and also knows FrontPage...wait until he comes around to answer whether you can do this in FrontPage, but it certainly is more likely than Publisher...or post your question in the FP newsgroup. As per importing Publisher web pages into FP...don't waste the time trying. The code is way different and it will be faster to rebuild it than trying to fix the code. Sorry. DavidF > Thanks for the reply. Would I be able to put such functionality into > frontpage? If so how can I open my publisher file in frontpage If you are ambitious and understand excel basic macro codes: Try converting to JAVA script and inserting as an html fragment. Link below is tool to conversions http://www.jeffheaton.com/java/vbjava.shtml Spike > Thanks for the reply. Would I be able to put such functionality into > frontpage? If so how can I open my publisher file in frontpage You can open your Publisher generated website in FP, but the code is incredibly difficult to work with...much faster to redesign it in FP.  Signature~~~~~~~~~~~~~~~~~~ Rob Giordano Microsoft MVP Expression > Thanks for the reply. Would I be able to put such functionality into > frontpage? If so how can I open my publisher file in frontpage OK...but will the OP be able to get an excel spreadsheet to work as desired in FP or WE? DavidF > You can open your Publisher generated website in FP, but the code is > incredibly difficult to work with...much faster to redesign it in FP. > >> Thanks for the reply. Would I be able to put such functionality into >> frontpage? If so how can I open my publisher file in frontpage Actually, if you publish your Excel spreadsheet as a web page with the interactivity option turned on, you can upload that page to your server. You can put a link from Publisher to that file. The users can make changes and the functions still work. If you need help on how to publish Excel as a webpage, you can post back or e-mail me at Sarah@SummitCTS.com. > OK...but will the OP be able to get an excel spreadsheet to work as desired > in FP or WE? [quoted text clipped - 6 lines] > >> Thanks for the reply. Would I be able to put such functionality into > >> frontpage? If so how can I open my publisher file in frontpage Thanks Sarah. I can count this as something new I learned today. DavidF > Actually, if you publish your Excel spreadsheet as a web page with the > interactivity option turned on, you can upload that page to your server. [quoted text clipped - 15 lines] >> >> Thanks for the reply. Would I be able to put such functionality into >> >> frontpage? If so how can I open my publisher file in frontpage Glad to help! If you want to see it, I posted a VERY rough Excel spreadsheet on a dummy page on our site... www.summitcts.com/index_files/update.htm. > Thanks Sarah. I can count this as something new I learned today. > [quoted text clipped - 19 lines] > >> >> Thanks for the reply. Would I be able to put such functionality into > >> >> frontpage? If so how can I open my publisher file in frontpage INFO: I have office 2007 on vista Here is the message I get To use this Web page interactively, you must have Microsoft® Internet Explorer 5.01 Service Pack 2 (SP2) or later and the Microsoft Office 2003 Web Components. If your target audience is not using office 2003, looks like it may be a problem Spike > Glad to help! If you want to see it, I posted a VERY rough Excel > spreadsheet [quoted text clipped - 27 lines] >> >> >> into >> >> >> frontpage? If so how can I open my publisher file in frontpage Thanks. Interestingly I get the same result as Spike. I am running XP SP2 and IE6, but apparently I need to install "the Microsoft Office 2003 Web Components"? True? DavidF > Glad to help! If you want to see it, I posted a VERY rough Excel > spreadsheet [quoted text clipped - 27 lines] >> >> >> into >> >> >> frontpage? If so how can I open my publisher file in frontpage Hmmm... Not really sure... I have XP SP2 and IE6, but I don't get any messages when I open click on the link to the spreadsheet. I have both Excel 03 and 07 on this machine. I will try it on one of my office computers and see if I get any messages like that. Sorry I can't be more help at the moment! > Thanks. Interestingly I get the same result as Spike. I am running XP SP2 > and IE6, but apparently I need to install "the Microsoft Office 2003 Web [quoted text clipped - 33 lines] > >> >> >> into > >> >> >> frontpage? If so how can I open my publisher file in frontpage No problem. When I get the message I am also given a link to "Office 2003 Add-in: Office Web Components": http://www.microsoft.com/downloads/details.aspx?FamilyId=7287252C-402E-4F72-97A5 -E0FD290D4B76&displaylang=en Rob may be correct about needing Excel 2003. Sounds like the download will let you view but not interact: "...By installing the Office Web Components tool, users can view published components and data access pages on the Web without having to install Office 2003. Note: If you do not own an Office 2003 license, the Office Web Components are licensed to be used in static, non-interactive, client-side, view-only mode. If you do own an Office 2003 license, the Office Web Components are licensed to be used in interactive mode." Just having Pub 2003 installed which is supposedly part of the Office family, may not be enough either... DavidF > Hmmm... > [quoted text clipped - 51 lines] >> >> >> >> into >> >> >> >> frontpage? If so how can I open my publisher file in frontpage tis true, and the viewer would need to have Excel as well (I believe), that's why I said "kinda doubt it" in my earlier (non-verbose) post. Signature~~~~~~~~~~~~~~~~~~ Rob Giordano Microsoft MVP Expression > Thanks. Interestingly I get the same result as Spike. I am running XP SP2 > and IE6, but apparently I need to install "the Microsoft Office 2003 Web [quoted text clipped - 35 lines] >>> >> >> into >>> >> >> frontpage? If so how can I open my publisher file in frontpage After going back and reading the description of the download again, it sounds like you are mostly correct. You can watch, but you can't play....seems kind of cruel ;-) DavidF > tis true, and the viewer would need to have Excel as well (I believe), > that's why I said "kinda doubt it" in my earlier (non-verbose) post. [quoted text clipped - 39 lines] >>>> >> >> into >>>> >> >> frontpage? If so how can I open my publisher file in frontpage kinda doubt it Signature~~~~~~~~~~~~~~~~~~ Rob Giordano Microsoft MVP Expression > OK...but will the OP be able to get an excel spreadsheet to work as > desired in FP or WE? [quoted text clipped - 6 lines] >>> Thanks for the reply. Would I be able to put such functionality into >>> frontpage? If so how can I open my publisher file in frontpage Thanks. DavidF > kinda doubt it > [quoted text clipped - 8 lines] >>>> Thanks for the reply. Would I be able to put such functionality into >>>> frontpage? If so how can I open my publisher file in frontpage
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.