+ Reply to Thread
Results 1 to 15 of 15

Need to create network related macros in excel

  1. #1
    Registered User
    Join Date
    09-06-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    11

    Red face Need to create network related macros in excel

    I need to create some macros :-

    1) I want to put some computer names in 1st columns of excel sheet , there i want one button in that excel sheet when i press that button then these computer names will get ping in command prompt and corresponding status will get displayed in the another column.

    2)Macro in excel sheet to get disk space status.

    3)Macro in excel sheet to get service status for a particular application .


    I know these are network related macros , if someone have knowledge that will be a great help.



    Thanks

    Guru
    Last edited by mobile_guru; 09-06-2012 at 04:43 AM.

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Some tweeks in excel

    Google ping with vbscript. VBscript is sufficiently similar to VBA to be able to adapt the scripts you find to work in Excel with minimal changes

  3. #3
    Registered User
    Join Date
    09-06-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Some tweeks in excel

    i have one batch script that is working fine with the text files , i mean i am putting computer names in one text file and getting status in another text files but i need this in some different way as i want to use two colums of excel , as you told that VB script can help so can i put these vb script as macro any suggestions .

    Quote Originally Posted by Kyle123 View Post
    Google ping with vbscript. VBscript is sufficiently similar to VBA to be able to adapt the scripts you find to work in Excel with minimal changes

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Some tweeks in excel

    Yes, I understand what you are looking to do. But you haven't really provided enough detail, find the vbscript that does what you want (I guarantee that it exists) and try to adapt it. Post back with working vbscript if you get stuck and we can adapt to Excel

  5. #5
    Valued Forum Contributor Macdave_19's Avatar
    Join Date
    03-14-2007
    Location
    Birmingham, England
    MS-Off Ver
    12.0
    Posts
    808

    Re: Some tweeks in excel

    THis should give you a starting point:
    Please Login or Register  to view this content.
    Last edited by Macdave_19; 09-06-2012 at 05:24 AM.
    Mr MaGoo
    Magoo.Inc MMVII

    If i've helped please add to my Rep by Clicking on the Blue Scales in the top right hand corner of the post

  6. #6
    Registered User
    Join Date
    09-06-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Some tweeks in excel

    I understand , but i am searching for some tweaks in the excel and this excel contain lot of things , but as you told i have changed the title if u think its again not up to the rule remind me .

    regards
    guru

    Quote Originally Posted by Richard Buttrey View Post
    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.

  7. #7
    Registered User
    Join Date
    09-06-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Some tweeks in excel

    can you help in getting the script for service check and free disk space check.

    Quote Originally Posted by Macdave_19 View Post
    THis should give you a starting point:

    Sub PingME()

    Dim Cmd As Object
    Dim cell As Range

    Set Cmd = CreateObject("Wscript.Shell")

    For Each cell In Range("MyComputers")
    Cmd.Run ("Ping " & cell.Value)
    Next cell

    End Sub

  8. #8
    Valued Forum Contributor Macdave_19's Avatar
    Join Date
    03-14-2007
    Location
    Birmingham, England
    MS-Off Ver
    12.0
    Posts
    808

    Re: Need to create macros in excel

    I know you can use "fsutil volume diskfree C:" to get the disk space on a pc but I''m not sure how to edit this to work with other PC's?

  9. #9
    Registered User
    Join Date
    09-06-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Some tweeks in excel

    I am noob in excel programming , can you help me ...with the ping script used in this post to get macro created ...


    Quote Originally Posted by Kyle123 View Post
    Yes, I understand what you are looking to do. But you haven't really provided enough detail, find the vbscript that does what you want (I guarantee that it exists) and try to adapt it. Post back with working vbscript if you get stuck and we can adapt to Excel

  10. #10
    Registered User
    Join Date
    09-06-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Some tweeks in excel

    I developed the working VB code can you help me in inserting that code to excel...

    Quote Originally Posted by Kyle123 View Post
    Yes, I understand what you are looking to do. But you haven't really provided enough detail, find the vbscript that does what you want (I guarantee that it exists) and try to adapt it. Post back with working vbscript if you get stuck and we can adapt to Excel

  11. #11
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Need to create network related macros in excel

    Sure, let's see it then...

  12. #12
    Registered User
    Join Date
    09-06-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Need to create network related macros in excel

    Please Login or Register  to view this content.
    -----------------------
    2 Spreadsheet)

    Please Login or Register  to view this content.
    Quote Originally Posted by Kyle123 View Post
    Sure, let's see it then...
    Last edited by mobile_guru; 10-01-2012 at 12:59 AM.

  13. #13
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Need to create network related macros in excel

    Unfortunately your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  14. #14
    Registered User
    Join Date
    09-06-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Need to create network related macros in excel

    Thanks i have done as you told.

    Quote Originally Posted by Richard Buttrey View Post
    Unfortunately your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

  15. #15
    Registered User
    Join Date
    09-06-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Need to create network related macros in excel

    Any update regarding that excel ?


    Quote Originally Posted by Kyle123 View Post
    Sure, let's see it then...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1