<div>
Is the flat file a text file?<br />
<br />
Then it would be:<br />
<br />
dim strTemp as str<br />
<br />
Open &quot;&lt;textfile&gt;.txt&quot; for Input as #1<br />
line input #1, strTemp<br />
<br />
hyperlink &quot;<a href="http://mymachine/documentation/tables/" rel="ugc">http://mymachine/documentation/tables/</a>&quot;&nbsp;&amp; strTemp <br />
<br />
I don't know the exact code for a hyperlink as i am not at my desk.<br />

</div>


Is the flat file a text file?

Then it would be:

dim strTemp as str

Open "<textfile>.txt" for Input as #1
line input #1, strTemp

hyperlink "http://mymachine/documentation/tables/ [http://mymachine/documentation/tables/]" & strTemp

I don't know the exact code for a hyperlink as i am not at my desk.


<div>
remember to <br />
<br />
Close #1<br />
<br />
the textfile
</div>


<div>
Don't know anything about it but it looks good. &nbsp;Will try it this weekend. &nbsp;Thanks
</div>


Don't know anything about it but it looks good.  Will try it this weekend.  Thanks

<div>
<div class="content wysiwyg-content">
My question is similar to q10259657. &nbsp;I want to take a flat text file say file01, which contains two columns. <br />
aaa &nbsp; 12345 <br />
bbb &nbsp; 12312 <br />
ccc &nbsp; 212ab <br />
I want to transform the aaa, bbb etc into a hyperlink consisting of a constant string say <br />
'<a href="http://mymachine/documentation/tables/aaa.htm'" rel="ugc">http://mymachine/documentation/tables/aaa.htm'</a> and do the same for each line in the file. &nbsp;<br />
What is some VB code that will do this?
</div>
</div>


My question is similar to q10259657.  I want to take a flat text file say file01, which contains two columns. 
aaa   12345 
bbb   12312 
ccc   212ab 
I want to transform the aaa, bbb etc into a hyperlink consisting of a constant string say 
'http://mymachine/documentation/tables/aaa.htm' and do the same for each line in the file.  
What is some VB code that will do this?

VB/Frontpage ????

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.