Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
jaf jaf is offline
external usenet poster
 
Posts: 300
Default using sendkey to enter vbe password in Excel 2000

Hi Jose,
Compiled executable?
Are you trying to access the VBA IDE or VB6 IDE?
A compiled VB6 prog. has no IDE.


--

John

johnf202 at hotmail dot com


"jose" wrote in message
...
Hi there!

Got a problem and would like some help. Where I work we
have many predesigned excel spreadsheets used by
engineering types to store stuff for each job that they
work on. A vb program is used to find and launch the same
sample.xls file in its' job# folder. In order to update
the sample.xls worksheet with a new combo box and the code
associated with it, I used the vb program that launches
the excel stuff to add said cb and code. In addition, the
newer sample.xls spreadsheets VBE windows were assigned a
password so that our engineers would not gp into design
maode and screw things up. To get into the code at
runtime I used the sendkey command to do :
alt,t,e,"password",enter,enter. This has works in Windows
98. In Windows 2000, it works fine while you're in the
IDE. However, if you run the compiled executable it
apparently does not. I get a "Error: 50289 Can't perform
operation since the project is protected" message. I
searched and found some keyboard driver problem that
causes the keyboard to freeze and SP2 fixes. I applied
SP4 for Win 2000 and SP6 for VS/VB6. It stills does not
work on Win 2000. Anyone have a handle on this problem?
Got any ideas? Help, please!

Jose aka Joe



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting password on worksheet in Excel 2000 Bill[_2_] Excel Worksheet Functions 1 February 14th 07 07:05 PM
sendkey help needed Ryk Excel Discussion (Misc queries) 4 November 6th 06 04:50 AM
User not being prompted to enter Password to modify Excel 2003 kmorl Excel Discussion (Misc queries) 2 October 20th 06 05:32 PM
Excel 2000 Invoice Template Macro Password? Bill Excel Discussion (Misc queries) 1 December 16th 05 10:29 PM
Linking to a Password Protected Document in Excel 2000 Andrew Excel Discussion (Misc queries) 2 February 15th 05 01:06 AM


All times are GMT +1. The time now is 10:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"