VBA Guru's can you convert this php snippet to VBA ?

[stevedemo]

I have a routine on one of my websites that grabs a CSV file and parses it, I then extract the info I need.

$handle = fopen($csvfilename, "r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$num = count($data);
echo $data[1]." ".$num;
// so some more stuff
}
fclose($handle);

My main question is this: is there a similar command for the fgetcsv in VBA or a module I can import ?


Thanks !!

Steve

All I want is the chance to prove money won't make me happy.

 

[TheAceMan1]

How are ya stevedemo . . .

I don't know php but you can use the [blue]TransferText[/blue] method to import the file into fields in a table, then pick the table apart as you like. The table can be temporary or fixed.

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[stevedemo]

TheAceMan1,

I will give that a try and let you know if I was able to make it work.

Thanks for the tip.

Steve

All I want is the chance to prove money won't make me happy.

 

[TheAceMan1]

stevedemo . . .

In any code module open the [blue]immediate window[/blue] (hit [blue]Ctrl + G[/blue] or select the

toolbar button). Enter [blue]TransferText[/blue] (one word), put the cursor on the word and hit [blue]F1[/blue] . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886