a very urgent help in VBA
 

Hello all

i have to run this follwoing command(dos command) through VBA

LogDataComposer /i D:\MDT\input\CombinedFile.DLIS /o D:\MDT\output\ /b
D:\MDT\channel_filter.txt

after running this command there will be some files like
a.dlis
b.dlis
c.dlis

into the output folder from above command.

Now I want to run one more command(dos command) through VB but
But I want that the green colour(a.dlis) in the follwing command get
changes if we are having more files in the output folder ,else just run
once .

d2a /ascii C:\MDT\output\a.DLIS/dlis C:\MDT\output\a.DLIS /odf
C:\MDT\MDT.odf


now suppose I get ascii file from this command ,now I want to convert
that in excel sheet


Plz it is ver urgent
reply to

looking desperately for suggestion