You are not logged in.

VBAProject passwort prompt after quiting Excel caused by Palo

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

ChristianS

Professional

  • "ChristianS" started this thread

Posts: 20

Date of registration: Dec 20th 2007

  • Send private message

1

Thursday, December 20th 2007, 11:11am

VBAProject passwort prompt after quiting Excel caused by Palo

Hi,

After running a macro that passes a reference for a workbook containing a password-protected VBA project to an ActiveX dynamic-link library (DLL), you are prompted for the VBA project password when Excel quits. (source: http://support.microsoft.com/kb/280454/en-us)

Under following conditions the Palo-Excel-Addin causes an VBA project password prompt:

1. Palo-Addin is loaded (manual or automatic)
2. Excelsheets contain Paloformulas (e.g. PALO.DATAC)
3. Excelworkbook is password protected
4. Excelworkbook contains userforms and userforms are shown at least once during runtime
5. Data has been passed to the palo server service
6. Worksheet has been calculated

-> After closing Excel is prompting for the vba password of the workbook.

If you don't want to give your users the password it is a big problem.

Anybody out there experienced the same or even has a solution for that problem? My solution to load/unload the palo Addin via VBA didn't work due to insuffiecent user rights on the operating system...

greetings
Christian

Michael Koch

Intermediate

  • "Michael Koch" is male

Posts: 8

Date of registration: Mar 20th 2007

  • Send private message

2

Thursday, December 20th 2007, 4:11pm

Hi ChristianS.

Is it sure, that Palo is the cause for the prompting? Can you reproduce this with if the Add-In is not loaded ?

Regards Michael.

ChristianS

Professional

  • "ChristianS" started this thread

Posts: 20

Date of registration: Dec 20th 2007

  • Send private message

3

Thursday, December 20th 2007, 4:20pm

I'm sure that it is caused by Palo. It is reproduceable only with Palo and the same steps without Palo are not causing any problems.

Tests on other Excelversion (Excel 2000 and 2003) lead to the same results/problems.

This post has been edited 3 times, last edit by "ChristianS" (Dec 21st 2007, 8:27am)

Enno

Palo Team

  • "Enno" is male

Posts: 56

Date of registration: Dec 13th 2007

  • Send private message

4

Friday, December 21st 2007, 12:07pm

I tried it on my own system (WinXP SP1) and did not have that promt showing up.
After installing SP2 for WinXP it started to show up. I guess it has something to do with security measures in SP2 for Windows.
But after all you can just click on the 'Cancel' button and it disappears without needing the password.

h_decker

Sage

  • "h_decker" is male

Posts: 763

Date of registration: Oct 26th 2005

Location: Cologne, Germany

  • Send private message

5

Friday, December 21st 2007, 12:14pm

I recognized that with several vba-projects so its does not seem to be a PALO-specific things. It happens from time to time and i cannot reproduce the behaviour.

Holger

ChristianS

Professional

  • "ChristianS" started this thread

Posts: 20

Date of registration: Dec 20th 2007

  • Send private message

6

Friday, December 21st 2007, 1:28pm

Hi,

at least I am not the only one ;)

@h_decker: It can be caused also by other code (see Microsoft KB), but in my case it was definitly reproduceable and caused by Palo. I got the error in my constellation (see also above) EVERY TIME and when I switched off Palo the problem disappeared...

@Enno: Depending on the "not-relaesed memory objects" (supposing) you have to click several times on the cancel button. Do you seriously want to explain this to your users? For me this is definitely unsatisfiying...

If it helps I can try to create a demo database the next days (after Christmas) and provide my Excel file...

Thanks for your comments...
Christian

icke

Intermediate

Posts: 5

Date of registration: Mar 27th 2008

  • Send private message

7

Monday, June 16th 2008, 3:20pm

@ PALO,
this problem is undissolved!
please help

jsteinauer

Intermediate

Posts: 5

Date of registration: Nov 7th 2010

  • Send private message

8

Tuesday, April 17th 2012, 12:53am

Hi,

I'm facing basically the same problem, Christian described. I have installed PALO for Excel 3.2 Community, Build 5096.

Under the following conditions the Palo-Excel-Addin causes a VBA project password prompt:

1. Palo-Addin is loaded (setting: 'manual load with the Palo shortcut' / with setting 'automatical load with the Excel application', this problem does not occur)
2. VBAProject is password protected
3. Excelworkbook contains a userform and the userform is shown at least once during runtime

-> After closing Excel - the VBA password prompt occurs.

As there is also a conflict between the PALO Excel AddIn and the SAP BW Excel AddIn, the 'automatical load with the Excel application' ist not a valid solution for this problem.

Any ideas, workarounds ? Any help is much appreciated !

Regards,
Jürg Steinauer

This post has been edited 1 times, last edit by "jsteinauer" (Apr 17th 2012, 12:59am)

Rate this thread