<div>
Crystal how would I call or pass the parameters to that code:<br />
<br />
????<br />

<pre><code class="code-10 nolinks" id="code-20-42074209-1"><span>Public Sub CallSaveStringAsTextFile()</span>
<span>SaveStringAsTextFile (&quot;C:\Users\Station\Documents\Access XML Save Files\Test14.xml&quot;)</span>
<span>End Sub</span>
<span></span>
<span>Public Sub SaveStringAsTextFile(psPathFile As String, psFileContents)</span>
<span>'160730 strive4peace</span>
<span>   Dim iFile As Integer</span>
<span>   </span>
<span>   iFile = FreeFile</span>
<span>   Open psPathFile For Output As iFile</span>
<span>   Print #iFile, psFileContents</span>
<span>   Close iFile</span>
<span></span>
<span>End Sub</span>
</code></pre>
<br />
<br />
Lets say this is the code:<br />
<br />
&nbsp;&quot;uahfiuaheuifgha;vghauivgh<wbr />;iuehgfehf<wbr />iaedghewgh<wbr />&quot; _<br />
&amp;&nbsp;&quot;iuasfiuasfhasoieiedoiuesd<wbr />sglueildsu<wbr />gilsudgile<wbr />glisurlvgu<wbr />sli&quot;<br />
<br />
Where would I place it?<br />
<br />
<br />
(&quot;C:\Users\Station\Documen<wbr />ts\Access XML Save Files\Test14.xml&quot;) is where the file output will go. Thanks!
</div>


<div>
Another method (as a &quot;one-liner&quot; statement, just to demonstrate it can be done!)...<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42074216-1"><span>   Code = &quot;uahfiuaheuifgha;vghauivgh;iuehgfehfiaedghewgh&quot; &amp; _</span>
<span>          &quot;iuasfiuasfhasoieiedoiuesdsglueildsugilsudgileglisurlvgusli&quot; &amp; _</span>
<span>          &quot;...&quot;</span>
<span>       </span>
<span>   Call CreateObject(&quot;Scripting.FileSystemObject&quot;).OpenTextFile(&quot;C:\Users\Station\Documents\Access XML Save Files\Test14.xml&quot;, 2&amp;, True).WriteLine(Code)</span>
</code></pre>
</div>


<div>
Just BRILLIANT! Thank you so much!
</div>


<div>
You're welcome.<br />
<br />
Oh.
</div>


<div>
you're welcome, Dustin ~ happy to help<br />
<br />
(fanpages - interesting method -- but might that not leave a dangling object since CreateObject is used?)
</div>


<div>
&quot;(fanpages - interesting method -- but might that not leave a dangling object since CreateObject is used?)&quot;<br />
<br />
Oh yes, I am very aware of that, but once an Exit Sub or End Sub is reached, that <i>should</i> release the resources.<br />
<br />
This is not the method I would use; I just wanted to demonstrate it didn't need to be excessive.<br />
<br />
I would choose, as I suspect you were suggesting, closing the objects (where necessary), &amp;&nbsp;setting them to Nothing.<br />
<br />
Interesting to see <i>PatHartman</i> receive recognition/points when that proposed solution missed the point of the question.
</div>


<div>
thanks, fanpages. &quot;once an Exit Sub or End Sub is reached, that should release the resources&quot; -- not necessarily ...<br />
<br />
Pat has helped Dustin a lot. While the solution turned out to be something else, it was hard to tell what he really wanted from his first post. I'm fine with splitting points. Had Dustin noticed your idea when he was splitting them, you'd probably have gotten an assist too. &nbsp;You were both posting about the same time though.
</div>


<div>
Getting points also surprised me since it turns out that the question wasn't related to Word. &nbsp;Dustin, please don't feel you need to award points for participation. &nbsp;It diminishes the value of the actual awards. &nbsp;I come from an era where people actually earned their trophies so I am not offended to not get points if I didn't contribute to the answer.
</div>


<div>
<blockquote>
thanks, fanpages. &quot;once an Exit Sub or End Sub is reached, that should release the resources&quot; -- not necessarily ...
</blockquote>
<br />
That is why I put <i>should</i> in italics.
</div>


<div>
Crystal<br />

<blockquote>
Pat has helped Dustin a lot.
</blockquote>
 Yes this is VERY TRUE! Thank you!<br />
<br />

<blockquote>
Had Dustin noticed your idea when he was splitting them, you'd probably have gotten an assist too. &nbsp;You were both posting about the same time though.
</blockquote>
Exactly! I had closed it and then seen it right after.<br />
<br />
Pat<br />

<blockquote>
I come from an era where people actually earned their trophies so I am not offended to not get points if I didn't contribute to the answer.
</blockquote>
I totally understand and 99% of the time your solutions work awesome for me so this showed I had no doubt in your solution. Crystals was a dead on quick solution so I chose this as the main solution. But like I said I had no doubt in your answer so it assisted me. I also keep your comments in mind so I can refer back to them when the other solutions do not work for a new problem.<br />
<br />
THANK YOU ALL FOR THE HELP! IT TRULY MEANS ALOT TO ME! THANKS!
</div>


<div>
<div class="content wysiwyg-content">
If I have a Long String of say code 3000 characters or more longer how can I send that to a text document in VBA. The string code will actually be in the VBA module.<br />
<br />
Code = &quot;uahfiuaheuifgha;vghauivgh<wbr />;iuehgfehf<wbr />iaedghewgh<wbr />&quot; _<br />
&amp;&nbsp;&quot;iuasfiuasfhasoieiedoiuesd<wbr />sglueildsu<wbr />gilsudgile<wbr />glisurlvgu<wbr />sli&quot; _<br />
etc........<br />
<br />
About 6 lines on Contionous Code. <br />
<br />
I just need the text file to contain this code.<br />
<br />
Thanks.
</div>
</div>


If I have a Long String of say code 3000 characters or more longer how can I send that to a text document in VBA. The string code will actually be in the VBA module.

Code = "uahfiuaheuifgha;vghauivgh;iuehgfehfiaedghewgh" _
& "iuasfiuasfhasoieiedoiuesdsglueildsugilsudgileglisurlvgusli" _
etc........

About 6 lines on Contionous Code. 

I just need the text file to contain this code.

Thanks.

MS Access VBA How to export string to a text document within VBA

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.