excel and vbscript, macro ?!

**Lexouille** · 07-30-2009, 05:11 AM

Hi everyone!
I'm knew in excel programming so excuse me if what i ask seems odd.

I have an excel file with servername, and some descriptions attached to this server :
Row1,Row2,Row3,Row4,Row5,...;
SERVER1,OS,IP,MAC ADDRESS,DISKS,....
SERVER2,OS,IP,MAC ADRRESS,DISKS,....

i want to create a marco wich will be able to refresh this informations automatically.
Or if i enter a servername, and run the macro, descriptions informations will be filled automatically in my datasheet.
SERVER3,,,,,, MACRO -> SERVER3,OS,IP,MAC ADDRESS,.....

I have a vbscript that performs this task perfectly.
so i would like to put(somehow) the script in a macro, and it will use the "server cell" to run.

my script use a lot of wmi and ldap request ...

is it possible ? if yes how ?!

Thanks all (:

**Lexouille** · 07-30-2009, 08:21 AM

No one ? :/

**romperstomper** · 07-30-2009, 08:33 AM

Yes, it's possible.
Quite hard to adjust your code unless you post it though. I am many things, but psychic is not one of them!

**Lexouille** · 07-31-2009, 05:29 AM

I found the solution (:
thanks anyway !

**mudraker** · 07-31-2009, 06:13 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

**mudraker** · 07-31-2009, 06:14 AM

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save