How can i convert string of file attachments into an array? 1

[Juddy58]

Hi,
Just wondering if anyone has code to convert a string with a list of file attachments eg "C:\Temp\File1.txt; C:\Temp\File2.txt; C:\Temp\File3.txt"
into an array eg,
dim ArrAttachment(4) as string
ArrAttachment(0)= "C:\Temp\File1.txt"
ArrAttachment(1)= "C:\Temp\File2.txt"
ArrAttachment(2)= "C:\Temp\File3.txt"
ArrAttachment(3)= "" 'Only 3 attachments so not used
ArrAttachment(4)= "" 'Only 3 attachments so not used

I have code that I have used before with outlook to create a collection but I now need to do this with an array. Im assuming i need to use instr to search for ";" or something. I thought this would have been done by someone else before. I have done a few searches and havn't come up with anything im after.

Any advice appreciated
thanks
Justin

 

[Remou]

What you need is Split.

[tt]astrFiles=Split(strFiles,";")[/tt]

 

[Juddy58]

To easy Remou, exactly what im after.
Cheers
Justin
and a star!