Asked by duncanb7
at 2024-10-26 16:07:21
Point:500 Replies:18 POST_ID:828396USER_ID:11059
Topic:
Visual Basic Programming;JavaScript;Microsoft Excel Spreadsheet Software
I have one junk2.htm file generated from Excel saveas file for htm format and open it in my IE
window. The junk.htm is same as junk.xls file also have three sheets which is link to D:/junk2.files/sheet001.htm, sheet002.htm, sheet003.htm that is
corresponding to icon name, "Inventory", "Workshop" and "Store" respectively in attached image.
And then I edit the htm file and put a html code of <meta http-equiv="refresh" content="10"> for auto refresh in junk2.htm . The auto refresh effect is active after 10 seconds, But the questionis it will alway switch back to the beginning page or sheets, "Sheet0001.htm("Inventory") ,no matter which sheets or page you are looking at after 10 seconds auto Refresh. After I check it , the problem might be whatever which page/sheet I click for view, the URL in address bar in IE is alway same like D:junk2.htm and never change to the corresponging link
THe question-1 is how to fix the problem describled above
THe question-2 is There is no problem when you hard click IE's refresh auto button which will
update webpage as your are viewing or looking at. Is the hard button click in IE is doing same
operation as <meta refresh > in html ?
And I try Javascript 's window.onload that also same problem and issue I describled above.
I guess the problem might be caued by auto refresh always refresh the junk2.htm not
refresh viewing page so that it will go back to junk2.htm 's beginning page("Inventory" sheet)
Is there any Java script function to solve this completely ?
Why I need to do auto-refresh that is because finally I will ftp update/lastest junk2.htm to my external website domain ; the junk2.xls will updated for every 30 seconds and save as junk2.htm and ftp it the website in VBA program and putting <meta refresh> is also done in the VBA program
Hope you will understand my question and view my attahced image file
Please duncan
window. The junk.htm is same as junk.xls file also have three sheets which is link to D:/junk2.files/sheet001.htm, sheet002.htm, sheet003.htm that is
corresponding to icon name, "Inventory", "Workshop" and "Store" respectively in attached image.
And then I edit the htm file and put a html code of <meta http-equiv="refresh" content="10"> for auto refresh in junk2.htm . The auto refresh effect is active after 10 seconds, But the questionis it will alway switch back to the beginning page or sheets, "Sheet0001.htm("Inventory") ,no matter which sheets or page you are looking at after 10 seconds auto Refresh. After I check it , the problem might be whatever which page/sheet I click for view, the URL in address bar in IE is alway same like D:junk2.htm and never change to the corresponging link
THe question-1 is how to fix the problem describled above
THe question-2 is There is no problem when you hard click IE's refresh auto button which will
update webpage as your are viewing or looking at. Is the hard button click in IE is doing same
operation as <meta refresh > in html ?
And I try Javascript 's window.onload that also same problem and issue I describled above.
I guess the problem might be caued by auto refresh always refresh the junk2.htm not
refresh viewing page so that it will go back to junk2.htm 's beginning page("Inventory" sheet)
Is there any Java script function to solve this completely ?
Why I need to do auto-refresh that is because finally I will ftp update/lastest junk2.htm to my external website domain ; the junk2.xls will updated for every 30 seconds and save as junk2.htm and ftp it the website in VBA program and putting <meta refresh> is also done in the VBA program
Hope you will understand my question and view my attahced image file
Please duncan
Attachment:Snap5.jpg
