I am saving a spreadsheet as a web page. I want to set the margins to zero. While I can do this in page setup, the web page still displays a margin.
Does anyone know a way around this?
I am saving a spreadsheet as a web page. I want to set the margins to zero. While I can do this in page setup, the web page still displays a margin.
Does anyone know a way around this?
Is it regarding the right,left margins or the header margins???
If i am not wrong, it is about the header margins, because, in htm, there is no right margin concept involved.
Yes about the upper margin, this happens because when excel creates an HTM page it creates pretty badly (My personal experience after working extensively with this feature, if anyone has better, please share your good experience)
If that is what troubling you, try code and suggestions in following link, it works really fine, and you will really understand, why the excel to htm process is really bad one. (Nothing personal about existing process, but it generates lot of crab html :()
http://myweb.tiscali.co.uk/xlvba/excelvba/tips/index.htm
Hi Dave, Could not find anything on ozgrid with "export+html" search
This kind of stuff is worth having on our site as well, What Say???
Hi yjoshi
RE: This kind of stuff is worth having on our site as well, What Say???
Absolutely :thumbcoo:
Thanks yjoshi
I agree about Microsft's export to web functions being rubbish. I normally avoid them, but this is one instance where it is the simplest method to create the pages.
I'll take a look at Rob's website.
Don’t have an account yet? Register yourself now and be a part of our community!