View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] amit.sainioct@googlemail.com is offline
external usenet poster
 
Posts: 1
Default 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