[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

Adding meta tags to Excel web pages?

MelB

12/12/2006 4:41:00 PM

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">

1 Answer

NickHK

12/13/2006 2:54:00 AM

0

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" <mel.boulds@ricoh-rpl.com> wrote in message
news:1165941637.562167.123480@16g2000cwy.googlegroups.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">
>