+ Reply to Thread
Results 1 to 12 of 12

Can you embed a picture into a workbook and then save and publish it as a web page?

  1. #1
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2021
    Posts
    982

    Can you embed a picture into a workbook and then save and publish it as a web page?

    Exactly what it says on the tin.
    Last edited by Marvo; 10-05-2020 at 06:14 AM.

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Can you embed a picture into a workbook and then save and publish it as a web page?

    are you talking about what you see in the image below, transformed into HTML code like this?
    Please Login or Register  to view this content.
    Attached Images Attached Images

  3. #3
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2021
    Posts
    982

    Re: Can you embed a picture into a workbook and then save and publish it as a web page?

    I use wix for my website. You just save the excel page as a webpage, then publish, view source, select all, then transfer the HTML into a HTML box and Voila, your excel page is on the internet. However if your excel page has a picture that doesn't come through so I have to put the pictures in separately and match them up. Easier said than done as the picture size to fit the excel page on my computer doesn't fit the excel page once published on my website so you end up fiddling about and often the picture gets distorted or accidentally moved as it is sitting ON the webpage rather than IN it. That's why I asked the question.

    Thank you for your response.

  4. #4
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2021
    Posts
    982

    Re: Can you embed a picture into a workbook and then save and publish it as a web page?

    Attachment 698165

    This si what I get instead of a picture

  5. #5
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Can you embed a picture into a workbook and then save and publish it as a web page?

    i can't view attachments when you upload the the way you did. see the image below. when i click the attachment link, this is what i see. can you do it another way please? thanks. by the way, if an image doesn't come through and transact reasonably when ""publishing"" like you say, more than likely it's a consequence of how images are stored inside of an excel file. if all else is fine, then the way excel is built and what kind of container inside of excel holds data is obviously not the issue. but i cant say for sure, as I've never done what you're trying to do.
    Attached Images Attached Images

  6. #6
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2021
    Posts
    982

    Re: Can you embed a picture into a workbook and then save and publish it as a web page?

    I'm not sure this will help but I don't know how else to show you.

    Page 1 is what I start with

    Page 2 is the HTML

    Page 3 is a screenshot of what I end up with (no picture)
    Attached Files Attached Files

  7. #7
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Can you embed a picture into a workbook and then save and publish it as a web page?

    Ok Marvo,

    I don't know what process you are going through here, but here is what I did. the thing showed up just fine for me in a browser for testing purposes, but there are obviously may ways to do this. Here is the process I went through: https://smallbusiness.chron.com/publ...eet-41996.html

    and here is explanation of the images below:

    1) opening the testing published page in FF
    2) proof that the worksheet looks fine in FF when testing it
    3) apparent proof that the published page keeps images as actual objects on the webpage. right click menu recognizes it as an image
    4) warning from excel about lost features when publishing an .HTM
    5) last dialog when publishing
    6) apparent proof that the published page is created with web client side code outside of the images. right click menu recognizes these areas as source code
    7) files that the publishing process generates (one duplicate was created for each picture on the worksheet)
    8) the XML code generated by the publishing process

    images 1-5 are in this post. 6-8 are in the following post.

    does any of this help?
    Attached Images Attached Images
    Last edited by vba_php; 10-04-2020 at 09:51 PM.

  8. #8
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Can you embed a picture into a workbook and then save and publish it as a web page?

    ..................
    Attached Images Attached Images

  9. #9
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2021
    Posts
    982

    Re: Can you embed a picture into a workbook and then save and publish it as a web page?

    Many thanks for taking so much time.

    When I publish the webpage it looks fine, just great. However when I transfer it into the HTML box the pictures disappear. I'm guessing WIX don't support that facility. I'm going to send them a request, see what they say.

  10. #10
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2021
    Posts
    982

    Re: Can you embed a picture into a workbook and then save and publish it as a web page?

    With WIX, you can transfer HTML and you can transfer an image but you cant transfer the image within the HTML. Bit annoying but there you go. Free website builder so.

  11. #11
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Can you embed a picture into a workbook and then save and publish it as a web page?

    Quote Originally Posted by Marvo View Post
    However when I transfer it into the HTML box the pictures disappear.
    clarify that? I've never used WIX, nor will I ever, but I do know it's free. thus, it should have limitations.

  12. #12
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2021
    Posts
    982

    Re: Can you embed a picture into a workbook and then save and publish it as a web page?

    It's actually very good considering its free. I run a website for my golf society and it does the job.

    Anyway, on the site it allows you to embed an HTML page. It also allows you to display an image. However although the picture shows up on my web browser when publishing, it doesn't when transferred to the WIX website. I have sent them a message, maybe they can come up with a solution.

    Anyway the answer to my original question is yes you can embed a picture into a workbook so I'll mark the thread as solved.

    Many thanks for taking the time to try and help, it was much appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel Macro to insert picture and embed with workbook
    By Must06 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-18-2019, 08:01 PM
  2. Publish as web page
    By htmeltel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-21-2017, 10:58 AM
  3. Save picture located in workbook to .jpg file
    By PENGUIN88 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-13-2016, 05:39 AM
  4. Replies: 0
    Last Post: 09-04-2014, 11:03 PM
  5. Macro to open embed excel workbook & save it on desktop
    By bonny24tycoon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-02-2012, 12:12 PM
  6. Publish - Page Setup
    By Jon_Sarge in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2008, 11:04 PM
  7. [SOLVED] Difference between Publish and Save As Web Page in Excel 2002
    By johng36 in forum Excel General
    Replies: 2
    Last Post: 02-04-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1