Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Solved: Vba code to enter password


(!)

DataBase's Avatar
DataBase DataBase is offline
Computer Specs
Member with 456 posts.
 
Join Date: Jan 2004
Experience: Intermediate
04-Aug-2012, 07:57 AM #16
Also check if you have all these references checked. see attached.
Attached Thumbnails
Solved: Vba code to enter password-p2.jpg  
Teacherless's Avatar
Teacherless   (John) Teacherless is offline
Computer Specs
Member with 89 posts.
THREAD STARTER
 
Join Date: Jun 2012
Location: South Coast, South Africa.
Experience: Beginner
04-Aug-2012, 09:09 AM #17
Hi, yes, I have just checked, and they are all ticked, as you can see by my last screen shots. The only difference is that yours has a Microsoft Office 14 Object Library and mine an Office 12. Shouldn't make a difference though. The "Trust Access Box " is ticked, as I work a lot with macros and I had to tick it a long time ago. I am starting to feel guilty now because this problem is taking up a lot of your time and we haven't fixed it yet. But still, it's a learning curve for us all.
Cheers John.
DataBase's Avatar
DataBase DataBase is offline
Computer Specs
Member with 456 posts.
 
Join Date: Jan 2004
Experience: Intermediate
04-Aug-2012, 09:16 AM #18
Dont worry about it mate as you said its all learning for all of us. Did you check if you had that file in c:\program files ...... In the reply i sent earlier?
Teacherless's Avatar
Teacherless   (John) Teacherless is offline
Computer Specs
Member with 89 posts.
THREAD STARTER
 
Join Date: Jun 2012
Location: South Coast, South Africa.
Experience: Beginner
04-Aug-2012, 09:34 AM #19
Yes, just checked, all there. (See Att)
Attached Thumbnails
Solved: Vba code to enter password-ms-common.jpg  
Teacherless's Avatar
Teacherless   (John) Teacherless is offline
Computer Specs
Member with 89 posts.
THREAD STARTER
 
Join Date: Jun 2012
Location: South Coast, South Africa.
Experience: Beginner
04-Aug-2012, 09:37 AM #20
Hi again, just wondered about our time zone differences, I'm in South Africa and the time here is 15.36hrs. What are your "Specs"?
DataBase's Avatar
DataBase DataBase is offline
Computer Specs
Member with 456 posts.
 
Join Date: Jan 2004
Experience: Intermediate
04-Aug-2012, 11:48 AM #21
Hi,

im in the UK, London, time here is 16:43...

There are 3 things i am going to suggest, try these in this order one of them should hopefully work.

1) manually select the Vbe6ext.olb file from the VBE console. see the attached picture. from the VB editior under tools > references click browse and go to where the file is, then select it. once you have done that, you will have to find it within the list and tick it.

2) try to register the file. All library files need to be registered, sometime something wrong and the files are not registered. to register the file to the following.

click Start > type Run > press enter

now type the following

regsrv C:\Program Files\Common Files\microsoft shared\VBA\VBA6\Vbe6ext.olb

make sure that path is correct to where the file is on your machine.....

3) try to download the Visual Basic runtime

http://www.microsoft.com/en-us/downl....aspx?id=24417
Attached Thumbnails
Solved: Vba code to enter password-untitled.jpg  
Teacherless's Avatar
Teacherless   (John) Teacherless is offline
Computer Specs
Member with 89 posts.
THREAD STARTER
 
Join Date: Jun 2012
Location: South Coast, South Africa.
Experience: Beginner
05-Aug-2012, 03:05 AM #22
Vba code to enter password
Mornin DataBase, I'm trying your suggestions out with a fresh mind after a good nights sleep. Ok, suggestion No1. I did this, everything seems normal there. Suggestion 2, I typed in the run box the address you gave but I think that there must be a slight mistake here as I got the message back(see att) that the address could be wrong. The path is correct, just the "regsrv" bit may not be correct. I have a feeling that once this operation is carried out successfully, things will improve.
Cheers, John
Attached Thumbnails
Solved: Vba code to enter password-2012-08-05_084617.jpg  
DataBase's Avatar
DataBase DataBase is offline
Computer Specs
Member with 456 posts.
 
Join Date: Jan 2004
Experience: Intermediate
05-Aug-2012, 05:45 AM #23
Morning mate,

Ahh yes iv made an error in that, sorry must have been half asleep. Try regsvr32
Teacherless's Avatar
Teacherless   (John) Teacherless is offline
Computer Specs
Member with 89 posts.
THREAD STARTER
 
Join Date: Jun 2012
Location: South Coast, South Africa.
Experience: Beginner
05-Aug-2012, 06:30 AM #24
Hi, I copied the address into Wordpad, edited it, then copied and pasted it into the run box. Another message appears now. See att.
Attached Thumbnails
Solved: Vba code to enter password-2012-08-05_122439.jpg  
DataBase's Avatar
DataBase DataBase is offline
Computer Specs
Member with 456 posts.
 
Join Date: Jan 2004
Experience: Intermediate
07-Aug-2012, 04:02 AM #25
Hi Teacherless,

Try this. Open windows explorer then go to the file vbe6ext.olb.

now open another instance of windows explorer and navigate to where regsvr32.exe is located (do a search)

now drag the vbe6ext.olb file over regsvr32.exe

i am hoping this will allow you to register it..


one question, within your workbook, in the VBE window, did you try to browse for the vbe6ext.olb file like i mentioned in my previous reply? and if you did what happen? that should have worked...... once you have browsed for it and added it, you will need to go and tick the checkbox next to the entry

"microsoft visual basic extensibility 5.3"

did you do that?
Teacherless's Avatar
Teacherless   (John) Teacherless is offline
Computer Specs
Member with 89 posts.
THREAD STARTER
 
Join Date: Jun 2012
Location: South Coast, South Africa.
Experience: Beginner
07-Aug-2012, 06:20 AM #26
Hi DataBase, thanks for getting back to me. I found the vbe6ext.olb file and the regsvr32.exe file ok and dragged like you said. Then I got the attached message. I think Bill Gates has put a curse on all SA imports of Windows7.
Cheers, John
Attached Thumbnails
Solved: Vba code to enter password-2012-08-07_121438.jpg  
DataBase's Avatar
DataBase DataBase is offline
Computer Specs
Member with 456 posts.
 
Join Date: Jan 2004
Experience: Intermediate
07-Aug-2012, 06:39 AM #27
ok will need to look into that, not sure what is causing that. May need a different way to register it.

however, what about browsing for it like i have said before, what happen?
Teacherless's Avatar
Teacherless   (John) Teacherless is offline
Computer Specs
Member with 89 posts.
THREAD STARTER
 
Join Date: Jun 2012
Location: South Coast, South Africa.
Experience: Beginner
07-Aug-2012, 08:36 AM #28
Ok, I whent into the vba console, browsed, found and selected the Vbe6ext.olb file, then ticked the Microsoft Visual Basic for Applications Extensibility 5.3 box, which was not ticked. I then opened the workbook that you sent, opened the vba editor and tried to run the 3 macros there but got the same message each time. See att.
Cheers, and thanks for your persistence, John
Attached Thumbnails
Solved: Vba code to enter password-2012-08-07_140802.jpg  
DataBase's Avatar
DataBase DataBase is offline
Computer Specs
Member with 456 posts.
 
Join Date: Jan 2004
Experience: Intermediate
07-Aug-2012, 08:55 AM #29
Have a look at this

http://support.microsoft.com/kb/840926


in references, look for any entery that has the word MISSING before it and delete it from the list.
Teacherless's Avatar
Teacherless   (John) Teacherless is offline
Computer Specs
Member with 89 posts.
THREAD STARTER
 
Join Date: Jun 2012
Location: South Coast, South Africa.
Experience: Beginner
07-Aug-2012, 10:01 AM #30
Hi DataBase, quite an interesting article, however, they were referencing Windows Xp and I am using Windows 7, don't know if that makes any difference or not. I checked through the references twice very carefully but didn't find any that where missing. I think that you can enter this problem in the Olympic Games while it's in the UK, you'd get a gold, I'm sure.
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑