Log in problem to XLA add-in file

[Tiernobyl]

Alright people, a bit of a strange problem here. Can't find anything on the web about this, so I've signed up here hoping that one of you can help

Our organisation is currently upgrading the network OS from Windows 2000 to Vista. One of the users has a .xla file that they access in Excel, using a username and password. Now before you think it's something to do with breaking the password, it isn't.

The problem is that since changing over to Vista, the username and password (that we know) is being rejected with a bad password error. The file can only be opened when you are logged in as the the user on the old Windows 2000 PC. I've tried logging in as myself to that PC, and cannot access the file using the username and password. This makes the problem seem like it is profile specific.

My question then really is, how is this possible? Can you tie the specific user to the file as well as password protecting it? Is there a specific registry key that needs to be copied to the new profile on the new Vista PC, or any other specific files from the users profile?

I can see the code in the XLA, if that's any help.

Thanks for you help!

[tony h]

I guess we need more detail.
Exactly what steps do you take to open it (and in combination with other items) on the old machine.
And what exactly what steps do you take on the new, and what exactly is the error message.

I would also look at all of the Auto_ routines and Workbook events to see if any additional checks are being done there.

It is certainly quite possible to do checks on the specific user/machine and close looking like a simple password failure.

[Richard Schollar]

Hi & Welcome to the Board!

You can see the code in the xla file? What is the point of the password then?

Is the password required to open the file or just to access the functions? Conceivably there could be some code to check username etc that may be OS specific, but I can't see that being likely if you can view the code.

If the code isn't proprietary then go ahead and psot it and I'm sure one of us will be able to modify it so that a password isn't required.

Richard

[Tiernobyl]

You deleted the replies because the title needed updated?

Pretty severe moderating for a forum.....

[romperstomper]

I don't know if the title's been edited yet, but here goes...

Are you saying you log into the .xla file, or that it provides a login dialog for other workbooks (or some other purpose)?
If you can see the code in the .xla, is there a routine there that looks like a password routine?

[DonkeyOte]

Yes, replies were deleted, now reinstated.

Severe, perhaps, but I would hope you'd agree that asking for people to read & follow the rules is not too great a burden...

[Tiernobyl]

I don't know if the title's been edited yet, but here goes...

Are you saying you log into the .xla file, or that it provides a login dialog for other workbooks (or some other purpose)?
If you can see the code in the .xla, is there a routine there that looks like a password routine?

I have edited it

Currently the xla is not set as a permanent add-in in Excel. When you open the file, a login dialog is provided. If logged in successfully another menu is presented alongside the others, allowing access to other files (.oiw files - logs).

I can see the code, and there is a routine that looks like a password routine.

[Tiernobyl]

This code?

Please Login or Register  to view this content.

[romperstomper]

You deleted the replies because the title needed updated?

Pretty severe moderating for a forum.....

I guess you've never been to OzGrid...


What code, if any, is behind frmLogon?

[Tiernobyl]

Thought you might ask....

Please Login or Register  to view this content.

[romperstomper]

It's looking in the registry for username and password here:

Please Login or Register  to view this content.

I assume gcstrRegPath is a global constant and gstrName is a global variable, so you will need to find out their values, then check the registry on the old PC and recreate the needed values (since it doesn't appear to allow a blank password)