[RESOLVED] Dos Output into excel

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

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

VB Code:

Dir C:\ > C:\DirCListing.txt

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 :(

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

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

Is it an exe file or ???

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

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.

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

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.

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

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

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.

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

Then maybe he wrote his own protection for the vba. :(

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 ;)

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

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

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

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

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

Which program did you use?

advanced vba password recovery

Try some other ones too.

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

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 ;)

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

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

:(

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?

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. :(

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

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.