View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Derek Bliss[_2_] Derek Bliss[_2_] is offline
external usenet poster
 
Posts: 7
Default Save As HTM with "align=Left" in HTM file code

Hello Everyone,

Excel 2007

Is it possible when creating an HTM file, through VBA, to set the
"align=left" instead of the default "align=center". I've read some code with
sending to an email where the file is exported to a temp directory, reopened
with a replace command and then copied into an email but this is not possible
because the files are being saved to a website. So I need Excel to put this
option in when it is saving the file.

Thanks
Derek