View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Adding meta tags to Excel web pages?

Don't know about anything directly, but you could do it in the _BeforeSave
event.
- .SaveAs HTML
- Open TheFile For InPut As #Num
- Read the text file
- Edit with your meta tags
- Write back to disk
- Cancel=True to cancel Excel's save

NickHK

"MelB" wrote in message
ups.com...
Does anyone know a way of including a META tag within a saved
spreadsheet? I have a macro that creates an HTML file. I need to add
one tag to get the web page to refresh every 10 minutes, however once
the web page is republished the code is overwritten.
<meta http-equiv="Refresh" content="600"