<div>
For starters, you should place your code in a try statement: 
 

<pre><code class="code-10 nolinks" id="code-20-42367733-1">try
 Dim config As New MarketplaceWebServiceConfig
 config.ServiceURL = &quot;https://mws.amazonservices.co.uk&quot;
 Dim myClient As New MarketplaceWebServiceClient(AccessKey, SecretKey, ApplicationName, ApplicationVersion, config)
 Dim myRequest As New GetReportRequest
 myRequest.Merchant = SellerID
 myRequest.ReportId = reportId
 myRequest.Report = File.Open(&quot;C:\\report\&quot; + reportId.ToString + &quot;.txt&quot;, FileMode.OpenOrCreate, FileAccess.ReadWrite)
 Dim myResponse As New GetReportResponse
 myResponse = myClient.GetReport(myRequest)
catch ex as exception
 response.write(&quot;Failed to access file and got the following error: &quot; + ex.message)
 'or some other type of code to handle the error.
end try
</code></pre>
 
Since it looks like this is a web app, you should be writing this to the database and then perhaps write another program that pulls the information from the database and writes it to a file. &nbsp;The program can be a console program that gets called from the task scheduler. &nbsp;This will prevent more than one program from accessing files at the same time.
</div>

<div>
Something like this is what I have been looking at for a similar project. &nbsp;Reviews are good and you can just plug it into the router. 
 
<a href="https://www.amazon.com/NETGEAR-LTE-Modem-Broadband-Connection/dp/B01N5ASNTE/ref=sr_1_2?ie=UTF8&qid=1510678769&sr=8-2&keywords=cellular+router" rel="ugc">https://www.amazon.com/NETGEAR-LTE-Modem-Broadband-Connection/dp/B01N5ASNTE/ref=sr_1_2?ie=UTF8&qid=1510678769&sr=8-2&keywords=cellular+router</a>
</div>

<div>
Hi, 
 
In your code, make sur that any opened file is properly closed, even if errors happen (check error handlers). 
 
But, if the file is opened by an external process, there isn't much you can do, beside handling and reporting the error, so the user can try again. 
 
Somes might say that you can try to read it again after a little amount of time, but that's running the risk of locking your application forever (what if the file is locked bc of a crash ? Or was never properly closed ?)
</div>

<div>
Okay, some mixed suggestions there. 
 
Joe: that's a fair point - I've omitted the Try Catch in my sample code for simplicity (I have it in my main code). 
However, this part of the code works fine, without error. 
It is only the addition of an attempt to read back from the file immediately afterwards that fails. 
Your second comment just seemed to be a link to buy a router! 
 
Fabrice: there should be no external process which accesses the file. &nbsp;I agree any open file should be closed. &nbsp;My question is about how I wait for the action of writing to the file to end before closing the file and attempting to read the file back. 
I could do a wait/retry loop but is there some other way of waiting for the previous task (writing to the file) to complete before moving on to the next file open / read commands?
</div>

<div>
Sorry, I had a lot of tabs open and the link was for another post. &nbsp;I deleted it.
</div>

<div>
Hi Beamson; 
 
This line of code opens the file for read/write and assigns the return a FileStream to myRequest.Report at which point you relinquish control of the open file to the object myRequest. In that object it should close the file when it is finished using it so that calls to read it from other parts of your app does not fail. 

<pre><code class="code-1 nolinks" id="code-20-42368001-1">myRequest.Report = File.Open(&quot;C:\\report\&quot; + reportId.ToString + &quot;.txt&quot;, FileMode.OpenOrCreate, FileAccess.ReadWrite)
</code></pre>
I assume that after this line of code is executed the myRequest object has completed using the file and should have closed it.
<pre><code class="code-1 nolinks" id="code-20-42368001-2"> myResponse = myClient.GetReport(myRequest)
</code></pre>
</div>

<div>
<blockquote>
should have closed it
</blockquote>
 
I agree, the file should be closed but for some reason it is not. 
If I debug the sub with a long system.threading value (few minutes) and then try to access the textfile I get the same problem. 
 
If I debug it with no system.threading value, let is fail, then open the same file from another subroutine, it opens fine. &nbsp;It is as though the process that creates and writes to the file is not releasing the file once written to. 
 
If I separate the writing and reading back of the text file into two separate subs and run them in the same debugging session, they also fail with the same error when reading back. &nbsp;I feel as though I need to explicitly release the file somewhere but don't know where or how.
</div>

<div>
Please post the class myRequest here. 
 
Thanks
</div>

<div>
<pre><code class="code-1 nolinks" id="code-20-42376978-1"> Dim myRequest As New GetReportRequest
</code></pre>
 

<pre><code class="code-1 nolinks" id="code-20-42376978-2">myRequest.Merchant = SellerID
 myRequest.ReportId = reportId
 myRequest.Report = File.Open(MyPath+ reportId.ToString + &quot;.txt&quot;, FileMode.OpenOrCreate, FileAccess.ReadWrite)
</code></pre>
 

<pre><code class="code-10 nolinks" id="code-20-42376978-3">Imports System
Imports System.IO
Imports System.Xml.Serialization
Imports MarketplaceWebService.Attributes

Namespace MarketplaceWebService.Model
 &lt;MarketplaceWebService(RequestType:=RequestType.DEFAULT, ResponseType:=ResponseType.STREAMING)&gt; &lt;XmlRoot([Namespace]:=&quot;http://mws.amazonaws.com/doc/2009-01-01/&quot;, IsNullable:=False)&gt; &lt;XmlType([Namespace]:=&quot;http://mws.amazonaws.com/doc/2009-01-01/&quot;)&gt;
 Public Class GetReportRequest
 Public Sub New()

 &lt;Obsolete(&quot;Not used anymore. MWS ignores this parameter, but it is left in here for backwards compatibility.&quot;)&gt; &lt;XmlElement(ElementName:=&quot;Marketplace&quot;)&gt;
 Public Property Marketplace As String
 &lt;XmlElement(ElementName:=&quot;Merchant&quot;)&gt;
 Public Property Merchant As String
 &lt;XmlElement(ElementName:=&quot;MWSAuthToken&quot;)&gt;
 Public Property MWSAuthToken As String
 &lt;MarketplaceWebServiceStream(StreamType:=StreamType.RECEIVE_STREAM)&gt;
 Public Property Report As Stream
 &lt;XmlElement(ElementName:=&quot;ReportId&quot;)&gt;
 Public Property ReportId As String

 &lt;Obsolete(&quot;Not used anymore. MWS ignores this parameter, but it is left in here for backwards compatibility.&quot;)&gt;
 Public Function IsSetMarketplace() As Boolean
 Public Function IsSetMerchant() As Boolean
 Public Function IsSetMWSAuthToken() As Boolean
 Public Function IsSetReport() As Boolean
 Public Function IsSetReportId() As Boolean
 &lt;Obsolete(&quot;Not used anymore. MWS ignores this parameter, but it is left in here for backwards compatibility.&quot;)&gt;
 Public Function WithMarketplace(marketplace As String) As GetReportRequest
 Public Function WithMerchant(merchant As String) As GetReportRequest
 Public Function WithMWSAuthToken(mwsAuthToken As String) As GetReportRequest
 Public Function WithReport(report As Stream) As GetReportRequest
 Public Function WithReportId(reportId As String) As GetReportRequest
 End Class
End Namespace
</code></pre>
</div>

<div>
Where is the implementation for this?
<pre><code class="code-1 nolinks" id="code-20-42377015-1">Public Function WithReport(report As Stream) As GetReportRequest
</code></pre>
</div>

<div>
Not sure how to answer that question. &nbsp;The classes are provided as part of one of Amazon's dlls. &nbsp;Will take a look tomorrow and see what I can find when I'm at my desk.
</div>

<div>
That did the trick! 
 
I'd tried variations of that but was focusing on closing the response objects rather than the request ones. 
Your way worked immediately. 
 
Thanks for all of your help!
</div>

<div>
Not a problem Beamson, glad I was able to help.
</div>

<div>
<div class="content wysiwyg-content">
I'd like to read the report or text file generated below (3rd from last line) into a textbox: 

<pre><code class="code-1 nolinks" id="code-10-29068371-1"> Dim config As New MarketplaceWebServiceConfig
 config.ServiceURL = &quot;https://mws.amazonservices.co.uk&quot;
 Dim myClient As New MarketplaceWebServiceClient(AccessKey, SecretKey, ApplicationName, ApplicationVersion, config)
 Dim myRequest As New GetReportRequest
 myRequest.Merchant = SellerID
 myRequest.ReportId = reportId
 myRequest.Report = File.Open(&quot;C:\\report\&quot; + reportId.ToString + &quot;.txt&quot;, FileMode.OpenOrCreate, FileAccess.ReadWrite)
 Dim myResponse As New GetReportResponse
 myResponse = myClient.GetReport(myRequest)
</code></pre>
 
If I add a final line: 

<pre><code class="code-1 nolinks" id="code-10-29068371-2">myTextbox.text = File.ReadAllText(&quot;C:\\report\&quot; + reportId.ToString + &quot;.txt&quot;)
</code></pre>
I get &quot;The process cannot access the file &quot;xxx&quot; because it is being used by another process.&quot; 
 
What do I need to do to ensure the file is written to and closed before attempting to read from it?
</div>
</div>

I'd like to read the report or text file generated below (3rd from last line) into a textbox:
(CODE)

If I add a final line:
(CODE)
I get "The process cannot access the file "xxx" because it is being used by another process."

What do I need to do to ensure the file is written to and closed before attempting to read from it?

VB - ensuring a text file is written to and closed before opening to read from it

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,