Please help me to change array id to new array id

Dear All,

Please help me:

ex: now i have an array

id value

(1) "abc"
(2) "def"
(3) ""
(4) ""

Now, i need the array as:

id value

(0) "abc"
(1) "def"
(2) ""
(3) ""

so, i'm a new bee in VBA.
Please, help me.

Originally Posted by AlphaFrog

How are you creating your array? Can you shoe your code?

Formula:

Please Login or Register  to view this content.

Now, the id now
ex:
(1) abc.xls
(2) abcd.xls

I need change an array to:

(0) abc.xls
(1) abcd.xls

Thanks you so much for your answer.

hi guangnv, welcome to Excelforum, I would not even ask why you need that strange "conversion":

Please Login or Register  to view this content.

Originally Posted by watersev

hi guangnv, welcome to Excelforum, I would not even ask why you need that strange "conversion":

Please Login or Register  to view this content.

Thank sir for your answer.
I mean that, in VBA can support change array as following:

m_listOutputFiles(1) : "xyz.xls"
m_listOutputFiles(2) : "abc.xls"

=>

m_listOutputFiles(0) : "xyz.xls"
m_listOutputFiles(1) : "abc.xls"

Maybe try something like this...

Please Login or Register  to view this content.

This will split all the .xls files within the string tempname into a zero based array.

Originally Posted by AlphaFrog

Maybe try something like this...

Please Login or Register  to view this content.

This will split all the .xls files within the string tempname into a zero based array.

Thank you so much for your answer.
I will try it. :D.