Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

<meta http-equiv="refresh" content="10"> in htm file generated by Excel save as with VBA

Avatar of duncanb7
duncanb7 asked on
Visual Basic ClassicHTMLScripting Languages
16 Comments1 Solution1864 ViewsLast Modified:
Dear Expert,

I would like to ask one question, In one task, I have saved my excel file into
htm format in Excel Window by saveas  , it means  my junk2.xls convert into junk2.htm and then I
edit the junk2.htm and put the html statement of <meta http-equiv="refresh" content="10">
into junk2.htm in order to reshresh the webpage each 10 seconds.
I  read junk2.htm after the  file modification in  IE explorer  and see the 10 second rehresh effect.
But the question, when I click and read  sheet of "workshop" or "Store", in other words,  I stay on them to read/view as my viewing webpage . But my viewing webpage will go back the first page sheet of " Inventory" by and after  the refresh, so the viewing wbepage will be "invertory" sheet now , so that I need to click back  the sheet of "workshop" again but that is not okay  because that reshresh will activate the first page that will make me trouble when I am looking seond  or third sheet  of "Workshop" and "Store" at that time.

THe question, is it related to the meta rehresh statement in wrong pasition in junk2.htm ? SO that
the viewing webpage will always go back to the first page of "Inventory" after refresh
Please help review the top of code junk.html source code attached and read the
atttached image and you see the icon for sheet of "Inverotry", "Workshop" and "Store", you understand what I am asking

Please advise

Duncan


<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv="refresh" content="10">


<meta name="Excel Workbook Frameset">
<meta http-equiv=Content-Type content="text/html; charset=big5">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<link rel=File-List href="junk2.files/filelist.xml">
<link rel=Edit-Time-Data href="junk2.files/editdata.mso">
<link rel=OLE-Object-Data href="junk2.files/oledata.mso">
<!--[if gte mso 9]><xml>
 <o:DocumentProperties>
  <o:Author>duncan</o:Author>
  <o:LastAuthor>duncan</o:LastAuthor>
  <o:Created>2010-10-09T18:20:58Z</o:Created>
  <o:LastSaved>2010-10-26T14:11:42Z</o:LastSaved>
  <o:Version>11.9999</o:Version>
 </o:DocumentProperties>
 <o:OfficeDocumentSettings>
  <o:Colors>
   <o:Color>
    <o:Index>14</o:Index>
    <o:RGB>#DDDDDD</o:RGB>
   </o:Color>
  </o:Colors>
 </o:OfficeDocumentSettings>
</xml><![endif]--><![if !supportTabStrip]>
<link id="shLink" href="junk2.files/sheet001.htm">
<link id="shLink" href="junk2.files/sheet002.htm">
<link id="shLink" href="junk2.files/sheet003.htm">

<link id="shLink">

<script language="JavaScript">
<!--
 var c_lTabs=3;

 var c_rgszSh=new Array(c_lTabs);
 c_rgszSh[0] = "Inventory";
 c_rgszSh[1] = "workshop";
 c_rgszSh[2] = "Store";



 var c_rgszClr=new Array(8);
 c_rgszClr[0]="window";
 c_rgszClr[1]="buttonface";
 c_rgszClr[2]="windowframe";
 c_rgszClr[3]="windowtext";
 c_rgszClr[4]="threedlightshadow";
 c_rgszClr[5]="threedhighlight";
 c_rgszClr[6]="threeddarkshadow";
 c_rgszClr[7]="threedshadow";

 var g_iShCur;
 var g_rglTabX=new Array(c_lTabs);

function fnGetIEVer()
{
 var ua=window.navigator.userAgent
 var msie=ua.indexOf("MSIE")
 if (msie>0 && window.navigator.platform=="Win32")
  return parseInt(ua.substring(msie+5,ua.indexOf(".", msie)));
 else
  return 0;
}

function fnBuildFrameset()
{
 var szHTML="<frameset rows=\"*,18\" border=0 width=0 frameborder=no framespacing=0>"+
  "<frame src=\""+document.all.item("shLink")[0].href+"\" name=\"frSheet\" noresize>"+
  "<frameset cols=\"54,*\" border=0 width=0 frameborder=no framespacing=0>"+
  "<frame src=\"\" name=\"frScroll\" marginwidth=0 marginheight=0 scrolling=no>"+
  "<frame src=\"\" name=\"frTabs\" marginwidth=0 marginheight=0 scrolling=no>"+
  "</frameset></frameset><plaintext>";

 with (document) {
  open("text/html","replace");
  write(szHTML);
  close();
 }
Snap5.jpg
ASKER CERTIFIED SOLUTION
Avatar of Michel Plungjan
Commented:
This problem has been solved!
Unlock 1 Answer and 16 Comments.
See Answers