I sort of learned that from the Excel Bible, which noted that you can't save Excel directly as jpgs and suggested a similar methodology. How are you saving Excel charts and tables in html compatible format?

Sometimes I want to save a chart in Excel as an image and have to paste them first into Word or Powerpoint, which gives the image options under "paste special", then back into Excel. Any better ways to do it?

That's exactly how I do it. I haven't figured a better way. It is a wicked pain. I just had never been able to do it with PDF.

With tables I use an option that ends up being PNG I think it is, it gives better large image quality than JPEG. Other times I use bitmap option. But mostly it is the Windows enhanced metafile, I think. I never use the paste as excel object option, it always screws things up. I always post into Word with images and then access image in separate folder like you laid out.