Open ASP files in Excel

[Crocdundee]

Hi , I am here again looking for help.
I have asp files in a folder ranging between 7 and 12 in total.
Can someone help me append each file to a excel worksheet with VBA code
files are like this
neural.asp
neural.asp(2)
neural.asp(3)
Etc etc
Folder is C:\users\grah\download
File is like this covering 20 fields

<table width="863" border="0" cellpadding="0" cellspacing="0"><col style="width: 17pt;" width="22"> <col style="width: 50pt;" width="67"> <col style="width: 21pt;" width="28"> <col style="width: 35pt;" width="47"> <col style="width: 17pt;" width="23"> <col style="width: 20pt;" width="27"> <col style="width: 67pt;" width="89"> <col style="width: 156pt;" width="208"> <col style="width: 17pt;" width="23"> <col style="width: 17pt;" width="22"> <col style="width: 23pt;" width="30"> <col style="width: 16pt;" width="21"> <col style="width: 17pt;" width="23"> <col style="width: 16pt;" width="21"> <col style="width: 17pt;" width="23"> <col style="width: 20pt;" width="27"> <col style="width: 20pt;" width="26"> <col style="width: 16pt;" width="21" span="2"> <col style="width: 23pt;" width="30"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; width: 17pt;" width="22" height="20">Tb</td> <td class="xl63" style="width: 50pt;" width="67">Horse</td> <td class="xl63" style="width: 21pt;" width="28">NR</td> <td class="xl63" style="width: 35pt;" width="47">APrice</td> <td class="xl63" style="width: 17pt;" width="23">BP</td> <td class="xl63" style="width: 20pt;" width="27">WT</td> <td class="xl63" style="width: 67pt;" width="89">Jockey</td> <td class="xl63" style="width: 156pt;" width="208">Trainer</td> <td class="xl63" style="width: 17pt;" width="23">CP</td> <td class="xl63" style="width: 17pt;" width="22">CF</td> <td class="xl63" style="width: 23pt;" width="30">Tim</td> <td class="xl63" style="width: 16pt;" width="21">JA</td> <td class="xl63" style="width: 17pt;" width="23">TA</td> <td class="xl63" style="width: 16pt;" width="21">JT</td> <td class="xl63" style="width: 17pt;" width="23">BP</td> <td class="xl63" style="width: 20pt;" width="27">WT</td> <td class="xl63" style="width: 20pt;" width="26">Crs</td> <td class="xl63" style="width: 16pt;" width="21">D</td> <td class="xl63" style="width: 16pt;" width="21">$</td> <td class="xl63" style="width: 23pt;" width="30">DLR</td> <td style="width: 48pt;" width="64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; width: 17pt;" width="22" align="right" height="20">1</td> <td class="xl63" style="width: 50pt;" width="67">Cats Fun</td> <td class="xl63" style="width: 21pt;" width="28" align="right">244</td> <td class="xl64" style="width: 35pt;" width="47" align="right">$2.25</td> <td class="xl63" style="width: 17pt;" width="23" align="right">2</td> <td class="xl63" style="width: 20pt;" width="27" align="right">68</td> <td class="xl63" style="width: 67pt;" width="89">Brad Mc Lean</td> <td class="xl63" style="width: 156pt;" width="208">Jarrod Mclean</td> <td class="xl63" style="width: 17pt;" width="23" align="right">84</td> <td class="xl63" style="width: 17pt;" width="22" align="right">0</td> <td class="xl63" style="width: 23pt;" width="30" align="right">0</td> <td class="xl63" style="width: 16pt;" width="21" align="right">20</td> <td class="xl63" style="width: 17pt;" width="23" align="right">8</td> <td class="xl63" style="width: 16pt;" width="21" align="right">3</td> <td class="xl63" style="width: 17pt;" width="23" align="right">9</td> <td class="xl63" style="width: 20pt;" width="27" align="right">38</td> <td class="xl63" style="width: 20pt;" width="26" align="right">29</td> <td class="xl63" style="width: 16pt;" width="21" align="right">36</td> <td class="xl63" style="width: 16pt;" width="21" align="right">18</td> <td class="xl63" style="width: 23pt;" width="30" align="right">0</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; width: 17pt;" width="22" align="right" height="20">2</td> <td class="xl63" style="width: 50pt;" width="67">Chatillion</td> <td class="xl63" style="width: 21pt;" width="28" align="right">121</td> <td class="xl64" style="width: 35pt;" width="47" align="right">$6.00</td> <td class="xl63" style="width: 17pt;" width="23" align="right">3</td> <td class="xl63" style="width: 20pt;" width="27" align="right">68</td> <td class="xl63" style="width: 67pt;" width="89">A Lynch</td> <td class="xl63" style="width: 156pt;" width="208">Eric Musgrove</td> <td class="xl63" style="width: 17pt;" width="23" align="right">8</td> <td class="xl63" style="width: 17pt;" width="22" align="right">0</td> <td class="xl63" style="width: 23pt;" width="30" align="right">0</td> <td class="xl63" style="width: 16pt;" width="21" align="right">10</td> <td class="xl63" style="width: 17pt;" width="23" align="right">3</td> <td class="xl63" style="width: 16pt;" width="21" align="right">13</td> <td class="xl63" style="width: 17pt;" width="23" align="right">6</td> <td class="xl63" style="width: 20pt;" width="27" align="right">29</td> <td class="xl63" style="width: 20pt;" width="26" align="right">29</td> <td class="xl63" style="width: 16pt;" width="21" align="right">22</td> <td class="xl63" style="width: 16pt;" width="21" align="right">2</td> <td class="xl63" style="width: 23pt;" width="30" align="right">0</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; width: 17pt;" width="22" align="right" height="20">3</td> <td class="xl63" style="width: 50pt;" width="67">Gravitas</td> <td class="xl63" style="width: 21pt;" width="28" align="right">168</td> <td class="xl64" style="width: 35pt;" width="47" align="right">$3.90</td> <td class="xl63" style="width: 17pt;" width="23" align="right">4</td> <td class="xl63" style="width: 20pt;" width="27" align="right">68</td> <td class="xl63" style="width: 67pt;" width="89">Trent Wells</td> <td class="xl63" style="width: 156pt;" width="208">Fran Houlahan & Brian Johnston</td> <td class="xl63" style="width: 17pt;" width="23" align="right">2</td> <td class="xl63" style="width: 17pt;" width="22" align="right">0</td> <td class="xl63" style="width: 23pt;" width="30" align="right">0</td> <td class="xl63" style="width: 16pt;" width="21" align="right">20</td> <td class="xl63" style="width: 17pt;" width="23" align="right">3</td> <td class="xl63" style="width: 16pt;" width="21" align="right">20</td> <td class="xl63" style="width: 17pt;" width="23" align="right">20</td> <td class="xl63" style="width: 20pt;" width="27" align="right">40</td> <td class="xl63" style="width: 20pt;" width="26" align="right">29</td> <td class="xl63" style="width: 16pt;" width="21" align="right">29</td> <td class="xl63" style="width: 16pt;" width="21" align="right">5</td> <td class="xl63" style="width: 23pt;" width="30" align="right">0</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; width: 17pt;" width="22" align="right" height="20">4</td> <td class="xl63" style="width: 50pt;" width="67">Sarem</td> <td class="xl63" style="width: 21pt;" width="28" align="right">115</td> <td class="xl64" style="width: 35pt;" width="47" align="right">$7.50</td> <td class="xl63" style="width: 17pt;" width="23" align="right">1</td> <td class="xl63" style="width: 20pt;" width="27" align="right">68</td> <td class="xl63" style="width: 67pt;" width="89">Paul Hamblin</td> <td class="xl63" style="width: 156pt;" width="208">Katrina Harnett</td> <td class="xl63" style="width: 17pt;" width="23" align="right">9</td> <td class="xl63" style="width: 17pt;" width="22" align="right">0</td> <td class="xl63" style="width: 23pt;" width="30" align="right">0</td> <td class="xl63" style="width: 16pt;" width="21" align="right">8</td> <td class="xl63" style="width: 17pt;" width="23" align="right">3</td> <td class="xl63" style="width: 16pt;" width="21" align="right">8</td> <td class="xl63" style="width: 17pt;" width="23" align="right">20</td> <td class="xl63" style="width: 20pt;" width="27" align="right">8</td> <td class="xl63" style="width: 20pt;" width="26" align="right">29</td> <td class="xl63" style="width: 16pt;" width="21" align="right">29</td> <td class="xl63" style="width: 16pt;" width="21" align="right">2</td> <td class="xl63" style="width: 23pt;" width="30" align="right">0</td> <td>
</td> </tr> </tbody></table>----------------------------------------------------------------------
any help would be appreciated in this
Regards
Graham

 

[Ruddles]

ASP as in Active Server Pages?

Do the files contain HTML?

Are you saving them from a Web site?

 

[Crocdundee]

Ok, first thank you for the reply.
Yes I am saving them from a web site
The button says click to save to CSV
But it is not a csv
In properties it says open with Excel

the site is
http://www.racingandsports.com.au/form-guide/
on a track Gosford....click on the "Wheel Icon" on the right
then on the bottom is the csv button

Regatds
Graham

 

[Ruddles]

In common with many organisations, my company blocks Web sites of that nature so I can't check the page.

What do the contents of the file look like when opened with Notepad?

Paste between CODE tags and if there are any < characters, make sure you insert a space immediately after each of them.

 

[Crocdundee]

<table><tr><td>Tb</td><td>Horse</td><td>NR</td><td>APrice</td><td>BP</td><td>WT</td><td>Jockey</td><td>Trainer</td><td>CP</td><td>CF</td><td>Tim</td><td>JA</td><td>TA</td><td>JT</td><td>BP</td><td>WT</td><td>Crs</td><td>D</td><td>$</td><td>DLR</td></tr><tr><td>1</td><td>Cats Fun</td><td>244</td><td>$2.25</td><td>2</td><td>68.0</td><td>Brad Mc Lean</td><td>Jarrod

etc etc

Graham

 

[Crocdundee]

Thats funny
In notepad it had <Table><tr><td>TB</<TD><TD>Horse

Etc etc
when I cut and pasted it it came out as in last messages I posted

Grah

 

[Norie]

Graham

It sounds like they are CSV files, especially if you can use Excel to open them.

In fact when I press the CSV button it asks me if I want to download a file called neural.xls.

When I opened the file it had the same format as the data you posted.

Can you double-check what type of files you have?

 

[Crocdundee]

yes I have a file saved as neural.asp
but I think it is neural.asp.xls

Regards
Graham

 

[Ruddles]

O.
M.
G!

What have you done?!