https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/172404&feed=atom&action=history
Microsoft KB Archive/172404 - Revision history
2024-03-28T18:31:41Z
Revision history for this page on the wiki
MediaWiki 1.39.3
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/172404&diff=344283&oldid=prev
X010: Text replacement - """ to """
2020-07-21T10:06:49Z
<p>Text replacement - """ to """</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en-GB">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 10:06, 21 July 2020</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l58">Line 58:</td>
<td colspan="2" class="diff-lineno">Line 58:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>For a workaround, modify the Source argument for the OpenRecordset method from FILENAME#XLS to FILENAME$. Please see below for an illustration.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>For a workaround, modify the Source argument for the OpenRecordset method from FILENAME#XLS to FILENAME$. Please see below for an illustration.</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><pre class="codesample"> Set db = OpenDatabase(<del style="font-weight: bold; text-decoration: none;">&quot;</del>c:\file.xls<del style="font-weight: bold; text-decoration: none;">&quot;</del>, False, False, <del style="font-weight: bold; text-decoration: none;">&quot;</del>Excel 4.0;HDR=NO;<del style="font-weight: bold; text-decoration: none;">&quot;</del>)</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><pre class="codesample"> Set db = OpenDatabase(<ins style="font-weight: bold; text-decoration: none;">"</ins>c:\file.xls<ins style="font-weight: bold; text-decoration: none;">"</ins>, False, False, <ins style="font-weight: bold; text-decoration: none;">"</ins>Excel 4.0;HDR=NO;<ins style="font-weight: bold; text-decoration: none;">"</ins>)</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div> Set rs = db.OpenRecordset(<del style="font-weight: bold; text-decoration: none;">&quot;</del>file$<del style="font-weight: bold; text-decoration: none;">&quot;</del>)</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> Set rs = db.OpenRecordset(<ins style="font-weight: bold; text-decoration: none;">"</ins>file$<ins style="font-weight: bold; text-decoration: none;">"</ins>)</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> </pre></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> </pre></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
</table>
X010
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/172404&diff=91454&oldid=prev
3155ffGd: importing KB archive
2020-07-18T15:36:33Z
<p>importing KB archive</p>
<p><b>New page</b></p><div><div id="nsbanner"><br />
<br />
<div id="bannerrow1"><br />
<br />
{|<br />
| Knowledge Base<br />
|<br />
|}<br />
<br />
<br />
</div><br />
<div id="TitleRow"><br />
<br />
= <span id="KB172404"></span>PRB: Opening Excel 4.0 Worksheets with DAO =<br />
<br />
<br />
</div><br />
<br />
</div><br />
<div id="nstext" valign="BOTTOM"><br />
<br />
Article ID: 172404<br />
<br />
Article Last Modified on 2/21/2005<br />
<br />
<br />
-----<br />
<br />
APPLIES TO<br /><br />
<br /><br />
<br />
* Microsoft Visual Basic 6.0 Learning Edition<br />
* Microsoft Visual Basic 5.0 Learning Edition<br />
* Microsoft Visual Basic 6.0 Professional Edition<br />
* Microsoft Visual Basic 5.0 Professional Edition<br />
* Microsoft Visual Basic 6.0 Enterprise Edition<br />
* Microsoft Visual Basic 5.0 Enterprise Edition<br />
* Microsoft Visual Basic 5.0 Control Creation Edition<br />
<br />
<br />
-----<br />
<br />
<div class="notice_section"><br />
<br />
This article was previously published under Q172404<br />
<br />
</div><br />
<div class="symptoms_section"><br />
<br />
== SYMPTOMS ==<br />
<br />
Opening an entire Excel 4.0 Worksheet, according to the syntax described in Books Online and according to the syntax used in all previous versions of Visual Basic, will cause Run-time error '3011.'<br />
<br />
</div><br />
<div class="resolution_section"><br />
<br />
== RESOLUTION ==<br />
<br />
For a workaround, modify the Source argument for the OpenRecordset method from FILENAME#XLS to FILENAME$. Please see below for an illustration.<br />
<pre class="codesample"> Set db = OpenDatabase(&quot;c:\file.xls&quot;, False, False, &quot;Excel 4.0;HDR=NO;&quot;)<br />
Set rs = db.OpenRecordset(&quot;file$&quot;)<br />
</pre><br />
<br />
</div><br />
<div class="status_section"><br />
<br />
== STATUS ==<br />
<br />
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.<br />
<br />
</div><br />
<div class="moreinformation_section"><br />
<br />
== MORE INFORMATION ==<br />
<br />
The syntax specified in Books Online for working with Excel Worksheets and Workbooks is consistent with the documentation for all previous versions of Visual Basic.<br /><br />
<br /><br />
Other than opening entire Excel 4.0 Worksheets, no other problems are known to exist at this time. In fact, opening a named range in an Excel 4.0 Worksheet will work just as described.<br />
<br />
</div><br />
<br /><br />
<br />
Additional query words: kbVBp500 kbVBp kbWinOS98 kbDSupport kbdse kbDAO kbVBp600 kbExcel400<br />
<br />
Keywords: kbprb KB172404<br />
<br />
<div class="footer"><br />
<br />
<br /><br />
<br />
<br />
-----<br />
<br />
[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]<br />
<br />
<span>© Microsoft Corporation. All rights reserved.</span><br />
<br />
<br />
</div><br />
<br />
</div></div>
3155ffGd