Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Opens the text file named Data13 txt in the folder z

Sub format()     Workbooks.Open Filename:="z:\transfer\Data13.txt", Format:=6, Delimiter:="!" End Sub