Manually Inputting sucks

[T.O.F.K.A.Z]

Does anybody know of a program taht can replace a certain text , but can replace each of the occurences with a other text defined in a certain list ? (Meaning that It can replace each occurence with a the corresponding number in the list , occurence 1 = text on list place 1)

if so , then I can make very large macro , to take care of my prob.

Might be impossible but ....

As for programming ;

I have to manually input 10000+ Songs (ID,Title,Artist) in a special database using Hitbit which can't copy anything from the excel sheet on which they are all displayed. Problem is it takes ages to do so. I wondered if I couldn't make a programm that would do it like that. I also tried a making a macro for it but I still have to manually enter all the Id's and so. If only there were such a programm.

Any help would be greatly appreciated

[zenogais]

Originally Posted by T.O.F.K.A.Z

Does anybody know of a program taht can replace a certain text , but can replace each of the occurences with a other text defined in a certain list ? (Meaning that It can replace each occurence with a the corresponding number in the list , occurence 1 = text on list place 1)

if so , then I can make very large macro , to take care of my prob.

Might be impossible but ....

As for programming ;

I have to manually input 10000+ Songs (ID,Title,Artist) in a special database using Hitbit which can't copy anything from the excel sheet on which they are all displayed. Problem is it takes ages to do so. I wondered if I couldn't make a programm that would do it like that. I also tried a making a macro for it but I still have to manually enter all the Id's and so. If only there were such a programm.

Any help would be greatly appreciated

That really sucks. You should write your own program because I've never heard of one. Maybe if you give a little bit more info and maybe an example because I don't really understand the question yet. Wish I could be of more help.

[T.O.F.K.A.Z]

Well all the info about our music is stored in an Excel File , but for some reason my superiors want me to put in a special database with the a program called HitBit. I still have about 10000 + songs to go. I have to input their ID , their Title and their Artist. I already made a Macro for it which works , but it's a macro that repeats itself on and on. But the piece where I enterd :

Input ID

Must be changed to the corresponding ID belonging to the song , If I let this macro run he gives the ID the name Input ID . I'm looking for a program what can replace every occurence differntly by using a list for example :

Input ID is found 200 times then it should select 200 different things I inserted to the list ,starting at the top. Unfortunately I can't seem to find any program what so ever which can do so.

I tried making such a programm myself but I ain't so good with my Delphi skills.Hope you know know what I meant.

So you see I open the macro code and then I want to replace the ID's .Title and Artist pieces each time the macro repeats itself.

[scottlc]

Well I seen a PerlScript (ActiveX style host with a Perl brain) which opened up Notepad and entered text. I think that it would be possible with that. Closing pointed brackets removed.

Job Id="WshShell"
script language=PerlScript
    $WshShell = $WScript->CreateObject("WScript.Shell");
    $WshShell->Run("notepad", 5);
    $WshShell->AppActivate("Untitled - Notepad");
    sleep(1); #Allow Notepad to load!
    $WshShell->SendKeys('This is a test! ;)');
/script
/job

[zenogais]

Well I believe that Excel has file encoding just like all MS Office programs, I'm sure that using scotts Perl script and little modification you could get the program to do what you want. Sounds like you did something weird with your Macro and thats why its flaking out on you, but I suppose you could get your macro to read this info from a file. Sounds like you have quite an involved process ahead of you. I'm not much a Perl programmer so I can't really help.

[Nezzar]

Using COM might be a way to do it. Unfortunately, I'm not really familiar with it but some research on http://msdn.microsoft.com might help you.

[scottlc]

From Perl you can use the Spreadsheet::ParseExcel module to load Excel data.

[Kraelis]

Hm... fiddling with a 3rd party program isn't as easy as it seems. Notepad is one thing, and HitBit is entirely another.

The only way I can think of is by... shudder... disassembling the program, find the API handling the input, then make a program the interfaces with it. MAJOR HEADACHE.

In network gaming shops, they sometimes have a program that automatically inputs the password for you when you log on, so I'm pretty sure there's any easier way to do it. Sorry, couldn't be much more help.

[scottlc]

Actually it would work and does (I've tried).

[T.O.F.K.A.Z]

Ahh well thanks for all yor help but I have today created a Macro which actually works I found some kind off strange command to let it gor through a txt file and enter them so .... thanks again for your help but I managed to create something which worked myself.