|
PureBytes Links
Trading Reference Links
|
<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.2614.3401" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#d8d0c8>
<DIV><FONT size=2>
<P><FONT size=2>Do check the Save File Type options-list again, now by scrolling
down this tiny list, eg use<BR>the "<STRONG>Save as type</STRONG>:"-list's
scroll-button (that is available on the right of the listed options) to<BR>have
you move further down the list.<FONT size=2></P>
<P><FONT size=2>Here, my Excel's 4.0 worksheet-option is listed as the 8th
option down from the top (see<BR>"Excel.gif") and it is also the 8th option
given out of the total-list of 29 (!) save options available<BR>to
user.</FONT><FONT size=2>The 10th option available is saving to Excel 2.0 (!).
This is done so, as Microsoft wants<BR>and likes to keep all of its customers
and users happy (eg this downside compatibility), eg<BR>especialy
those in companies, that are "all well" working on the same type of (for Excel
version "x")<BR>platform/network).</FONT><FONT size=2> </FONT></P>
<P><FONT size=2>The Downloader (or MetaStock, as being "officialy" Office
97-compliant) just fits the bill here.<BR>But also only merely!. And that
for such a technologicaly advanced program (and as most<FONT
size=2><BR></FONT></FONT><FONT size=2>of its users are also (being very critical
by nature!) technical analysts as well), this Excel-stuff<BR>is then also a
plain disgrace (on) to the Equis' firm, eg as it has also been (so)
very poorly<BR>addressed by its developers (+
programmers).</FONT></FONT></FONT></P><FONT size=2>
<P><FONT color=#ff0000><A name=dex67><STRONG><FONT
color=#000000>Other mail's content: </FONT>(basic info)</STRONG></A></FONT>
<P>1. File format compatability Office 4.x (Excel 4.0) and Office 97 PRO
(Excel 97 = also v8.0)
<P>2. Sharing (Saving) Excel 4.0 workbooks (sheets)
<P>3. Chapter C - Excel Policy (and Windows Policy) for Excel 97
(settings). </P>
<P>Regards,<BR>Ton Maas<BR><A
href="mailto:ms-irb@xxxxxxxxxxxxx";>ms-irb@xxxxxxxxxxxxx</A><BR>Dismiss the
".nospam" bit (including the dot) when replying.</FONT> </P>
<P>-----------------------------------------------------------------------------------------------------------------------------
<P><FONT size=4><B><A name=CH002H206>File Format
Compatibility</A></B></FONT> ( <A
href="http://www.microsoft.com/office/ork/022/022.htm";>http://www.microsoft.com/office/ork/022/022.htm</A> )
<P>Because some of the file formats for Office have changed since Office
4.<I>x</I> and Office 95, then the Office 97 (Windows) and Office 98
(Macintosh) include features that make it easier for users to work together when
using different versions of Office.
<P><FONT size=3><B>Default Save</B></FONT>
<P>Users can determine which file format to use as the default when saving a
file. A Microsoft Excel 97 user who shares files with an Excel version 5.0
user may choose Excel 5.0 format, while another user who does not often
share files may choose to stay with Excel 97 format. You can also set the
default format for all Office applications in your organization using a system
policy in Windows 95 or Windows NT Workstation 4.0, or by using
custom Preference files on the Macintosh.
<P><B><FONT color=#0000ff size=2>For More
Information </FONT></B>about the default format to use when
saving an Office document, see "<A
href="http://www.microsoft.com/office/ork/022/022.htm#CH022H101";>Specifying the
Default Format in Which to Save Office Documents</A>" in Chapter 22,
"Supporting Multiple Versions of Microsoft Office". For information about how
workbooks are converted to previous versions of Excel, see "Sharing
Workbooks with Microsoft Excel 4.0" in Chapter 12, "<A
href="http://www.microsoft.com/office/ork/012/012.htm";>Upgrading from Previous
Versions of Microsoft Excel</A>". </P>
<P>-----------------------------------------------------------------------------------------------------</P>
<P><FONT size=5><B><A name=CH012H106>Sharing Workbooks with Microsoft
Excel 4.0</A></B></FONT> </P>
<MENU>
<MENU>
<P><A name=dex51></A>
<P>If your workgroup is upgrading gradually to Excel 97 (Windows) or
Excel 98 (Macintosh), some users may have to share documents with users
of Excel 4.0. Excel 97 and 98 users can save their documents in
Excel 4.0 format.
<P><B><FONT color=#0000ff><IMG alt="" border=0 height=10
src="file:///D:/office/ork/art/Proced.gif" width=5> To save a workbook in
Excel 4.0 format</FONT></B>
<P>
<OL>
<P>
<LI>On the <B>File</B> menu, click <B>Save As</B>.
<P></P>
<LI>a. To save the entire workbook, in the <B>Save as type</B> box
(Windows) or <B>Save file as type</B> box (Macintosh), click <B>Microsoft
Excel 4.0 Workbook</B>.
<P>– or –
<P>b. To save only the active sheet, in the <B>Save as type</B> box
(Windows) or <B>Save file as type</B> box (Macintosh), click <B>Microsoft
Excel 4.0 Worksheet</B>. </P></LI></OL></MENU></MENU>
<P>Note that when saving in Excel 97, saving to Excel 4.0 format can have
drastic consequenses for the workbook's contents. For more information see the
Office 97 Help.</P>
<P>-----------------------------------------------------------------------------------------------------</P>
<P>Below are excerpts from <FONT color=#0000ff><STRONG>the Chapter
C-file</STRONG></FONT>, that is here localy stored
("\microsoft\support\WIN95\Office\Office-Updates US\AppC.htm").</P>
<P>If you are upgrading from Excel version 4.0 or 5.0 or Excel 95, this chapter
answers these questions for you. Some platforms and versions of Excel share the
same file format.<BR> -To convert a workbook from an earlier version
of Excel to Excel 97 or Excel 98, simply open the workbook. Excel handles
the conversion automatically.<BR> -To complete the conversion, save
the workbook in Excel 97 or Excel 98 format.<BR> -To convert several
documents at once to Excel 97 format, you can use the File Conversion
Wizard, which is supplied with Excel 97.</P>
<P>"This appendix describes how to use Windows system policies to modify
registry settings used by Microsoft Office 97 applications.<BR>Windows system
policies are supported by Windows 95(9.x) and Windows NT Workstation version
4.x(5.x) only. The Macintosh operating system does not support system
policies". </P>
<P><FONT size=3><STRONG>Excel Policies</STRONG></FONT>
<P><A name=dex17></A>
<P>The following user setting policies are used by Excel. These appear under the
<B>Excel 97</B> heading in the System Policy Editor.
<P><B>User\Excel 97\Tools_Options\General\Alternate Startup Folder</B>
<P>This policy specifies that the alternate startup folder should be used for
default workbook or worksheet templates. If the file Book.xlt is in the
alternate startup folder, it is copied when the user clicks the <B>New</B>
command (<B>File</B> menu). Similarly, if the user clicks the <B>Worksheet</B>
command (<B>Insert </B>menu), Excel looks for Sheet.xls in the alternate startup
folder. You can use these templates to specify such worksheet elements as fonts
and page formatting for printing.
<P><B>User\Excel 97\Tools_Options\Transition\Default Save</B>
<P>This policy is used to set the default format in which to save Excel
workbooks. Valid formats include the following:
<UL type=square>
<P>
<LI>Microsoft Excel 97 Workbook
<P></P>
<LI>Microsoft Excel 97 & 5.0/95 Workbook
<P></P>
<LI>Microsoft Excel 5.0/95 Workbook
<P></P>
<LI>Microsoft Excel 4.0 Workbook
<P></P>
<LI>Microsoft Excel 4.0 Worksheet
<P></P>
<LI>Microsoft Excel 3.0 Worksheet
<P></P>
<LI>WK4 (1­2­3)
<P></P>
<LI>WK3, FM3 (1­2­3)
<P></P>
<LI>WK3 (1­2­3)
<P></P>
<LI>WK1, FMT (1­2­3)
<P></P>
<LI>WK1, ALL (1­2­3)
<P></P>
<LI>WK1 (1­2­3)
<P></P>
<LI>WKS (1­2­3)
<P></P>
<LI>WQ1 (QuattroPro/DOS) </LI></UL>
<P><B>User\Excel 97\Miscellaneous\Personal Toolbars</B>
<P>Custom toolbar settings are stored in <I>Username</I>8.xlb, which is located
in the Excel folder. Use this policy to change the location for the XLB file. If
there is no XLB file in the new location, Excel creates one. The location can be
a local folder, or you can set it to a folder on a network server.
<P>When you enter the new location, be sure to include the trailing backslash
(\) as shown here:
<P><I>server</I><B>\</B><I>share</I><B>\</B><I>folder\</I>
<P><B>User\Excel 97\Miscellaneous\Chart Gallery</B>
<P>This policy specifies the path to a custom chart gallery. The file name is
Xlusrgal.gra.
<P><FONT color=#0000ff size=2><B>Note </B></FONT>This policy
applies only to Excel. The policy <B>User\Office\Common\Chart Gallery</B> is a
similar policy for other Office applications; that policy uses the file name
Grusrgal.gra.
<P><FONT size=3><B>Outlook Policies</B></FONT> </P></FONT></DIV>
<DIV><FONT
size=2>--------------------------------snip--------------------------------------------</FONT></DIV>
<DIV><BR> </DIV>
<DIV> </DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
Joseph Ehardt </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> A.J. Maas </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> dinsdag 25 mei 1999 6:31</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: Convert Excel 97 data to
MS</DIV>
<DIV><BR></DIV>
<DIV><FONT size=2>Ton Maas,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>In explaining how to convert Excel files into MetaStock
files, you note that the Excel data file should be saved in 4.0 format.
However, my Excel 97 under Windows 98 does not offer that option. In the
attached gif you </FONT><FONT size=2>can see that only 5.0 and later
formats are possible, but the Downloader manual clearly states that 4.0 is
needed. So the latest version of Downloader (6.52) can't handle anything but
ancient formats of Excel data that are now unsupported by Microsoft? As a
computer scientist, this seems pretty absurd for a commercial product. What
don't I know?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>Thanks,</FONT></DIV>
<DIV><FONT size=2>Joe</FONT> </DIV></BLOCKQUOTE></BODY></HTML>
</x-html>
Attachment Converted: "c:\eudora\attach\excel.gif"
|