Visual Basic

Moderators: None (Apply to moderate this forum)
Number of threads: 18011
Number of posts: 55384

This Forum Only
Post New Thread
Single Post View       Linear View       Threaded View      f

Report
Reading who's logged in and running vba Posted by pdunn on 15 Sept 2008 at 9:07 PM
Hello, I have two seperate topics.

1) I would like to make a program that would give the user certain abilities based on, who is logged into Windows. Windows Server 2003 and Visual Basic 6 is being used. I would like to go into the Domain Controller and find out if that person has management rights or not. Or if that is located somewhere locally or an easier way that would work too.

I do not know where to start off from this one. I do not know what the technique is called. Please do offer assistance.

2) There is a vba script file for Microsoft Excel. I wanted to add database connectivity. I was typing in Dim cnConn as new adobd.Connection. Usually when typing that it would show options, but there was no option for adobd and when I use it anyway, I get an error message. I do not know how to work around this, so I was going to make a Visual Basic program. I am not sure if I could just copy and paste vba to a program. I do not believe there are any Excel specific information in the vba. I would like to know, could I just copy and paste vba into a basic program.

Thank you for your help.
Report
Re: Reading who's logged in and running vba Posted by Barkeeper on 16 Sept 2008 at 6:15 AM
For Q1: ActiveDirectory is your friend
For Q2: Do you have checked the reference to the ADO-Object-Classes in your Excel/VBA-References?

: Hello, I have two seperate topics.
:
: 1) I would like to make a program that would give the user certain
: abilities based on, who is logged into Windows. Windows Server 2003
: and Visual Basic 6 is being used. I would like to go into the
: Domain Controller and find out if that person has management rights
: or not. Or if that is located somewhere locally or an easier way
: that would work too.
:
: I do not know where to start off from this one. I do not know what
: the technique is called. Please do offer assistance.
:
: 2) There is a vba script file for Microsoft Excel. I wanted to add
: database connectivity. I was typing in Dim cnConn as new
: adobd.Connection. Usually when typing that it would show options,
: but there was no option for adobd and when I use it anyway, I get an
: error message. I do not know how to work around this, so I was
: going to make a Visual Basic program. I am not sure if I could just
: copy and paste vba to a program. I do not believe there are any
: Excel specific information in the vba. I would like to know, could
: I just copy and paste vba into a basic program.
:
: Thank you for your help.

------------------------------------------
Only stupidity of mankind and the universe
are infinite, but i'm not sure concerning
the universe. A. Einstein



 

Recent Jobs

Official Programmer's Heaven Blogs
Web Hosting | Browser and Social Games | Gadgets

Popular resources on Programmersheaven.com
Assembly | Basic | C | C# | C++ | Delphi | Flash | Java | JavaScript | Pascal | Perl | PHP | Python | Ruby | Visual Basic
© Copyright 2011 Programmersheaven.com - All rights reserved.
Reproduction in whole or in part, in any form or medium without express written permission is prohibited.
Violators of this policy may be subject to legal action. Please read our Terms Of Use and Privacy Statement for more information.
Operated by CommunityHeaven, a BootstrapLabs company.