[RESOLVED] Dos Output into excel

[wussupbuddy]

i'm trying to get a dos screen output imported to excel...how will go about doing this??

[RobDog888]

[color=navy]Whats the source in DOS? You could probably just pipe it out to a text file and then read that into Excel.

Dir C:\ > C:\DirCListing.txt

[wussupbuddy]

its a dos based program so i cannot route it to a notepad. i have seen a colleague of mine doing the same but he is not willing to share the source code

[RobDog888]

Ok, then you may be able to use the ReadConsole or AllocConsole API. Check out the definitions and examples over at allapi.net.

[wussupbuddy]

i have his file but i have no clue where his code is..it works flawlessly..if u can gimme ur mail id i'll pass on the file...perhaps u tell me how the file works

[RobDog888]

Is it an exe file or ???

[wussupbuddy]

its an excel file with a command button. the moment you click on the button it gets the data from the dos application that we use

[RobDog888]

As long as he didnt reference a dll of his we can check out the code. Send me a PM tomorrow when you
have some time and we can arrange some time to checkout the file.

[wussupbuddy]

i don't whether it has a ref or not...wats a PM

[dglienna]

PM is a private message. Click Private Messages at the top of the forum page, and then click Send a new private message (on the left) and add Robdog888's username, a subject, and a message.

He'll get it when he logs on, and may get an email when it's delivered.

[wussupbuddy]

ok..i finally got into the file using a vba password cracker....when i right click on the button to view the code it asks for vba project password..none of the freewares are able to crack this one...any ideas

[wussupbuddy]

hey somebody help me out with this...want to unlock the project password for excel worksheet

[RobDog888]

So your saying that the xls file itself had a password to open it in Excel?
If that was the password you cracked then you need to use the program on
the vba project password too. Its a different one and may take a different
program to expose the password. VBA Password Recovery should do it.

[wussupbuddy]

i've already tried that...it says no password to crack!!!!!

[RobDog888]

Then maybe he wrote his own protection for the vba.

[wussupbuddy]

naah.. he ain't that genius....i guess i'm missing something....i sent u a pm yesterday...how abt u checking the file???...don't worry it ain't a virus

[RobDog888]

Attach it to a post and I'll post back when I download it so you can remove the attachment.

[wussupbuddy]

i've attached the file..you need to change the extension to txt so as to open with excel....

[RobDog888]

Got it. Click "Edit" on the post with the attachment so you can remove it if you have any concerns.

I will look into it. Is it already cracked for opening the workbook? If not could you send me the pasword via PM?

Thanks

[RobDog888]

Nevermind I got the file open but we need the password for the vba editor. VBA Password Recovery didnt work on it?

[wussupbuddy]

yeah..vba password recovery didn't work on it

[RobDog888]

Which program did you use?

[wussupbuddy]

advanced vba password recovery

[RobDog888]

Try some other ones too.

If this is for work you could get at the code in your code repository (SoruceSafe, etc).

[wussupbuddy]

won't work....i don't have an admin rights on my pc...don't have a pc at home yet as i have recently moved...and this is related to work but can't be revealed as this is kinda stealing code

[wussupbuddy]

you hit on anythin yet...i'm waitin anxiously

[RobDog888]

No, without knowing the password we can not do much about it. You could just try using different recovery
programs until one works.

[wussupbuddy]

i've tried watever freeware i got on the net which doesn't need an admin id to be installed.....can u suggest some crack software which tries brute force on the screen which asks for the password?

[RobDog888]

Not really, since I dont have any resources like that.

This is a gray area where it could or could not be considered ethical or within the AUP.

[wussupbuddy]

i'm just curious how he did it cos i 'm also workin on a similar project..i

[RobDog888]

I know what you mean. What you could do is determine the logic used and research the mechanics
needed to duplicate it.

Take it one piece at a time, that makes it easier.