ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Adding meta tags to Excel web pages? (https://www.excelbanter.com/excel-programming/379271-adding-meta-tags-excel-web-pages.html)

MelB[_2_]

Adding meta tags to Excel web pages?
 
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"


NickHK

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"





All times are GMT +1. The time now is 12:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com