User Profile

Collapse

Profile Sidebar

Collapse
beginner4e
beginner4e
Last Activity: Jun 20 '07, 08:47 PM
Joined: Jun 12 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • beginner4e
    replied to How can I pull up data from the Command Prompt using VBA?
    in Access
    I will try...Honestly, I don't know anything about these API functions, but I will definately check it out. Thank you! If you come up with another idea, please let me know.

    Thanks again!...
    See more | Go to post

      Leave a comment:

    • beginner4e
      replied to How can I pull up data from the Command Prompt using VBA?
      in Access
      I thought about it, but I am still using the command prompt and my goal is to transfer all the activities to VBA. And also if I had 150 uses, then i would have 150 txt files that the code had to process. And also the .txt file is taking just the current info, but what if tomorrow somebody using the command prompt changed part of their info...then the program wouldnt give correct info...

      I thought that it would be a good way to do...
      See more | Go to post

        Leave a comment:

      • beginner4e
        replied to How can I pull up data from the Command Prompt using VBA?
        in Access
        ok, I will try to explain again.

        So, I have data in the Command Prompt - userIDs, names...whateve r. I want to create a code in VBA that will execute the Command Prompt, and let me extract data the same way I would in the Command Prompt.

        So, let's say I am in the command prompt and I am trying to see a specific user info, then i just open the program and type: net user userID /domain. and i get all the info of this person...
        See more | Go to post

          Leave a comment:

        • beginner4e
          replied to How can I pull up data from the Command Prompt using VBA?
          in Access
          I thought of creating it as a file, but then I will not be able to manipulate the date. I want to be able to extract data even if the data has been changed in the Command Prompt. I thought also that I could use the Shell function, but all it does (or it did for me) is reading the first line from MS Office, and it doesnt go any further. What I want to do is, write a code, so that i can get an userID from the command propmt with all his information....
          See more | Go to post

            Leave a comment:

          • beginner4e
            started a topic How can I pull up data from the Command Prompt using VBA?
            in Access

            How can I pull up data from the Command Prompt using VBA?

            hey guys,

            I need to do a program in VBA that runs the command prompt and gets data from there. Then I should be able to manipulate the data in VBA and store it in a table.

            Do you have any suggestions, tips, sample codes, ideas? Any help will be highly appreciated.

            THANK YOU!!!
            See more | Go to post
            • beginner4e
              replied to How can I pull up data from the Command Prompt using VB/VBA
              in Visual Basic
              I just wanted to add that I need to display the data into a listbox and later on I have to manipulate the data. Any suggestions?

              beginner4e...
              See more | Go to post

                Leave a comment:

              • beginner4e
                started a topic How can I pull up data from the Command Prompt using VB/VBA
                in Visual Basic

                How can I pull up data from the Command Prompt using VB/VBA

                hi guys,

                I am trying to pull up some user information from the command prompt using VB. I read a lot about using the shell function and so on and so forth, but I don't really know how to start it. Could you please give me some suggestions? Or sample codes? Here is a part of the code I did:

                p.startinfo.use shellexecute = false
                p.startinfo.red irectstandardou tput = true
                p.startinfo.fil ename = "cmd.exe"...
                See more | Go to post
                No activity results to display
                Show More
                Working...