<div>
Na, I posted a question in the Java section. I thought a I'd do a quick visit here.<br />
Also need to get min 3k points. Gonna be a case of popping in and out. 
</div>


Na, I posted a question in the Java section. I thought a I'd do a quick visit here.
Also need to get min 3k points. Gonna be a case of popping in and out.

<div>
Excellent answer, both. I like the ShellExecute more because of the the reference that should be used in Harfangs solution.<br />
<br />
thanks Leon 
</div>


Excellent answer, both. I like the ShellExecute more because of the the reference that should be used in Harfangs solution.

thanks Leon

<div>
<div class="content wysiwyg-content">
I'd like to open a excel workbook based on a template (xlt) from access. I'm using this code:<br />
<br />
&nbsp; If CanRead(es_RealisatieDT) = True Then<br />
&nbsp; &nbsp; &nbsp; Application.FollowHyperlin<wbr />k cdbDataPad &amp;&nbsp;&quot;Slabloon\Realisatie_001.x<wbr />lt&quot;<br />
&nbsp; &nbsp; End If<br />
&nbsp; End If<br />
<br />
Instead of opening a xls based on the xlt this code opens the xlt.<br />
<br />
Any suggestions<br />
<br />
gr Leon
</div>
</div>


I'd like to open a excel workbook based on a template (xlt) from access. I'm using this code:

  If CanRead(es_RealisatieDT) = True Then
      Application.FollowHyperlink cdbDataPad & "Slabloon\Realisatie_001.xlt"
    End If
  End If

Instead of opening a xls based on the xlt this code opens the xlt.

Any suggestions

gr Leon

using Application.FollowHyperlink to open a xls based on a xlt

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.

Microsoft Access

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.