View Single Post
  #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