Linking spreadsheet to web page

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Frontpage Programming
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - how to set form fields for autoresponders tried everything.used form wizard for contact details.servers autoresponders won't work even with frontpage extentions installed.please help. all i want is save emailing nlist while at same time sending a follow up message automatically!seems impossible at moment. Tag: Linking spreadsheet to web page Tag: 64079
  - 2
    - FrontPage 2003 Training Anyone have a good training course for FrontPage 2003? Either online, disk or training center(east coast) -- Have A Great Day Bill Meyer Tag: Linking spreadsheet to web page Tag: 64076
  - 3
    - 80% of source code page blank I am having problems editing my website and found that the source code has a huge gap in it, on the home page. www.springhousecandles.com It shows up on explorer, but not on Mozilla. I have to edit through explorer. I edit right on the server, they told me to save the site on my computer or a disk, and they would fix it. Is there any way to fix this big gap without my server wiping out my website and me having to load it again? How do I save my site on a disk from the frontpage server? Think that I should have a back up. Thanks so much Tag: Linking spreadsheet to web page Tag: 64075
  - 4
    - Access hyperlinks not showing correctly I'm creating a database in Access that I want to link to a webpage using Frontpage. The database contains scholarship information, so I want to display the scholarship name on the webpage, but have it link to the PDF file that has a description of the scholarship. I've figured out how to get a hyperlink into an Access database field, but I am having problems with the results that are coming up on the webpage. I'm following the instructions that say to put the TITLE that you want the viewer to see, then a "#" sign, and then the FILENAME. What is coming up, though, on the webpage is the entire string. For example, I type into the database: John Smith Scholarship#smithscholarship.pdf. I want "John Smith Scholarship" to show on the webpage as a hyperlink and then link to the smithscholarship.pdf that is in the same folder. What shows on the webpage is "John Smith Scholarship#smithscholarship.pdf" as a hyperlink. How do I get rid of the file name? The second problem I'm having is linking to the PDF that is in the same folder as the database and webpage. I've tried using "John Smith Scholarship#smithscholarship.pdf" and "John Smith Scholarship#\smithscholarship.pdf" and "John Smith Scholarship#/smithscholarship.pdf." The only thing that works and links to the file is if I use the entire web address: ""John Smith Scholarship#http://myschool.com/smithscholarship.pdf" But there again, it shows the entire string on the webpage instead of just what I'm telling it to show for text, which is "John Smith Scholarship." I hope that all makes sense. Please tell me why it's not working. I've followed all the instructions in Access and Frontpage Help, I thought... Tag: Linking spreadsheet to web page Tag: 64074
  - 5
    - Graphics do not display Hi Everybody, A. I have Front Page 2002 SP3. B. I have WINDOWS XP with SP2 and Internet Explorer V9.0.2900. I have a large number of HTM files which I downloaded from the COREL graphics site over the years. Recently, I have found that when I open most of these files, the images do not display. They do not display in Internet Explorer, Front Page 2002, or Word XP. Yet at one time the images did indeed display along with the text. The original sub-folders with the same name still are in the same parent folder as the HTM file. Strangely enough, right clicking on the blank image and then clicking on properties, correctly identifies the image -- usually a JPEG or GIF. However, the only display within the file is a blank box with a red X. A few HTM files do open properly -- i.e. the images are displayed when the file is opened. Most do not. I can open the images in the sub-folder separately with a graphics program like Adobe PhotoShop. 1. What could have happened? 2. Is there a way to trouble shoot this problem? 3. Is there a way to tell the file to display the image along with the text? Thanks for any help and suggestions. Phil Tag: Linking spreadsheet to web page Tag: 64068
  - 6
    - Query Database with 2 dropdowns I am trying to create a webpage that will allow users to specifiy what data they would like to look at in a database by using two dropdown menus. I have followed the wonderful instructions at http://spiderwebwoman.com/tutorials/doubledropdown.htm. I can get it to work on the demo database, but not with my data base. The first page is grade. The users selects a grade level and the results are suppose to go to subject page. The page displays but the dropdowns are blank. Below are the SQL statements for each dropdown: "SELECT DISTINCT grade FROM StateAchievementStandards WHERE (grade='::grade::')" "SELECT DISTINCT subject FROM StateAchievementStandards WHERE (grade='::grade::')" I have gone over steps many times and I can't see why it isn't working. Hopefully somebody else can see my error. Thanks in advance the help. Tag: Linking spreadsheet to web page Tag: 64063
  - 7
    - Map to a network drive Hi, this the first time I have posted to this group. I am trying to create an easy method for end users to map to a network drive. Our current web-page development program is Frontpage. Is there an easy way in Frontpage to accomplish this or do I need to have some script. Currently, I have a link for each mapped drive so the user can open the mapped drive and then I give them the instructions on how to map to this drive, using the convential method of Tools--Map network drive--select drive letter--enter server name--enter directory. I am hoping there is an easy way to accomplish this. Thanks for your help..... Tag: Linking spreadsheet to web page Tag: 64060
  - 8
    - Map to a network drive Hi, this the first time I have posted to this group. I am trying to create an easy method for end users to map to a network drive. Our current web-page development program is Frontpage. Is there an easy way in Frontpage to accomplish this or do I need to have some script. Currently, I have a link for each mapped drive so the user can open the mapped drive and then I give them the instructions on how to map to this drive, using the convential method of Tools--Map network drive--select drive letter--enter server name--enter directory. I am hoping there is an easy way to accomplish this. Thanks for your help..... Tag: Linking spreadsheet to web page Tag: 64059
  - 9
    - Importing powerpoint slide as webpage theme I have a current powerpoint presentation slide that I would like to use a web page theme in sharepoint. I was thinking of using Frontpage 2003, to create a template and using in Sharepoint. Any other ideas ? Tag: Linking spreadsheet to web page Tag: 64057
  - 10
    - I'm tring to use front page & can't get access to work on the web I use to be able to work on my pages & now it won't let me in & doesn't ask for pass word or anything like that.I have my web master work on it & I'm the one who can't get in & even put front page new on my lap top & can't get in. I've ckd with the dsl paople & my web host & say everything is fine. Tag: Linking spreadsheet to web page Tag: 64052
  - 11
    - Adding a hotspot to an image makes F.P. blow up...any ideas?? When I add a hotspot to an image in Front Page, the program shuts down. Does anyone have any ideas why or how to fix this? Tag: Linking spreadsheet to web page Tag: 64051
  - 12
    - Sharing Conten in a cell. I want to have a cell on each page of my website that has the same content. For example sponsors of an event. I would like to be able to update this content in one location and have every page updated instead of having to update every page manually. How do I do this? Tag: Linking spreadsheet to web page Tag: 64042
  - 13
    - FP View of CSS Site I am trying to learn the use of CSS and am getting along slowly but surely. One issue I can't figure out is the design view in FP. I created a one page site from a template with CSS attached. Everything works fine but in the design view, the page appears as if there is not enough room on the 'table'. The text and buttons wrap to the next line and a strange column appears to the right of the area. When I click on preview, everything appears fine as does when I publish the site. If nothing else it has got me working a lot closer to the coding but it is a bit infuriating. Any enlightenment would be appreciated. Thanks in advance. Tag: Linking spreadsheet to web page Tag: 64041
  - 14
    - Print Direction I am using FrontPage 2003. I am creating a calendar page. In order for the calendar page to print correctly for someone visiting the site, it must be printed in "Landscape." Is there a way to set this as the default printing orientation for a page? Thank you Tag: Linking spreadsheet to web page Tag: 64036
  - 15
    - CSS & Images Hi, I've been wanting to experiment with use CSS's. Can you, and if so, how do you use CSS for images? -- TY Tag: Linking spreadsheet to web page Tag: 64034
  - 16
    - How do I retrieve deleated file from FrontPage? I was prompted to remove a file from FrontPage. I clicked "yes" and it removed the file permanently from my desktop. Tag: Linking spreadsheet to web page Tag: 64031
  - 17
    - Drop Down Buttons I am trying to put drop down buttons onto my webpage. Can anyone explain how do to do that? Tag: Linking spreadsheet to web page Tag: 64025
  - 18
    - Using added table I have added a new table to a database that I have been using. I created a new page to display that table using the Database Results wizard. It allowed me to select the new table and created the page with SQL referencing it. However, when I publish the page and try to access the table I get an error that says â??Database Results Wizard Error The operation failed. If this continues, please contact your server administrator. Well, Iâ??m the administrator and I donâ??t know why this is happening. Can you help. Tag: Linking spreadsheet to web page Tag: 64023
  - 19
    - Positioning graphic without absolute positioning I want to create a billboard on my web site and don't know how to position a graphic exactly without using layers. www.themilliondollarhomepage.com did this. As I can't write code, the 'source view' didn't help much. All I want is a header (masthead) and then all the graphics. Can anyone help? Tag: Linking spreadsheet to web page Tag: 64009
  - 20
    - FP Templates & Javascript/Image Rollovers I've made a nice banner with image rollovers for the top of my page in Adobe Photoshop 6/ImageReady. Since I have triple-digit number of pages to create/update, I made a dynamic template to help speed-up page creation and quicken page updates. I had ImageReady export the HTML and setup the display of the images in CSS (instead of making a table), plus it created some JavaScript to handle the rollovers. Everything works fine, except that the relative links (i.e.- images/bannerimgs/image_01.jpg) don't change to reflect where it is in the site's directory tree. Therefore, if I make the template off the root, then apply it to a page in a subdirectory, none of the relative links work because it's still showing the same path as if it was from the root. FrontPage will change the relative links in hyperlink tags in the page, but not in the JavaScript. The only work-around I've been able to come up with is to create multiple templates of the same template, just change the javascript relative URLs in each template depending on what page it will be applied to. This to me seems like an inefficient way of doing it. Is there any way of making the javascript code more "universal" while still maintaining the relative paths so that I can use just ONE template for all pages - even ones buried 2 to 3 subfolders deep? Is there a way to "fool" FrontPage? I'd rather avoid using static URLs. Tag: Linking spreadsheet to web page Tag: 64008
  - 21
    - Line and page numbers I have lost the running page and line numbers at the bottom of my documents. Tag: Linking spreadsheet to web page Tag: 64006
  - 22
    - Insert TreeView control Please give me instructions / sample of TreeView control inserted into web page using FP. I do have programming experience in using TreeView control in VB forms (non-web related). Tag: Linking spreadsheet to web page Tag: 64005
  - 23
    - Email confirmation - how's it done?? Hi Using FP2000 Does anyone know how to set up an email confirmation for a site? Like: New member supplies name and email address. Sends 'form'. When the user receives the email - they send it back so confirming that email address is valid. At some point I have got to include a password/login details. I'm new to this side of things. Is it done with JavaScript ? Any help would really be appreciated. Many thanks, Stephen Tag: Linking spreadsheet to web page Tag: 64002
  - 24
    - Sync Problems Using FP 2000 with a Linux ISP and Front Page Extensions enabled. I have been using this setup for some time but the file sync doesn't seem to function the way I thought it would. I have at least one file that always is uploaded even though this file has not changed in over 3 months. I updated another file with the same name but with a newer time stamp and it did not get uploaded. I had to change the name in order to force it to update. FP did recognize that the old file was still on the server and ask me if I wanted to remove it, so that works OK. I noticed there are about 40 files, images, button gifs, etc that are on the server but are not on my devl system any more, why don't these guys get deleted? Is there a way to synchronize these two systems so that only files currently in use are present on both systems? TIA, GWB Tag: Linking spreadsheet to web page Tag: 63989
  - 25
    - using Access database with FP2003 I'm starting an online store and I have many products and, therefore, many prices to keep track of. I have all my products, prices, etc stored in an Access database and I have already made the database connection with my site. Is there any way I can grab a specific price from my database and display it for a specific product on the product page in the website? So, in other words, is there a way I can type all my prices into my database, then have the prices on my website automatically update according to the changes I made in the database? Tag: Linking spreadsheet to web page Tag: 63987
- Next
  - 1
    - creating a gallery frontpage template I want to create a page where I can upload new pictures and text to my gallery page on my website through a browser using frontpage 2003 can anyone help me find the easist solution Tag: Linking spreadsheet to web page Tag: 63986
  - 2
    - creating a gallery frontpage template I want to create a page where I can upload new pictures and text to my gallery page on my website through a browser using frontpage 2003 can anyone help me find the easist solution Tag: Linking spreadsheet to web page Tag: 63985
  - 3
    - save image with double click instead of right click I am creating a website for a client who has European visitors to their site. They need to have a page that contains high resolutions images for their European visitors to download. They tell me that these European visitors cannot or will not use the "right-click, save picture as.." function. What they want is the ability to simple "double-click" on an image and have the "save as" dialog box pop up. I am desperate for an answer to this. Tag: Linking spreadsheet to web page Tag: 63981
  - 4
    - How do I expand on a word/sentence in a seperate box I want to be able to highlight a word or sentence so my visitors can click on this and an expanded explaination appears. Please help. Tag: Linking spreadsheet to web page Tag: 63978
  - 5
    - HTML and PHP link Hi I have a html form page created in FrontPage 2003 where a user adds there info on and then it is send via a php page but all it does is only pulling through the titles not the users info, for example The html form has the following on it; Title*: Mr Mrs Ms Miss (with radio buttons to select) First Name*: (with a text box for name) Surname*: (with text box for surname) Then this is part of the php that is working but it only e-mails the Titles not the text box info. <? $to = "casper@firetech.co.nz"; $subject = "Message from the FPIS Contact Page"; $msg = "Title:" . $contact_gendertitle . "\n\n"; $msg .= "First Name:" . $contact_firstname . "\n\n"; $msg .= "Surname:" . $contact_surname . "\n\n"; What can I do to get it to pull through the info in the text boxes Regards Casper Tag: Linking spreadsheet to web page Tag: 63977
  - 6
    - Frontpage 2003 Bug, IE6 Bug or Windows Font Bug? I have tried everything I can think of to figure this out. When I use Arial 1 (8 pt) for a vertical menu, and if the first character is a capital "W", when viewed in IE6, the first two stacked pixels forming the top left corner of the "W" are cutoff (cuts off pixels horizonally by one pixel). I have confirmed this by looking at the overlay files. Unfortunately, just editing the overlay files does not cure the problem. Can someone see if they can reproduce the problem. I am wondering if it is just my computer, or a bug in FP, IE, or Windows. Here are the steps (takes about two minutes, maybe less if you are a proficient FP user). 1) Start FP 2003, and create a new site using the Corporate Presence Wizard. Just keep clicking Next to get through the steps, and finally Finish. 2) After the site is created, go to Format, Theme, and select the Website Default Theme which is Journal. 3) Click the down arrow, and select Customize, click the Graphics button, then for item select "Vertical Navigation". Click the Font tab, and change the font to Arial size 1 (it is critical that this font be used, since the other fonts and sizes appear to be OK). 4) Click OK twice to save change, and rename theme to another temporary name. 5) Click the Website tab at the top, and click the Navigation button at the bottom. 6) Right click on "News", and select Rename. Change the name from "News" to "WNews". Make sure you use a capital "W", not lowercase. 7) Hit the F12 key to preview the page in the browser. Does your system cut the top left of the "W" off? Thanks everyone! Michael Tag: Linking spreadsheet to web page Tag: 63975
  - 7
    - Banner ad manager I want to increase the size of my banners, but when I follow the directions to access the banner ad manager by right clicking on a banner in page view I do not see the manager. Help! I am using Frontpage 2002. Gary Tag: Linking spreadsheet to web page Tag: 63968
  - 8
    - HIGHLIGHT SPOTS ON AN ARCHITECTURAL SITE PLAN I have a architectural site plan. There are 20 different thumbnail floor plans on one graphic. The graphic is black lines (floor plans) on a white background. I would like to when you mouse over each thumbnail floor plan, it highlights with a color. Then when you click on that thumbnail floor plan (which is highlighted with color) it will hyperlink to a more detailed floorplan. Is this possible? Thanks for your time, JD Tag: Linking spreadsheet to web page Tag: 63967
  - 9
    - Frontpage Upload Component Is there a way to increase the maximum file size that the FP upload component can handle? Say from 1 MB to 10MB? Tag: Linking spreadsheet to web page Tag: 63963
  - 10
    - Frontpage begineer's questions have several novice questions.. 1. I have windows XP, I thought it comes with frontpage, but I can not find it in my program files except for an empty folder named frontpage. So, do I have to still buy it? 2. What version should I buy, 2002 or 2003? 3. Where to buy it from, if I don't want it through free schemes? 4. My web hosting service supports only frontpage 2002, if I buy 2003, would it be a problem? Thanks. PV Tag: Linking spreadsheet to web page Tag: 63961
  - 11
    - mis aligned page I have one page that I do not know what is wrong. the bottom footer is continuing to duplicate to the right. My other pages, that are similar are ok. Any ideas what might be causing it? thanks JJ http://www.palielementary.org/cgi-bin/calendar/big_calendar.cgi Tag: Linking spreadsheet to web page Tag: 63954
  - 12
    - Email in Form code Hi, Since I am getting massive amounts of spam, I am changing all the email addresses to escapes - mail etc. It might help! But I noticed that in the code side of a FrontPage form, the email address shows up written normally. I wonder if it is possible to write the address, using the escape sequences, in the form properties, or to change them in the code (and still have them work!). Has anyone tried this, or have any thoughts on it? Or maybe have a better way? Thanks! J~ Tag: Linking spreadsheet to web page Tag: 63952
  - 13
    - table scrollbars I want scroll bars on the side of table, but when do it with <Div class="table"> I loose my formating, It does gives the scrollbars with the div tag. What do I need to change? Thanks JJ <table class="table"> <tr> <td class="odd" height="33"> <a target="_blank" href="xx.htm">2006</a></td> <td class="odd" height="33">2-25-06</td </tr> </table> -----CSS---- .table { border: 5px ridge #274573; color: #000000; border-collapse: collapse; padding: 0px; border: 1px; font-size: 100%; margin: 0px 0px 0px 80px; text-align: center; overflow: auto; height: 100px; } Tag: Linking spreadsheet to web page Tag: 63947
  - 14
    - Forms asks for password, why? After creating a form in frontpage and submitting it, it aks for a username and password. InCorrect uid & pw = You are not authorized to view this page Correct uid & pw = takes me to confirmation page. Any suggestions? Tag: Linking spreadsheet to web page Tag: 63943
  - 15
    - CI Host Information Hey......Anyone who has any information on CI Host please let me know or email it to me. I am going down on Monday to file a civil claim against them for Failure To Pay For Services Rendered and could use all the information I can get on CI Host, Creative Innovations, and Christopher Faulkner. Thanks in advance! Tara Tag: Linking spreadsheet to web page Tag: 63941
  - 16
    - Static Template Uses Absolute Pathnames! I'm new to FrontPage 2003. I created a static template for a new website. When I create a page using this template and look at the code I see absolute paths like: <link rel="stylesheet" type="text/css" href="file:///C:/Documents%20and%20Settings/user3/My%20Documents/My%20Webs/test/_private/default.css"> instead of <link rel="stylesheet" type="text/css" href="_private/default.css"> Obviously absolute paths mean nothing when published to a server. What am I doing wrong? FP2000 always used relative paths. My thanks to anyone who helps me out. Tag: Linking spreadsheet to web page Tag: 63940
  - 17
    - Is FP altering my form data? I've got a simple form on a site where people can send a plain text message. It all works OK except for the text field, which is a standard textarea. If the person types in, say, "I'd love to see you. Let's get together." the message is received like this: "I'd love to see you. Let's get together." The form data is all plain text, so this is baffling to me. Is this something in the code generated by FP? Tag: Linking spreadsheet to web page Tag: 63937
  - 18
    - FrontPage Form not posting I have a 2000 server with 2002 extensions installed. I am using FP 2003 to create and publish a form. The form works fine when published to a 2003 server, but only returns the same form each time submit is hit when published to the 2000 server. I have given the _private folder "everyone full controll" and am not using an email. The form post file is created, but no entires are posted to the file no mater how many times the form is submitted. Any ideas would be greatly appreciated!!! Tag: Linking spreadsheet to web page Tag: 63936
  - 19
    - Sharing files on wireless LAN I want to create a user friendly interface to shared files that are on my pc. I created a page in Frontpage with four links, each of them linking to a folder on my harddrive. The folder is set to share with others. What is the syntax to link to a shared folder? Any suggestions? Thank you so much Laura Tag: Linking spreadsheet to web page Tag: 63932
  - 20
    - Which code should I write to allow clip download from my website Hello, I'd like to know the code to write to allow visitors to download clips from my side. When you click on a given link, it will automatically open download box. Tag: Linking spreadsheet to web page Tag: 63929
  - 21
    - Shared Borders (FrontPage 2003) I recently upgraded from 2000 to 2003 using Server 2000. Also i installed the 2002 Extensions. Most of my pages using Shared Borders remained intact. But others are appearing as if the page contains three of everything on the page. This seems to be occurring only in the Root Web and not in Sub Webs. Tag: Linking spreadsheet to web page Tag: 63928
  - 22
    - IE 7 tabs What is the code for opening a new browser tab as opposed to a new window and is there an if tabbed browsing then ... else open new window? Tag: Linking spreadsheet to web page Tag: 63923
  - 23
    - How to create a "custom connection string" using OLEDB in Frontpag I am trying to connect to an ASA 9.02 database to create a data view. The OLE Provider is registered on the server that SharePoint is running on. I get an error that the list of databases can not retrieved. Have checked KB 831092. There is no details there. I think my main question is does OLEDB connection work for any DB ? I have checked various sites and have only seen problems reported, no fixes. Tag: Linking spreadsheet to web page Tag: 63920
  - 24
    - shared borders not working For some reason only the pages that I have linked and working on the live site have lost their shared borders. When I open them in FrontPage, they do not have a shared border on them. When I do a report of shared borders, all these pages have the shared borders listed, they just are not appearing on FrontPage. Also, I cannot save anything. Instead of just saving and updating, it has me rename it, then says that page already exists, can't overwrite it. Please help!! Thanks Tag: Linking spreadsheet to web page Tag: 63907
  - 25
    - How do I link to specific PowerPoint slides? Can anyone provide guidance on how to link to specific PowerPoint slides? I have a 180+ slide presentation and want to link to only a few slides at a time. For example, from a given web page I may want to (hyper)link to slides 36 through 45. Is it true that I must first save the presentation as HTML? Does that result in a single HTML file or several files? I'm asking in this group because I'm thinking a little coding, with which I have no experience, is required to pull this off. So, let me ask: How do I do it? Thanks for your help, folks. -Chuck Tag: Linking spreadsheet to web page Tag: 63904

I am currently creating multiple web pages that have drop down boxes and
textboxes. I need help linking the cells of my excel spreadsheet into the
drop down boxes and to the textboxes. I want to be able to select the item
out of the drop down box and the additional information auotmatically appears
in the textboxes. I am very new to vbscript and javascript so any
programming information is needed!!!! Thank You so much!!!!

Gary Holmes

Top

Re: Linking spreadsheet to web page by Stefan

Stefan
Thu Jun 22 03:21:13 CDT 2006

See http://support.microsoft.com/default.aspx?scid=268948

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________

"gholmesjr" <gholmesjr@discussions.microsoft.com> wrote in message news:8A71E747-7025-4918-BF50-FCCDD6B343B8@microsoft.com...
|I am currently creating multiple web pages that have drop down boxes and
| textboxes. I need help linking the cells of my excel spreadsheet into the
| drop down boxes and to the textboxes. I want to be able to select the item
| out of the drop down box and the additional information auotmatically appears
| in the textboxes. I am very new to vbscript and javascript so any
| programming information is needed!!!! Thank You so much!!!!
|
| Gary Holmes

Top